When I add a new step for SQL insert row and try to connect it to the table I need, I get this error:
The dynamic operation request to API 'sql' operation 'GetTable_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The key didn't match any rows in the table. inner exception: The key didn't match any rows in the table. clientRequestId: 5b5d7e7a-e605-488d-8f33-06c1b2973dda", "error": { "message": "The key didn't match any rows in the table. inner exception: The key didn't match any rows in the table." }, "source": "sql-ase.azconn-ase.p.azurewebsites.net" }
I have confirmed that the account used for data access has access to the on-prem SQL table so not sure what I'm missing.
