How to create estimate with multiple line items?

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

Hi @seojournal

Try aggregate all line items into a single item and send them as one Line[] array using the node’s raw JSON body, instead of trying to map each line into individual fields.

1 Like

Use Sheets With aggregate in one line that would help you create the estimate, let me know if you can share your use case for more tailored help.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.