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