Connect to API with many fileds

Question

Hello, in my newer job I faced with this API to connect: [please, I need a help]&nbsp;-------------------------------------------------------------------- Part of JSON -----------------------------},{&nbsp; &nbsp; "name": "BI PV CC",&nbsp; &nbsp; "request": {&nbsp; &nbsp; &nbsp; &nbsp; "auth": {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "basic",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "basic": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "key": "password",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "password2022#",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "string"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "key": "username",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "Example_user",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "string"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; "method": "GET",&nbsp; &nbsp; &nbsp; &nbsp; "header": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "key": "software-key",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "12345678-225f-4bcd-8850-123456789",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "text"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; "url": {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "raw": "http://software.clinetcompany.com.br/apiclient/bi/salesOrders?dataEmissaoInicio=2022-11-25&amp;dataEmissaoFim=2022-11-28",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "protocol": "http",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "host": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "software",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "clientcompany",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "com",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "br"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "path": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "apiclient",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "bi",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "salesOrders"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "query": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "key": "dataEmissaoInicio",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "2022-11-25"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "key": "dataEmissaoFim",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "2022-11-28"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; },&nbsp; &nbsp; "response": []},&nbsp;------------------------ END ------------------The other part sent me that json with all those fields, that I simply dont know how get the responde (it´s also a json) on the power query. Can anyone give-me a light please?&nbsp;I´m very thakful for your help&nbsp;

andreganzarolli · Accepted Answer

I already know how to do, and I´m posting the answer here down below.

Its just to find three parameters:

1 - The API URL

2 - the name of key wich have the secret

3 - the secret key itself

In my case, the URL is there " http://software.clinetcompany.com.br/apiclient/bi/salesOrders?dataEmissaoInicio=2022-11-25&dataEmissaoFim=2022-11-28"

The name of My Secret Key is: "software-key"

and the Key Itsef, right below the "software-key"

So, its just place in power BI -> Get Data -> WEB

On the web get data option, select advanced, and place as the picture says:

And voilà!

Forum Discussion

Connect to API with many fileds

1 Reply

Related content

Unable to detect locally created files from Sharepoint Files Connection

Connection failed using a Folder connection in a pipeline

Error connection to Excel file on OneDrive

increase file size

connection to dataflows