SQL Insert Row Error

(0) Share

Report

Posted on by randomsky

103

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.

All responses (1)

Answers (1)

Verified answer

tracytran 144 on at

Like (0)

Report

Re: SQL Insert Row Error

@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