Downloading file from Sharepoint throws error

[oystein.stray]

Hi,

We are using Graph API to download an Excel file from Sharepoint. To do this, we are using the newest version of this object from DX.

In the last few weeks, download will fail after a few downloads on the same resource. There are no data item outputs because the object terminates and thus does not output the exact error as a data item. First, the only error we got was "object reference not set to a instance of an object". So we modified the object to catch the error and rethrow it. The error we then managed to extract was "The underlying connection was closed: An unexpected error occurred while sending.".

Anyone have any experience with this error using the Graph API object?

Regards,

Øystein

[piyushkumar07]

Hi Stray, looks like your connection with Graph API for sharepoint is getting disconnected. One token is valid for some limited times only so try to call the authentication before downloading any new files and validate it will help/resolve the issue.

[plnarayana777]

Hi

Check with the security team on firewall to the SharePoint from the machine.

for simple approach try opening the same site through browser in same machine where you are try the graphAPI

Encountered same error for one of the SharePoint site later resolved allowing the site in firewall.

Thanks