Open link in a new tab

Content

Expand project menu

can't connect using Power Query

Hello experts, I try to link my Excel-based time-tracking to OpenProject. I want to be able to select a task within Excel. Should be no Problem with Power Query.

I get asked for my Web-API key (German Excel, but labels should be obvious) and all I do is paste my generated API-Token there:

Format is "opapi-e1b..." 

After that, I get prompted for a level on which the settings shall be appied:

But it does not succeed, the authentication could not be done with these credentials.


This shouldn't be too perform, so I've made a mistake but I don't see it. Can you please give my any advice?

Kind regards

Chris