Hi Everyone,
I'm trying to open the workbook which is stored in the SharePoint using Advanced Excel WorkbookOpen action by passing the fileURL/path, but it is throwing 401 Unauthorized error.
Regards,
Sudharshan
Hi @Sudharshan T
It is most probably your OutSystems server that doesn't have access to the Sharepoint you are pointing to.
What is your setup? Is it OutSystem cloud or on-premise?
Hanno
Hi @Hanno
I'm using Microsoft Graph API token based authentication which allowed me to access the sharepoint file but when i pass it to Workbook_Open it throwed me access denied error.
Hi Sudharshan T,
Can you try to remove NullBinary() from the input parameter to see if it works?
Still the same error @Beatriz Sabino
In your screen shot it is trying to access a file : c:\windows\system32\inetsrv\Test.xlsm. btw What is the output of. SP_GetFileDetails.OutFile.Name ? Is it Test.xlsm ?
@Siya SP_GetFileDetails.OutFile.Name is "Test.xlsm" which is just name of the file
I guess file would be stored at server side and it is trying to access the file from server path c:\windows\system32\inetsrv\Test.xlsm
Thanks for the clarification. SP_GetFileDetails.OutFile.Name is returning "Test.xlsm", but the Advanced Excel component is attempting to read the file from the OutSystems Platform Server, where it doesn't exist.
Please check if you can either:
Retrieve the file’s binary content directly from the SharePoint component, or
Get the file’s SharePoint URL, download it to the server, and then pass it to the Excel component.