I understand that there's no way to have anonymous access to SharePoint Online lists like you can with SharePoint 2013, but is there a way to pull the data from the list somehow where I can store in an array for displaying on another website(an internal wallboard)?

I've tried with RSS but again there's no anonymous access!

  • 1
    You can generate an anonymous link for a file in a document library. You can try exporting that data to excel file and store in a library. – Venkat Konjeti Jun 6 '17 at 16:13
  • Hi @Defias Bandit, welcome to SharePoint StackExchange :) , Could you please take a quick tour at sharepoint.stackexchange.com/tour to get informed badge! Thank you for your contribution :) – Mohamed El-Qassas MVP Jun 6 '17 at 16:24
  • You could leverage the CSOM to replicate this data locally, or perform an authenticated request to refresh Export to Excel data. – Taylor Jun 6 '17 at 17:23
  • @VenkatKonjeti unfortunately it won't let me "Get a link" for some reason. – Defias Bandit Jun 6 '17 at 21:58
  • Can you refer this article for steps. support.office.com/en-us/article/… – Venkat Konjeti Jun 6 '17 at 22:07

One possibility could be since you are on the SharePoint online is to, automatically get data from the list to CSV file through MS Flow. Here are the steps:

  1. Schedule a task (for example every day or week)
  2. Get all the items from the list
  3. Generate a CSV file
  4. Save the file to OneDrive or FTP location

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.