Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm relatively new to PowerBI, and am trying to connect to Bamboo's Open API (REST API).
My workflow is going through PowerBI's "New Source" --> "web" --> in "basic" I enter Bamboo's API URL (https://api.bamboohr.com/api/gateway.php/{company subdomain name}/)
Then at the Authentication window, I select Web API and input the API key I generated in Bamboo. Then I get an error "a web API key can only be specified when a web API key name is provided"
I've read around, and have seen that the api key name is required in Web.Content. But where / how do i enter this and what is the "api keyname"? Under "New Source" --> "web" --> there is an "advanced" option that has HTTP Request headers, but none of them are "web.content" or API keyname.
Any help or nudge in the right direction would be awesome.
Thanks,
-Mike
Hey,
Thanks for the quick response.
When I try this, and choose Anonymous credentials, I get the following error:
DataSource.Error: Web.Contents failed to get contents from 'https://api.bamboohr.com/api/gateway.php/COMPANYID/' (404): Not found
Details:
DataSourceKind=Web
DataSourcePath=https://api.bamboohr.com/api/gateway.php/COMPANYID
Url=https://api.bamboohr.com/api/gateway.php/COMPANYID/
All I have in the query line is:
= Json.Document(Web.Contents("https://api.bamboohr.com/api/gateway.php/COMPANYID/", [Headers=[Authorization="APIKEY"]]))
thanks
-Mike
Hey,
the query lin should look like this:
let Source= Json.Document(Web.Contents("https://YourURI" & "Contact/" , [Headers=[Authorization="" & Token &""]])), objects = Source[objects] in objects
But you have to investigate where the bamboo API wants the Credentials or Token.
Error 404 says that the url you are using is not found on the server.
Maybe try a Client like Postman to be sure everythings is working.
Greetings,
Wolf
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |