Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
Azure Data Factory can ingest other Sharepoint Lists from a Sharepoint Site but just not this one List
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
Luke Teo (admin)
6
Reputation points
Hi there, I've followed the instructions (https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory) and managed to get Azure Data Factory (ADF) to ingest various Sharepoint lists from various Sharepoint sites.
However, there is just this ONE list within this one Sharepoint Site that I just couldn't ingest/access (I could ingest other lists from the same site) and following screenshot is the error from ADF. I've got my Sharepoint admin to validate that Information Relation Management (IRM) isn't applied to this list and site and we're pretty sure we got the list name correct too (validated by my Sharepoint admin via PowerShell)
Therefore, does anyone know what I'm missing or have experienced such similar issue before?
Azure Data Factory
Microsoft 365 and Office | SharePoint | Development
3,724 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2022-06-23T19:01:05.773+00:00 Hello @Luke Teo (admin) ,
Thanks for the question and using MS Q&A platform.
From the error message my understanding is that the error is thrown from SharePoint side. I would recommend trying to test from Postman to access that list which is not working with ADF and see if the issue is specific to ADF. Else that confirms that there is something needs to be fixed from Sharepoint side. If you are able to connect from Postman and the issue is only with ADF then we need a deeper investigation to better understand the root cause and would recommend filing a support ticket.
Please let us know your observations.
Thank you
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-06-28T20:28:22.98+00:00 Hello @Luke Teo (admin) ,
We still have not heard back from you. Just wanted to check if you have got a chance to try testing using Postman? And, if you have any further query do let us know.
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-07-01T21:26:55.987+00:00 Hello @Luke Teo (admin) ,
Just checking in to check if you are able to perform a test using POSTMAN. If so, could you please share your observations. And if you have further questions related to ADF SP Online connector please let us know.
Thanks
Sign in to comment
Sign in to answer