Forum Discussion

mkjit256's avatar
mkjit256
Icon for Helper IV rankHelper IV
3 years ago

pulling Sharepoint List Notes property details

Hello

When connecting to a sharepoint list, some columns that are pulled contains URL text. One of the columns showing URL's is the Notes column. The URL has the general pattern of:


<a href="https://CompanyName.sharepoint.com/sites/Site_Name/_layouts/15/listform.aspx?ListId=%7B41638G4A%2E4743%2Q42HD%2DGB80%2DOC65EAF78293%7D&PageType=4&ID=3">View Entries</a> 

 

How is it possible to retrieve the content from that URL?
Trying the Wweb.Contents Connector is giving me a 404 error, and trying to copy paste the URL to my browser is redirecting me to:

https://CompanyName.sharepoint.com/sites/Site_Name/Lists/List_Name/DispForm.aspx?ID=3
which will display all the properties(Attributes) of the sharepoint List.

  

Need Help

2 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    mkjit256 
    Can you try using the URL as 

    Source = SharePoint.Tables("https://companya.sharepoint.com/sites/sitename/", [ApiVersion = 15])

     Please let me know if this didn't work.

    • mkjit256's avatar
      mkjit256
      Icon for Helper IV rankHelper IV
      3 years ago

      Hello, Thanks for your reply, but maybe i have mis explained the problem. 

      I am using 

       

      = SharePoint.Tables("https://company.sharepoint.com/sites/site_name", [Implementation="2.0", ViewMode="All"])

       

       and i have no problem with this step. 
      The problem that i am having is that the Notes column, in the sharepoint table, itself contain URLs and i would like to retrieve these information: 

      any suggestions?