Loading
Salesforce Document Generation
JSON Output for Group and Bundle Hierarchy Transformation

You are here:

  1. Salesforce Help
  2. Docs
  3. Salesforce Document Generation

JSON Output for Group and Bundle Hierarchy Transformation

This sample JSON output represents hierarchical quote data with groups, bundles, and products structured for document generation.

Required Editions

Available in: Lightning Experience
Available in: Professional, Enterprise, Unlimited, and Developer Editions 
{
  "QuoteId": "0Q0SG000001BvX30AK",
  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK",
  "relatedRecords": [
    {
      "ParentReference": "0Q0SG000001BvX30AK",
      "children": [
        {
          "ParentReference": "0Q0SG000001BvX30AK",
          "children": [],
          "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ",
          "ParentQuoteLineGroupId": "1C9SG0000006m1x0AA",
          "relatedRecords": [
            {
              "UnitPrice": 1150,
              "ParentReference": "1C9SG0000006m5B0AQ",
              "QuotelineItemId": "0QLSG000002RejR4AS",
              "children": [
                {
                  "UnitPrice": 7.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejS4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejS4AS",
                  "Product": "Mouse",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejR4AS"
                },
                {
                  "UnitPrice": 1049,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejT4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejT4AS",
                  "Product": "Laptop",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejR4AS"
                }
              ],
              "Amount": 1150,
              "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejR4AS",
              "Product": "Laptop Pro Bundle",
              "Quantity": 1
            },
            {
              "UnitPrice": 1499.99,
              "ParentReference": "1C9SG0000006m5B0AQ",
              "QuotelineItemId": "0QLSG000002RejQ4AS",
              "children": [
                {
                  "UnitPrice": 33.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002Reja4AC",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002Reja4AC",
                  "Product": "USB C multiport adapter hub with 4K HDMI",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 14.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejY4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejY4AS",
                  "Product": "Keyboard",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 7.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejN4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejN4AS",
                  "Product": "Mouse",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "StartDate": "3/24/26 12:00 AM",
                  "UnitPrice": 9.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejO4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejO4AS",
                  "Product": "Office 365",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 15.26,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejP4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejP4AS",
                  "Product": "Laptop Bag",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 89.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejV4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejV4AS",
                  "Product": "Noise-Canceling Headphones",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 79.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejU4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejU4AS",
                  "Product": "Laptop Stand",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 179.99,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejZ4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejZ4AS",
                  "Product": "External Hard Drive",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 199,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejW4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejW4AS",
                  "Product": "Printer",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                },
                {
                  "UnitPrice": 1049,
                  "ParentReference": "1C9SG0000006m5B0AQ",
                  "QuotelineItemId": "0QLSG000002RejX4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejX4AS",
                  "Product": "Laptop",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002RejQ4AS"
                }
              ],
              "Amount": 1499.99,
              "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m5B0AQ/0QLSG000002RejQ4AS",
              "Product": "Laptop Productivity Bundle",
              "Quantity": 1
            }
          ],
          "QuoteLineGroupId": "1C9SG0000006m5B0AQ",
          "Name": "ChildGroupOne"
        }
      ],
      "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m1x0AA",
      "relatedRecords": [],
      "QuoteLineGroupId": "1C9SG0000006m1x0AA",
      "Name": "ParentGroupOne"
    },
    {
      "ParentReference": "0Q0SG000001BvX30AK",
      "children": [
        {
          "ParentReference": "0Q0SG000001BvX30AK",
          "children": [],
          "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006npF0AQ",
          "ParentQuoteLineGroupId": "1C9SG0000006m3Z0AQ",
          "relatedRecords": [
            {
              "StartDate": "3/25/26 12:00 AM",
              "UnitPrice": 89.99,
              "ParentReference": "1C9SG0000006npF0AQ",
              "QuotelineItemId": "0QLSG000002T4ez4AC",
              "children": [],
              "Amount": 89.99,
              "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006npF0AQ/0QLSG000002T4ez4AC",
              "Product": "Figma Subscription",
              "Quantity": 1
            },
            {
              "UnitPrice": 1100,
              "ParentReference": "1C9SG0000006npF0AQ",
              "QuotelineItemId": "0QLSG000002T4dP4AS",
              "children": [
                {
                  "UnitPrice": 1049,
                  "ParentReference": "1C9SG0000006npF0AQ",
                  "QuotelineItemId": "0QLSG000002T4dN4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006npF0AQ/0QLSG000002T4dN4AS",
                  "Product": "Laptop",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002T4dP4AS"
                },
                {
                  "StartDate": "3/25/26 12:00 AM",
                  "UnitPrice": 99.99,
                  "ParentReference": "1C9SG0000006npF0AQ",
                  "QuotelineItemId": "0QLSG000002T4dO4AS",
                  "children": [],
                  "Amount": 0,
                  "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006npF0AQ/0QLSG000002T4dO4AS",
                  "Product": "Antivirus",
                  "Quantity": 1,
                  "ParentQuoteLineItem": "0QLSG000002T4dP4AS"
                }
              ],
              "Amount": 1100,
              "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006npF0AQ/0QLSG000002T4dP4AS",
              "Product": "Laptop Basic Bundle",
              "Quantity": 1
            }
          ],
          "QuoteLineGroupId": "1C9SG0000006npF0AQ",
          "Name": "ChildGroupTwo"
        }
      ],
      "IdPath": "/0000000f26yf24g00251776315784384d9ac4717e5fc413ca81ac373e712190d/0Q0SG000001BvX30AK/1C9SG0000006m3Z0AQ",
      "relatedRecords": [],
      "QuoteLineGroupId": "1C9SG0000006m3Z0AQ",
      "Name": "ParentGroupTwo"
    }
  ],
  "AccountName": "Sales Rep Luke Account",
  "Name": "HierarchyOfHierarchyQuote"
}
 
Ladataan
Salesforce Help | Article