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.
10,162 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,268 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,681 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