Forum Discussion

RHBLIKSEMS's avatar
RHBLIKSEMS
Copper Contributor
Feb 15, 2023
Solved

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

HI!   Is there a way to connect to a sharepointlist with spaces in the sharepointlistname?    
  • RHBLIKSEMS's avatar
    RHBLIKSEMS
    Feb 27, 2023
    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)
Darrin Bishop's avatar
Darrin Bishop
Copper Contributor
Feb 18, 2023

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

RHBLIKSEMS's avatar
RHBLIKSEMS
Copper Contributor
Feb 20, 2023

Darrin Bishopunfortunatly not, already tried that..

  • RHBLIKSEMS's avatar
    RHBLIKSEMS
    Copper Contributor
    Feb 27, 2023
    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)
    • Ritta1450's avatar
      Ritta1450
      Copper Contributor
      Mar 15, 2023
      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-factory
      • i-s-maan's avatar
        i-s-maan
        Copper Contributor
        Oct 06, 2023

        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. 

Resources