Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

POST query with authorization token

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.

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous - 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Anonymous @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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks Anonymous - I think you need to change this step:

       data = Text.FromBinary( Json.FromValue( [fieldName="someData"] ) )
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

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