POST query with authorization token

[ojosdegatonegro]

Hi, I'm trying to post info into a DB using an endpoint, but It's not working, this is the query:

let
        data = Json.FromValue([ fieldName="someData"]),
        Source = Json.Document(Web.Contents("https://url", [Headers=[Authorization="authorization token", #"Content-Type"="application/json"], Content=data]))
in
    Source

If I remove the Content from the source, I'm able to get the whole record from the table, but as soon I add the content It show this error:

DataSource.Error: Web.Contents failed to get contents from 'https://myURL' (404): Not Found
Details:
    DataSourceKind=Web
    DataSourcePath=https://myURL
    Url=https://myURL

Thanks in advanced.

[ojosdegatonegro]

Thanks @Daryl-Lynch-Bzy @but that is pretty much what we need to do: writing to a database.

I watch this video and that's what I'm trying to do. I have tried with a free API and works fine.

https://youtu.be/4dJ2vobI-G8

[Daryl-Lynch-Bzy]

Thanks @ojosdegatonegro - I think you need to change this step:

 data = Text.FromBinary( Json.FromValue( [fieldName="someData"] ) )

[ojosdegatonegro]

I tried without Text.FromBinary, just Json.FromValue and the error remains

[Daryl-Lynch-Bzy]

Sorry - I sure how to help.  Can you double check that Json is properly formatted by using VS Code or Postman.  Obtain the Json from the Text.FromBinary step and past it into another tool to see if the error is occurring.

[ojosdegatonegro]

This is the code using JsonPlaceHolder API:

let
    data = Json.FromValue([title = "ID_WERTPAPIER", body = "851399", userId = "US" ]),
    outputdata = Text.FromBinary(data),
    Source = Json.Document(Web.Contents("https://jsonplaceholder.typicode.com/posts", [Headers=[#"Content-Type"="application/json"], Content=data]))
in
    Source

And it works!!! But if I use my own API, adding authorization to the header, something goes wrong, now the error message is this:

Expression.Error: We cannot convert a value of type Binary to type Text.
Details:
Value=[Binary]
Type=[Type]

I know that my endpoint is working cause it works in postman.

[Daryl-Lynch-Bzy]

Hi @ojosdegatonegro - what you mean by "post info into a DB"?  You should not use Power Query to write data into a database.  It is not recommended because Power Query could send the transactions multiple times to the database.

You also mention that API works without the Content.  This suggests that the API call is GET type.  It is not sual for url string to work as GET call and POST call - it is normally one or the other.  Can you provide more details on the API.