How to store sharepoint list columns in an excel using Azure Data Factory

Mansi Yadav 40 Reputation points
2024-06-13T04:29:56.2666667+00:00

We have a sharepoint list that has more than 50 fields and lots of rows. Currently I'm using Web activity where I'm passing /sites/site-id/lists/list-id/items? expand=fields. Thr first field is title, second is organization, etc. But in the output I'm getting fields name as title, field1, field2, etc. I don't know why it's not picking other column names . I'm also handling odata.next link.

Secondly, I want to store these fields in an excel by mapping the fields. How can we do this in adf?

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

1 answer

Sort by: Most helpful
  1. Mansi Yadav 40 Reputation points
    2024-06-13T10:53:34.3166667+00:00

    I'm getting user configuration issue:-

    {"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFail edException' was thrown."}

    I have used below url:-

    siteurl/_api/web/lists/GetByTitle('your-list-title')?$select=Fields&$expand=Fields($select=InternalName, Title)

    https://hclo365.sharepoint.com/sites/Test/Demo/_api/web/lists/GetByTitle('Demo2')?$select=Fields&$expand=Fields($select=InternalName, Title)

    Site name : Test/Demo

    And can you provide complete explanation for data flow activity basically the configuration what exactly I should pass in the source, sink and fiel mapping part

    0 comments No comments