Hi just trying to download order data through order API.
For your reference- Fruugo Order Api
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