Forum Discussion
Anonymous
3 years agoNot applicable
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.Docum...
Anonymous
3 years agoNot applicable
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.