Microsoft Dynamics 365 | Integration, Dataverse...

Microsoft flow - bad request. error in query

(0) Share

Report

Posted on by meenoo

7,316

Hi, I am new to using flow and trying to just create a simple flow. Nothing complex.

I am getting this very generic error:

{"error":{"code":"0x0","message":"Bad Request - Error in query syntax.","innererror":{"message":"Bad Request - Error in query }

Not sure how to debug and what to troubleshoot for looking at this error. Can someone please guide me through this? Thanks for any help.

All I am doing is copying data from excel online and trying to import it into Dynamics 365 entity(Incident).

I have taken the import template from Dynamics 365 exported from advanced find and stored it in OneDrive.

My flow is picking up the file, getting the rows but won't update them in Dynamics(throws above error).

What am I doing wrong? For the sake of testing I am only trying to update one field along with mandatory fields like Customer ID, Owner ID.. etc. Please help.

All responses (4)

Answers (0)

meenoo 7,316 on at

Like (0)

Report

RE: Microsoft flow - bad request. error in query

hmm..

I looked into the article and followed it but still getting the same error when it comes to update record action.

It just simply says 'Bad Request - Error in query syntax.'

I wish it errors out with some more information about which field fails, why it fails etc.

This is not helping me and I can't figure out what is failing and why is it failing!! How else do I troubleshoot? Somebody please help!

Thanks.
Suggested answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Microsoft flow - bad request. error in query

Maybe something is wrong with the record identifier.

Please refer to this blog: www.c-sharpcorner.com/.../
meenoo 7,316 on at

Like (0)

Report

RE: Microsoft flow - bad request. error in query

Here.. is this what you mean?
meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Microsoft flow - bad request. error in query

Hello partner,

Can you Please share more screenshots ? I want to see the last step in more details.