Hi,
I have an Excel Spreadsheet which is on SharePoint Online which I would like to read the contents of using FME Desktop.
I am already able to use the Microsoft Sharepoint List Reader for reading in the metadata for the particular excel spreadsheet. To do this I created a WebConnection by creating a new connection using the "Microsoft Sharepoint Online (Template) ' and changing the eTENANT] parameter in the 'URL' under the 'Authorization Parameters' settings.
I saw that recently Safe released the SharePointOnlineConnector transformer and it sounds like it is just what I need to be able to read the actual contents of the Excel File.
However, when I went to look for the site which contains the Excel Spreadsheet, it wasn't in the list of 'Sites' under 'Download Options' in the SharePointOnlineConnector. A lot of other sites from my company were listed so the connection seems to be ok. I am assuming it must be some sort of permissions thing. But since I was able to access the metadata for the Excel File using the Sharepoint List Reader, I would have thought I would already have the permissions.
Do I need to ask the site owner to give me different permissions before I can access the site via the SharePointOnlineConnector? If so, what permissions exactly do I need to ask for? Or is there another issue with my methodology?
Kind regards,