Microsoft Graph API

[AlexGavri]

Hello all,

I have a Microsoft Graph API Connection that I'm using to get a .xlsx file from SharePoint.

I have established a connection but I'm having problems finding documentation on how to actually extract the content of the file.

As you can see in the flow below, I've done a Post request to get the token, then used that to establish a connection to the file that I want to extract the content from but it extracted only the details about the file ( had to blur for confidential reasons).

Does anyone know how to get the content, please?

Thank you

 

[apathetichell]

In the examples shared here - https://learn.microsoft.com/en-us/graph/api/driveitem-get?view=graph-rest-1.0&tabs=http you'd look for weburl in the odata content. Can you post your odata return after cleaning it for identifiable information? - you should have another field you would isolate and then follow.

[AlexGavri]

 

[apathetichell]

what happens you send webUrl to the next download tool  as the url and download to blob?

[AlexGavri]

Hi @apathetichell,

First of all thank you for your help!

Tried to do another download with the web URL as URL but didn't get the right response back.

Also tried to do a dynamic input using the web URL but for some reason it seems that its adding a link to my local desktop (C:\User\user_id\Descktop) before. An idea how to remove that?

Thank you again for your help and involvement.

Highly appreciated

 

 

[apathetichell]

You are asking two different questions here:

1) how to download the file

2) how to open/process the file.

First work on 1) - you need to use the webUrl endpoint. try it in postman - add content-types until it works. go through the documentation.

2) - once the file is downloaded as a blob to a location - you should use a batch macro to load it. Is it an excel file - is the sheet name dynamic? if so you must use an outer/inner system to load in the sheet.

There are lots of resources on this forum on how to use a batch macro to load in a dynamic file - but you need to first make sure you are actually downloading the file correctly. You need to get your download tools set up correctly - and can check that that works by opening the file outside of Alteryx.