Getting wrong data from sharepoint list to Azure SQL using ADF

Imam Shaik (Infosys Ltd) 1 Reputation point Microsoft Vendor
2021-02-25T07:46:16.313+00:00

In ADF, While consuming the data from Share point list using "SharePoint Online List" linked service, we are getting the ID's instead of names for the Lookup fields (like Submitter Name, Created Name) in share point. Does anyone facing the same issue.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,478 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,560 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,561 Reputation points
    2021-02-25T08:47:30.447+00:00

    I faced this while connecting and pulling data to Excel directly. Instead of column name - Author, I had to use Author.Title.

    If you are using OData query, try something like this

    ...../items?$select=Author/Title&$expand=Author

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav