Showing results for 
Search instead for 
Did you mean: 
New Member

Error Code: 400, The Response is not in JSON format

I have a workflow that takes in a new (.xlsx) that we manually upload to the server everyday that then updates an existing sharepoint list of items. Recently there has been a failure every other day that I cannot find a reason as to why it fails. This fail happens when trying to update an item that already exists in a list.



"code": 400,

"source": "",

"clientRequestId": "xxx-xxx-xxx-xxx-xxx",

"message": "The response is not in a JSON format.",

"innerError":"The server encountered an error processing the request. See server logs for more details"


The way I've been able to resolve this is by resetting the values in both [When a file is created or modified(properties only)] and [Get tables] actions. 


How can I go about running the flow without having a failure every other day?


Hello, @kwaxe!


Could you post a picture of your flow (right where the error pops up)?


Thanks in advance,


New Member

Hey @rrovira , I have posted the images below, I am not sure which specific parts of the flow you need to see, I will mention there is some sensitive data so I cannot show the entire flow with the variables without blocking sensitive data. Let me know if there are any specific parts you need to see and I will post it.






Not applicable

Will you be helping with this issue?  

Helpful resources

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,243)