I need to use prompt engineering to extract the line item table from my invoice. How to I write my output JSON so that the output rows are mapped to Line Item table fields of Vantage. Fields are getting extracted but not getting binded with LintItem table. I have tried using multiple LLM models but mainly am using gtp-5.4-mini. However this my prompt is failing for all types of models. Can you tell me how to bind line item fields with output JSON?
Extract Line Item table using Prompt Extraction and bind with table fields
この記事は役に立ちましたか？
0人中0人がこの記事が役に立ったと言っています
コメント
1件のコメント
Hi Srivastava,
For Vantage line item/table binding, the JSON output needs to match the table structure exactly. The line items should be returned as an array of objects, where each object represents one row, and the object keys should match the LineItem table field names in Vantage.
For example:
```json
{
"LineItems": [
{
"Description": "Item 1",
"Quantity": "2",
"UnitPrice": "10.00",
"Amount": "20.00"
},
{
"Description": "Item 2",
"Quantity": "1",
"UnitPrice": "15.00",
"Amount": "15.00"
}
]
}
```
The important part is that `LineItems` should match the Vantage table/repeating group name, and each field inside the row should match the exact child field names configured under that table.
If the values are extracting but not binding, it usually means the JSON structure or field names do not match the Vantage schema. I would recommend checking the exact table name and child field names in Vantage, then updating the prompt to return only that structure with no extra text.
サインインしてコメントを残してください。