Send post request to Algorithmia API

[webportal]

Hello,

I'm trying to get data from an Algorithmia API into Power BI Desktop.

Basically, trying to convert this:

curl -X POST -d '"Test"' -H 'Content-Type: application/json' -H 'Authorization: Simple simAOH0ixjNUwV/qBMh1BW1fbKH1' https://api.algorithmia.com/v1/algo/tone/DemoAlgo/0.1.0?timeout=300

Into Power Query M:

let
url= "https://api.algorithmia.com/v1/algo/tone/DemoAlgo/0.1.0",
auth_key = "'Simple simAOH0ixjNUwV/qBMh1BW1fbKH1'",
header = [#"Authorization" = auth_key, #"Content-Type" = "application/json"],
query = "'Test'",
webdata = Web.Contents(url, [Headers=header, Query = query]),
response = Json.Document(webdata)
in
response

This is returning NOT found error: 404.

Can anyone help?

Thanks in advance!

[webportal · Accepted solution]

I got it with:

let 
    url= "https://api.algorithmia.com/v1/algo/tone/DemoAlgo/0.1.0?timeout=300",
    auth_key = "simAOH0ixjNUwV/qBMh1BW1fbKH1",
    header = [#"Authorization" = auth_key, #"Content-Type" = "application/json"],
    post_contents = """Teste""",
    
    webdata = Web.Contents(url, [Content=Text.ToBinary(post_contents), Headers=header]),
    response = Json.Document(webdata)
in
    response

Should anyone have the same issue.

[webportal]

Also tried with:

let 
    url= "https://api.algorithmia.com/v1/algo/tone/DemoAlgo/0.1.0?timeout=300",
    auth_key = "simAOH0ixjNUwV/qBMh1BW1fbKH1",
    header = [#"Authorization" = auth_key, #"Content-Type" = "application/json"],
    post_contents = "Teste",
    webdata = Web.Contents(url, [Content=Text.ToBinary(post_contents), Headers=header]),
    response = Json.Document(webdata)
in 
    response

This returns:

(400): Bad Request