Forum Discussion

saikishore's avatar
saikishore
New Member
8 years ago
Solved

Passing Variables in API Post Request JSON Body

I'm using the google business API to get the driving directions insights (auth as text, locid as text) => let AuthKey = "Bearer "& auth, url = "https://mybusiness.googleapis.com/v3/accounts/...
  • ImkeF's avatar
    ImkeF
    8 years ago

    Hi saikishore,

    you don't use the parameter "locid" as text in your function at all. If your expression in step "body" is supposed to do this: It will not work. If locid is a single text string, you have to concatenate it like so:

     

    "{""locationNames"":"& locid &",#(lf)""drivingDirectionsRequest"": {""numDays"":""NINETY"",},}"
akashgera's avatar
akashgera
Icon for Helper I rankHelper I
5 years ago

Hi @ImkeF, @v-yuta-msft


I am using REST API to fetch the data from 3rd party using POST method, I have used the same parameters in Header, Body in postman, and it is giving me the data in JSON format, but when I am using the same thing in power query, it is giving me an error: Response Msg: Invalid APi credentials

Response code:11

response : NULL
Please have a look in my power query below and help me what is wrong in this :-

let
ApiOwner= "XXXXXXXX",
ApiKey="XXXXXXXXXXXXXXXXXXXXXXXXX",
url = "https://dentalkart.vineretail.com/RestWS/api/eretail/v3/sku/inventoryStatus",
header= [#"Authorization" = ApiKey & ApiOwner,
#"Content-Type" = "application/x-www-form-urlencoded"],

RequestBody=
"{
""skuCodes"":""[]"",
""fromDate"":""18/06/2021 15:40:30"",
""toDate"":""23/06/2021 15:40:30"",
""pageNumber"":""1"",
""dropShipFlag"":""no"",
""locCode"":""
}",

webdata = Web.Contents(url, [Content = Text.ToBinary(RequestBody), Headers=header]),
response = Json.Document(webdata)

in
response

 

 

 


Any kind of help would really be appreciated !