Hello Poweruser Community,
I am using Azure Data Explorer within flow, however am receiving a 400 bad request when connecting to Azure Data Explorer. For reference, I have used Run Query and List Results(preview) step within the Send email on a recurring basis if Azure Kusto query returns results template.
I have verified connection and that query returns results from: https://dataexplorer.azure.com/
in order to narrow down the issue to the connector.
Below is the telemetry associated with the bad request:
Headers
Body
Hi @cclaiborne,
I just verified that this post is a duplicate from: https://powerusers.microsoft.com/t5/Connecting-To-Data/400-bad-request-when-using-Azure-Data-Explorer/td-p/497901
With this said, apart from the suggestion that was presented in the previous post, I would also check on the query that you are using if there are no errors inserted.
The error message that you are getting with the 400 bad request is the following:
"ErrorMessage": "Ensure that expression: deploymentPayload.[\"DeploymentRequestAction\"] is indeed a simple name",
As such, I would start by verifying the query that you are using and see what is being included in this deployentPayload. If you are using this as a custom property or custom measurement in an aggregation function, you should cast them to their exact type.
Also verify if there might be any typos in writing this expression, which could also be causing this issue.
Hope this helps!
Regards,
Ricardo