Solved: POST Request Error

Anonymous · ‎03-04-2021

Hi,

I'm really struggling to find what is wrong with my M code to make a POST request. Although I know you would need to know the API to know exactly what is wrong but I just want to check that there is nothing wrong with the way I am making the request? As I am getting a 400. Bad Request error.

For info the API I'm using is Clockify.

I have connected to the API fine for GET requests but can't figure out what I'm doing wrong. And I just want to rule out that I am doing something wrong with the Request rather than misunderstanding the API.

Thanks for any help at all

ImkeF · ‎03-07-2021

Hi @Anonymous ,
I cannot spot anything obvious.
But you can reduce the risk of typing errors if you use the Json.FromValue function to define the body of your request: Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎03-07-2021

Hi @Anonymous ,
I cannot spot anything obvious.
But you can reduce the risk of typing errors if you use the Json.FromValue function to define the body of your request: Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries