Pull data from SharePoint List "Created By" column

[stillcloud]

Hi everyone,

When pulling data from a SharePoint list, I found the "Created By" column with text values become numbers in Qlik. The "Created By" (column name in SharePoint) becomes "Author ID" (column name in Qlik).

In SharePoint The "Created By" column value is generated automatically according to SSO information that shows display name of the current user. Hover on it we can see more details about the person, e.g. email address, department, ...

Does anyone know how to get the correct value as display name, and email address?

Thanks.