Forum

How to download XML...
 
Notifications
Clear all

How to download XML data using Power Query to Connect to an API

2 Posts
2 Users
0 Reactions
141 Views
(@faizaziz)
Posts: 1
New Member
Topic starter
 

Hi just trying to download order data through order API.

For your reference- Fruugo Order Api

 
Posted : 09/09/2020 10:06 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Faiz,

Fruugo uses Basic Authentication (not OAuth).  Their documentation states https://fruugo.atlassian.net/wiki/spaces/RR/pages/66158675/Requests+Calls

Authentication is handled with HTTP Basic - method. The credentials used are those which are set-up for the account to access the Fruugo Retailer Portal.

So when you are prompted in Power Query to supply credentials, you choose Basic and then enter the username and password you set up to access the Fruugo retailer portal.

An example of setting up Basic Auth can be found here, check the section on the Stripe API:

Getting Started With API's in Power Query

In the attached workbook I've started a query to get order data but until you enter your Basic Auth credentials it will not work.

If you are having trouble getting this to work, but you have the username/password to access the API, you can start a Helpdesk ticket and confidentially send me your username/password and I'll see what I can do to get it working.

Regards

Phil

 
Posted : 09/09/2020 9:54 pm
Share: