Forum Discussion

PowerUser123's avatar
PowerUser123
Helper II
4 years ago

API Connection - Undefined Varaible: Json

I have the following query that generates a token to be used for an API call, but I'm getting an error message stating: Undefined Variable: json

 

I'm not sure if I'm missing anything or doing anything wrong?

let
    
    api_url = "https://someapi.com/api/",
    token_path = "getAccessToken", 
    Token_Response  = Json.Document(Web.Contents(api_url,
    [ 
      RelativePath = token_path,
      Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
      Content=Text.ToBinary("username=clientid&password=password111")
    ]
    )
    ),
   
    token = Token_Response[token],

    path = "getList",  
    endDate = "2022-04-25 00:00:00",
    startDate= "2022-04-26 00:00:00",

    data1= Json.Document(Web.Contents(api_url,
   [ 
     Headers = [#"Accept"="application/json"],
     RelativePath = path,
     Query = [end_date=endDate, start_date=startDate, api_token=token]
     
   ]
   )
   )
in
     data1

2 Replies