Forum Discussion

Bsim89's avatar
Bsim89
Frequent Visitor
8 years ago

Odata Feed with Archer App

Hello experts,   I have a problem when I try to connect to an API that points to an Archer application. I access the application on the web without any problem. Is there anyone who has ever tried...
Need Help
luismorais_'s avatar
luismorais_
Frequent Visitor
5 years ago

Hi Bsim89 !

 

I'm also using the content api to connect to a Archer Feed.

There's a few takeways and configurations that may bring different results from our application intead of yours, but the steps that worked for me were:

  1. Connect trough a OData Feed Connection
  2. Use a Basic authentication method
  3. In the username you should use literally "session-id", nothing else
  4. The password is the Session Token generated by the Archer application. Here I also suggest that you create a specific user to powerbi and configure to return a fixed Session Token, otherwise I'll have to generate another one every time.

Here are two links that may help you

https://community.rsa.com/yfcdo34327/attachments/yfcdo34327/archer-blog/2966/1/Report%20Like%20a%20Boss,%20for%20your%20Boss,%20Using%20the%20Content%20API%20and%20BI%20Tools.pdf

 

https://community.rsa.com/t5/archer-discussions/how-do-you-create-an-archer-api-session-token-using-a-python/td-p/468966

 

Hope it helps.