Import data from POST method URL

[SunilGurram]

Hi,

Can someone help me ti import the data from web API URL in POST method. API data is in JSON format.

[
{
"Case Code": "123",
"Fund": "ABC",
"Organization": "Life Support for Civilian War Victims",
"Project": "AFG-",
"Project Status": "Project Closed"
}
]

I am trying as follows.

let
url = "http://xxx.xxx.com:8080/vo2/odata/CaseData/BlockedProjectConservativeMeasure",
body = "{""parameter as poolfundcodes"":""123""
}",

Source = Json.Document(Web.Contents(url,[
Headers =[#"Content-Type"="application/json", #"Authorization" = "basic "],
Content = Text.ToBinary(body) , Timeout=#duration(0,2,0,0)
]
))

in
#"Source"

Getting an error

DataSource.Error: Web.Contents failed to get contents

from URL: ....... (500): Internal Server Error.

[SunilGurram]

Thanks. I am able to import the data now.

[Hariharan_R]

Hi 

Refer Chris Webb post - https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/

He explained that how to call POST request.

Thanks

Hari

[Hariharan_R · Accepted solution]

Hi 

Refer Chris Webb post - https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/

He explained that how to call POST request.

Thanks

Hari