Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connect to a Web Service sending parameters

Hi Community   I am trying to access a wb API. I am connecting using web connector. I need data based upon some query valuess. I am able to access the website for the basic table, but not sure how...
Need Help
navneet0512's avatar
navneet0512
Icon for Helper III rankHelper III
4 years ago

let

Content = "{
  "methodType": "details",
  "pageNum": "0",
  "pageSize": "3",
  "searchParameter": [
    {
      "key": "order_number",
      "value": "469584336"
    },
    {
      "key": "global_bu_id",
      "value": "11"
    }
  ],
  "sourceApplication": "MORC"
}",

 


Source = Json.Document(Web.Contents("https://goss-csvc-prod.us.mac.com/gossv3/purchase/search/",[Content=Text.ToBinary(content)]))
in
Source

 

Getting error "Token comma expected"

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hello navneet0512 ,
    you must escape the quotes and also regard that M is case sensitive. So the correct code would look like so:

    let

Content = "{
  ""methodType"": ""details"",
  ""pageNum"": ""0"",
  ""pageSize"": ""3"",
  ""searchParameter"": [
    {
      ""key"": ""order_number"",
      ""value"": ""469584336""
    },
    {
      ""key"": ""global_bu_id"",
      ""value"": ""11""
    }
  ],
  ""sourceApplication"": ""MORC""
}",

 


Source = Json.Document(Web.Contents("https://goss-csvc-prod.us.mac.com/gossv3/purchase/search/",[Content=Text.ToBinary(Content)]))
in
Source