How to fix 400 error in logic app with form recognizer data to database

Question

I'm trying to process blob invoices through a form recognizer and straight into a table in my database but get a 400 error stating, "A value must be provided for item".

I mapped the data correctly and it goes to the appropriate rows when i look at the log, but still get this error. I dont know where this issue could come from, any help is appreciated.

Below is a screenshot of my logic app im working in along with the For Each detail. I can provide more info if need be.

Answer 1

Hi Adrian Barrera,
I would like to know whether the Primary Key which is InvoiceID is auto generated like using Identity Column, if it is using identity column it may not need mapping in the Logic App. However, if Primary Key column requires input from the Logic App, ensure a valid unique value is provided, or adjust the SQL table’s settings to auto-generate it if possible.