Getting the SharePoint List's Modied By and Created By in the Azure Data Factory Lookup query

Filip Lisiecki 21 Reputation points
2021-09-10T10:17:03.123+00:00

I am trying to receive from the SharePoint List's columns with names of the 'Created By' and 'Modified By' users. As a default, Lookup activity (and Copy data which I am using) in the ADF doesn't return these fields, only CreatedById and ModifiedById. How can I get these columns?

I was testing different combinations of the 'Query' field in the Lookup, however no luck. I am getting errors or no data...

i.e.
@markus.bohland@hotmail.de ('$select=Title,ModifiedBy/Title&$expand=ModifiedBy') -> getting only the Title column
@markus.bohland@hotmail.de ('$expand=ModifiedBy') -> getting only 'regular' columns, no ModifiedBy

131105-image.png

Is it possible to use the Query field to get that columns? If no, how it could be done?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,891 questions
{count} votes