Azure Logic App - BadRequest. Http request failed: the content was not a valid JSON

Question

I have created a Logic APP in Azure which was working fine till now. I am getting "BadRequest. Http request failed: the content was not a valid JSON" error from today. Please note that no changes made to the SP. Below is detailed process

1. Created SP in DB to generate the reports
2. Created Logic APP in Azure
3. Set the occurrence to run every week Monday at 1 AM

enter image description here

When i reran the report, facing the same issue again. Then i connected to DB and manually ran the SP. Then in Azure if i ran the report then it was success. Really not sure how to fix this issue.

question from:https://stackoverflow.com/questions/65883794/azure-logic-app-badrequest-http-request-failed-the-content-was-not-a-valid-j

Answer 1

Your problem may be caused by the returned result of the stored procedure not json, or by some known issues or limitations. You can refer to the following official document:

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations