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

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
8 years ago

how did you set your credentials? as anonymous?
I have a similar API but it seems it is not accepting my username and password parameters.

When I use anonymous, I get error. When I use basic auth (with pop up box), I get error from web.content only possible when anonymous...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    We ended up going down the PHP route