In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Microsoft Graph API

AlexGavri
7 - Meteor

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

2024-09-02_12h02_58.png

 

5 REPLIES 5
apathetichell
19 - Altair

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
7 - Meteor

2024-09-02_17h08_59.png

 

apathetichell
19 - Altair

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

AlexGavri
7 - Meteor

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

2024-09-03_12h17_28.png

 

2024-09-03_13h06_17.png

 

apathetichell
19 - Altair

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.

Labels
Top Solution Authors