Forum Discussion
API connection with Holded ERP
Thank you very much Artemus.
I tried it but there is something more to do. I did:
- Blank query
- Erase let / in schema
- paste directly
Web.Contents("https://api.holded.com/api/invoicing/v1/contacts", [Headers=[Accept="application/json"], ApiKeyName="Key"])- Replace "key" with my key "exxxxxxxx..."
- Power BI send a message to "edit credentials"
- I put my API key at "API Web"
- Power BI show a message asking that it couldn't authenticate the credentials.
I don't know what I did wrong.
Maybe It is related with: (https://developers.holded.com/reference/api-key)
- All API requests must be made over HTTPS and Content-type as application/json.
- Include your Api Key in the Header key : . I also tested:
* 1:
= Web.Contents("https://api.holded.com/api/invoicing/v1/contacts", [Headers=[Accept="application/json"],
ApiKeyName="key: exxxxxxxxxxxx"])
* 2:
= Web.Contents("https://api.holded.com/api/invoicing/v1/contacts", [Headers=[Accept="application/json"],
ApiKeyName="key:exxxxxxxxxxxx"])
- artemus3 years agoMicrosoft Employee
You do not replace "key". "key" refers to the name of the password field in the header.