Forum Discussion
Connect to Bamboo's REST API- Error"Web API key can only be specified when API key name is provided"
Hello, I have the same problem and I don't seem to be able to get around it.
Has anyone an idea how to connect to bambooHR's API?
I can do it via browser and with a python script just using my API key using the following format (in this case a report):
but I don't seem to be able to replicate the same approach from powerbi.
Has anyone any suggestion?
THank you!
Managing to connect through web browser is great news.
If "https://[my API key ]:[email protected]/api/gateway.php/{my organisation subdomain}/v1/reports/{report ID}?format=JSON&fd=no" works, it means that [my API key] is your username and x is your password. Try doing it in basic authentication.
If you want to use it in Power Query, follow my tutorial here. You can look up Authentication string in your web browser. It will be something like Authentiaction = "Basic <some long string here>".
Let me know, if you have any questions.
I had the similar issue, tried put the {API Key} in User Name and {x} in password still got "We Couldn't authenticate with the credentials provided."
I had the similar issue, tried put the {API Key} in User Name and {x} in password still got "We Couldn't authenticate with the credentials provided."
