How to call webservice with body parameters in power bi?

[Anonymous]

Hi All,

we are trying to consume a webservice in power bi i.e using web content() .

This is the lm language script that we have got on search.

Web.Contents("http://some.url", [Headers=[ #"Content-Type"="application/json"]])​

OUR json consist of following input parameters to be passed in body

input:

{

          "projectCode":"xyz",

         "index":0,

         "searchString":"",

          "filterColumn":"",

          "filterType":"" }

we dont know how to pass these parameters while consuming  this web service URL .

Please suggest.

[Anonymous]

I am able to hit the webservice url

but getting invalid parameters with zero results.

here is the m script that i have used.

let
    
    url = "https://url",
    body = "{
	""query"":[
{
	""EMP_ID"": ""if"",
	""userName"":""name"",
	""lastAccessedDateTime"":""2016-10-18T07:10:40.000Z"",
        ""deviceId"":""id"",
   	""appKey"":""key"",
	""tokenid"":""kkshdsfif"",
        ""appType"":""web""
}
]
}",
    Source = Json.Document(Web.Contents(url,[
             Headers = [#"ContentType"="application/json"]
         Content = Text.ToBinary(body) 
             ]   
        ))
in
    Source

Here is the output 

Can anybody please suggest me.

Mohan.V