I am creating and testing a new Integrator to post rows from a spreadsheet to a custom table. I am testing by entering 3 rows of data. All rows are passing the interface rules in terms of what is required and what values are entered.
When I Upload (all rows), I am getting the following error -- always on the final row in the spreadsheet, 'Cannot execute SQL statement'. Further investigations shows ' A low level API failed'.
If I enter 5 rows, the error always shows on the 5th row. I remove the 5th row and the error will show on the 4th row. If I remove the bottom 4 rows and keep row 1, the integrator will upload line 1 successfully.
I can then go back and enter any of the other 4 rows --- one row at a time, and they will accept.
The data being entered is good. Something in my integrator set up is not allowing multiple entries in my spreadsheet.
Does anyone have any thoughts on what could be the cause of this issue?
Much appreciated.
Eileen