Datafactory to sharepoint list
I've setup a connection from our data factory in azure to a sharepoint site so I can pull some of the lists on the site into blob storage so I can then process into our warehouse. This all works fine and I can see the data I want. I don't however want to pull all the columns contained in the list I'm after. Looking at the connection I can specify a query, however anything I put in here has no affect on the data that comes back. Is there a way to specify the columns from a list in sharepoint through the copy activity into blob storage?
You need to user select query like below -
$select=Title,Number,OrderDate in the Query text field of the Azure Data Factory Source.
You could use Preview Data button to validate the results. Please refer to the documentation for using Custom OData query options.
I have tried this and it works fine for me (see screenshot below)-
Thanks Saurabh
- Accessing Excel file from Sharepoint with R
- "ø" showing instead of "ø" and more
- Trying to Authenticate with SharePoint and get list of files via API using access token
- Find or expand Sharepoint Page titleArea image - Microsoft Graph API
- Update records in a SharePoint List by SQL via VBA/ADO?
- How to call sharepoint api?
- How to convert PowerAutomate approval date stamp to a more readable format
- Connect Azure DevOps Queries to SharePoint List using Power Automate
- Power Automate - 401 Unauthorized at Sharepoint Connector after it worked successfully
- Microsoft Graph API, Add SharePoint List Item suddenly throws exception for null strings
- Why is @microsoft.graph.downloadUrl not populated in HTTP call but works with Graph SDK?
- "Need admin approval" error when using "Sites.Selected" delegated permission for SharePoint document download
- How to retrieve audit logs for sensitivity label application on SharePoint files using Microsoft Graph API?
- Adding hover message to choices in SharePoint
- SharePoint: "Failed to extract the cab file in the solution"
- Azure File is Detected Not Exist While It Actually Exists and Timeout Error
- Why rollback not working in Access linked to sharepoint list
- Move Video File from Azure Blob Storage to Sharepoint site in C#
- PS: Redirecting error output of assignment statement to a variable
- How to send data from one webpart to another webpart using dynamic data in spfx
- Requesting worksheet cell values using Graph API + Python
- Use Sharepoint url parameter in PowerApp
- Datafactory to sharepoint list
- Exporting list of specific Planner IDs to a CSV
- Get email administrators using wss 3.0
- Logic Apps: How to save file from email onto sharepoint
- Synchronizing a Sharepoint Folder to Git
- How to Retrieve DriveItem by Path (Sharepoint) in .NET Using Microsoft Graph API?
- An error occurs when extracting data from a list in a child SharePoint site
- How to use Cloudformation to create an Appflow flow using Microsoft Sharepoint Connector?