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

Hello,

 

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 :

let
Source = Web.Contents("https://rally1.rallydev.com/slm/webservice/v2.0/milestone?{...},[ApiKeyName="Mykey"])
in
Source

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,

 

Greg

Outcomes