I am currently working on an automation that involves sharepoint. Some of the steps I have to do are:
Go to the “Logs” folder and read the “Log.xlsx” document (this is to log the results of the automation)
Go to “Recent Forms” folder, read each form to make sure certain fields are filled out, then record whether or not the correct fields are filled in the Log document
Logic-wise, I understand what I have to do, however my biggest issue is reading the data on sharepoint. I have tried to use the SharePoint Custom Activities Package (Sharepoint custom activities link), however this does not work properly for me and it also does not do what I am looking for. I am also unable to map the sharepoint folder to my local machine, as I do not have permission to do so.
Is there another way I can read and write files from sharepoint?