Write Json Response to DB
Hi Guys ,
I have incoming message as json
{
"request_id": "5",
"business_unit": "AMTEST",
"load_date": "2026-01-13",
"data": [
{
"invoice_id": "297",
"invoice_number": "95123747",
"invoice_date": "2023-11-30",
"invoice_received_date": "2025-10-29",
"invoice_currency": "EUR",
"supplier_name": "FACILICOM SOLUTIONS BV",
"source": "ARROW",
"invoice_lines": [
{
"line_number": "1",
"line_description": "Management - LINE 6",
"quantity": "1",
"unit_price": "-9376.34",
"line_amount": "-9376.34"
},
{
"line_number": "2",
"line_description": "Management - LINE 6",
"quantity": "2",
"unit_price": "-12088.31",
"line_amount": "-12088.31"
}
]
}
]
}
i am trying to write to Database from OIC it is plain one to one mapping (Name :SampleTB)
when i see the records get inserted as LineNumber filed in same row