You’re offline. This is a read only version of the page.
110
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.
@randomsky I ran into this problem many times. The important thing is you should get the correct name of table.It is case sensitive and you should declare schema clearly. For example: dbo.SQL_table_name
Share
Report
All responses (
Answers (
