Forum Discussion

felixpau's avatar
felixpau
New Member
8 years ago

Celoxis integration

Was wondering if anyone has tried integrating celoxis with powerbi. I tried entering the api call string http://yourservername:portnumber/psa/api.do?function=login&username=username&password=password...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

felixpau,

What format of the URL do you enter in Power BI Desktop? After you get the token of your api, do you enter URLs like below in web connector of Power BI Desktop?

http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_project&status_id=1&data-format=json&token=xxxxx&data-format=xml


http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_task&id=100&token=xxxxxxxxxx&data-format=json


Reference:
https://celoxis.atlassian.net/wiki/spaces/DOC10/pages/73925306/Examples+of+XML+JSON+API

Regards,
Lydia

felixpau's avatar
felixpau
New Member
8 years ago

I tried entering this (with the server information and permanent token)

 

http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_project&status_id=1&data-format=json&token=xxxxx&data-format=xml

 

returns a Server Error – Signature Missing from encrypted data