Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connect to restful api data source multiple times

Hi,   I am a complete Newbie with regards to Resftul services etc, I am trying to connect to a Second Street Api using the below.   It seems you need to use a Post first to get an access toke, ho...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    FYI we got it connecting using

     

    let
     apiUrl = "https://api.secondstreetapp.com/sessions",
     data ="{'sessions':[{'username':'**', 'password': '**'}]}",
     options = [
     Headers =[#"Content-Type"="application/json", #"X-Api-Key"="*****"],
     Content = Text.ToBinary(data)
     ],
     Value = Web.Contents(apiUrl,options),

in
     Value

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Lydia,

 

Thanks for getting back to me, the thing is though in order to get the token you have to first POST to the api. 

 

Its like a two step authentication.  How would this translate?

 

let
     apiUrl = "https://api.secondstreetapp.com/sessions",
     options = [Headers =[#"username"="***"],[#"password"="****"]],
     result = Web.Contents(apiUrl , options)
in
     result

 

When I put in the above I get Access to the resource is forbidden and then taken to a login screen, what I am needing it to return is...

 

{
 "sessions": [
   {
     "access_token": "a1b2c3d4",
     "id": 22318,
     "organization_id": 397282,
     "organization_user_guid": "123456a7-ab12-1a23-1ab2-123a45bc6789",
     "organizations_count": 2,
     "username": "[email protected]"
   }
 ]
}

 

Thanks

 

Chris

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

What do you mean by "two step authentication"? If you refer to 2 factor authentication, as far as I know, Power BI doesn't support this auth method.

Thanks,
Lydia Zhang