I have the following data input and
[[
{
"LineNum": 1,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {
"value": "501",
"name": "Cloud GPU Compute (H100) Hours"
},
"Qty": 40,
"UnitPrice": 18.75,
"ServiceDate": "01-15-2026"
},
"Amount": 750.0,
"Description": "SKU:[GPU-H100-40H:01-15-2026]",
"QuickBooksData": {
"Id": "901",
"Name": "Cloud GPU Compute Package",
"FullyQualifiedName": "Services:Cloud:GPU Compute",
"Type": "Service",
"Active": true,
"Taxable": false,
"UnitPrice": 18.75,
"PurchaseCost": 0,
"IncomeAccountRef": {
"value": "610",
"name": "Cloud Services"
},
"TrackQtyOnHand": false,
"SyncToken": "1",
"MetaData": {
"CreateTime": "2023-06-12T09:10:00-07:00",
"LastUpdatedTime": "2026-01-10T08:00:00-08:00"
}
},
"enriched": true
},
{
"LineNum": 2,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {
"value": "742",
"name": "3D Printer Resin - 1L Bottles"
},
"Qty": 6,
"UnitPrice": 64.99,
"ServiceDate": "02-19-2026"
},
"Amount": 389.94,
"Description": "SKU:[RESIN-1L-6PK:02-19-2026]",
"QuickBooksData": {
"Id": "1174",
"Name": "3D Printing Supplies",
"FullyQualifiedName": "Retail:3D Printing:Resin",
"Type": "NonInventory",
"Active": true,
"Taxable": false,
"UnitPrice": 64.99,
"PurchaseCost": 0,
"IncomeAccountRef": {
"value": "485",
"name": "3D Supplies"
},
"TrackQtyOnHand": false,
"SyncToken": "2",
"MetaData": {
"CreateTime": "2024-02-03T11:22:15-07:00",
"LastUpdatedTime": "2026-01-18T10:05:30-08:00"
}
},
"enriched": true
},
{
"LineNum": 3,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {
"value": "888",
"name": "Cold Brew Coffee Keg Rental"
},
"Qty": 2,
"UnitPrice": 325.0,
"ServiceDate": "04-14-2026"
},
"Amount": 650.0,
"Description": "SKU:[CB-KEG-RENTAL-2:04-14-2026]",
"QuickBooksData": {
"Id": "2088",
"Name": "Event Beverage Equipment Rental",
"FullyQualifiedName": "Rentals:Events:Beverage Equipment",
"Type": "Service",
"Active": true,
"Taxable": false,
"UnitPrice": 325.0,
"PurchaseCost": 0,
"IncomeAccountRef": {
"value": "720",
"name": "Equipment Rentals"
},
"TrackQtyOnHand": false,
"SyncToken": "3",
"MetaData": {
"CreateTime": "2025-05-20T14:40:00-07:00",
"LastUpdatedTime": "2026-01-25T16:12:00-08:00"
}
},
"enriched": true
}
]]
and want to create an estimate with all line items in the same estiamte in quickbooks, by setting service date, description, product name, amount etc.
how can I do that?
seems Create Estiamte node doesn’t let to use arrays in property fileds and i can’t figure out how to do it.
any help would be appreciated?
thanks