AnsweredAssumed Answered

SSO authentication, API Key and Excel Power Query

Question asked by GregZveg on Aug 22, 2017
Latest reply on Feb 4, 2018 by karimm



I am a user with SSO authentification.

I tried to access Milestones with the CA Excel addin, but I discovered this is not yet implemented.


I then tried to build my own queries with the WS, and it seems to work.

I implemented a API KEY in the CA Agile Central App management.

I have now a functionning query and a API KEY.


I tried to have it automated with Excel Power Query, but it keep failing in authenticating.

My query is :

Source = Web.Contents("{...},[ApiKeyName="Mykey"])

It tells me I have to enter authentication information, I enter the API Key, and it fails... same question again...


Would you have an idea please ?


My best regards,