Uploading file to Sharepoint Folder

[john.hammond]

Good Morning all,

I'm looking to upload/copy/save an Excel file to a specific Sharepoint Folder. Firstly, my apologies in advance - I am by no means an expert in working with SharePoint. I'm aware that there is the Graph API for interacting with SharePoint, but I have absolutely no idea how that works in practice (is there an idiots guide somewhere as to how this integrates with Blue Prism?). I'd like to think that there was a simpler solution to this particular issue anyway - denoting a save path on SharePoint for the document from with the 'Save Workbook As' object within the Excel VBO - but I cannot seem to get this to work. 

So actually, I guess there are two questions that I currently have:
* Is there a simple way to save an Excel file to a specific folder on SharePoint? If so, how?
* How does Graph API work for someone who's not overtly familiar with SharePoint and indeed API's in general? The documentation is fine but could benefit from some example structures within Blue Prism.

Not sure if it over-complicates things, but the file(s) I'll be looking to upload will just under 6mb - from what I understand, there may be a 4mb limit on the Graph API Upload File action?

I should add: one thing I've seen mentioned is about uploading to OneDrive and then syncing to SharePoint, however unfortunately, my organisation has blocked this.

------------------------------
John Hammond
------------------------------

[EasyBluePrism]

@ewilson @Neel1 

Here you have two screenshots: 

 

 

 

[naveed_raza]

you can easily upload file using Graph API, here is the details, you have to get the access token 

Endpoint URL: https://{{graphAPIDomain}}/sites/{{SharePointSiteID}}/drive/root:/{{RelativeFilePath}}:/content

relativeFilePath: Graph API Test/Test/ShareList read Data vba.xlsb

sourceFilePath: your saved full file path