How does one go about resolving this? The dynamic operation request to API 'sql' operation 'GetPassThroughNativeQueryMetadata_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native Sql) is currently not supported using an on-prem gateway connection
I can connect to SQL using Desktop flow, it works fine without any issues. I have set up a gateway and can connect to SQL server using the cloud flow, however the only action that works is “GET ROWS”
@@TbvngM There are bigger limitations in executing SQL queries using cloud flows, so if I was you I would build the flow in Desktop application and then use the Cloud to trigger the flow when/if necessary. The Desktop flow should be able to contain everything needed like SELECT, WHERE, FROM, JOIN etc etc
@@TbvngM you're welcome. It's funny why they don't support the same, but what do I know, there is probably a reason. Let me know if you have other issues :)
How does one go about resolving this?
The dynamic operation request to API 'sql' operation 'GetPassThroughNativeQueryMetadata_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native Sql) is currently not supported using an on-prem gateway connection
Hey when are you getting this error? Can you connect to SQL without running a query, or are you getting this error when you are executing a query?
I can connect to SQL using Desktop flow, it works fine without any issues.
I have set up a gateway and can connect to SQL server using the cloud flow, however the only action that works is “GET ROWS”
@@TbvngM There are bigger limitations in executing SQL queries using cloud flows, so if I was you I would build the flow in Desktop application and then use the Cloud to trigger the flow when/if necessary. The Desktop flow should be able to contain everything needed like SELECT, WHERE, FROM, JOIN etc etc
@@MatKjeldseni was trying to avoid this lol.
Thank you sooo much for your response and assistance
@@TbvngM you're welcome. It's funny why they don't support the same, but what do I know, there is probably a reason. Let me know if you have other issues :)