SOLVED

azure synapse pipeline - copy data from sharepointlist with spaces in Listname

Copper Contributor

HI!

 

Is there a way to connect to a sharepointlist with spaces in the sharepointlistname?

 

RHBLIKSEMS_0-1676456496763.png

 

5 Replies

@RHBLIKSEMS Try using a List value of KP%20List. See if that helps.

best response confirmed by RHBLIKSEMS (Copper Contributor)
Solution
Solved it. I thought that I needed to add the Listname from the URL, but actual the Listname works also (which does not contain spaces)
Hello, could you please provide me with the documentation that you used to copy the sharepoint list, did you use a http linked service and a web activity? I followed this link but did not work https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-fact...

@Ritta1450 

I found the solution. 

lets say the list name is "Test List" or "Test - List"

just use the name "TestList" and it will work in Synapse Analytics or Data Factory. 

 

I wonder why they haven't mentioned it in some document. 

1 best response

Accepted Solutions
best response confirmed by RHBLIKSEMS (Copper Contributor)
Solution
Solved it. I thought that I needed to add the Listname from the URL, but actual the Listname works also (which does not contain spaces)

View solution in original post