Loading
Salesforce Document Generation
JSON Output for Multilevel Hierarchy Transformation

You are here:

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

JSON Output for Multilevel Hierarchy Transformation

This sample JSON output represents multilevel hierarchical quote and bundle data structured for document generation.

Required Editions

Available in: Lightning Experience
Available in: Professional, Enterprise, Unlimited, and Developer Editions 
{
  "QuoteId": "0Q0SG000001KUJ70AO",
  "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO",
  "relatedRecords": [
    {
      "ParentReference": "0Q0SG000001KUJ70AO",
      "UnitPrice": 699.99,
      "QuotelineItemId": "0QLSG0000039GBx4AM",
      "children": [
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 89.99,
          "QuotelineItemId": "0QLSG0000039GBv4AM",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBv4AM",
          "Quantity": 2.56,
          "Product": "EasyDye",
          "ParentQuoteLineItem": "0QLSG0000039GBx4AM"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 299.99,
          "QuotelineItemId": "0QLSG0000039GBu4AM",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBu4AM",
          "Quantity": 8.25,
          "Product": "Propylene Glycol",
          "ParentQuoteLineItem": "0QLSG0000039GBx4AM"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 299.99,
          "QuotelineItemId": "0QLSG0000039GBt4AM",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBt4AM",
          "Quantity": 3.78,
          "Product": "Fluid Film Corrosion Inhibitor",
          "ParentQuoteLineItem": "0QLSG0000039GBx4AM"
        }
      ],
      "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBx4AM",
      "Quantity": 1,
      "Product": "Data Center Bundle"
    },
    {
      "ParentReference": "0Q0SG000001KUJ70AO",
      "UnitPrice": 1499.99,
      "QuotelineItemId": "0QLSG0000039GAN4A2",
      "children": [
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 14.99,
          "QuotelineItemId": "0QLSG0000039GAM4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAM4A2",
          "Quantity": 1,
          "Product": "Keyboard",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 33.99,
          "QuotelineItemId": "0QLSG0000039GAL4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAL4A2",
          "Quantity": 1,
          "Product": "USB C multiport adapter hub with 4K HDMI",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 179.99,
          "QuotelineItemId": "0QLSG0000039GAH4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAH4A2",
          "Quantity": 1,
          "Product": "External Hard Drive",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 7.99,
          "QuotelineItemId": "0QLSG0000039GAJ4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAJ4A2",
          "Quantity": 1,
          "Product": "Mouse",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 199,
          "QuotelineItemId": "0QLSG0000039GAI4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAI4A2",
          "Quantity": 1,
          "Product": "Printer",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 9.99,
          "QuotelineItemId": "0QLSG0000039GAK4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAK4A2",
          "Quantity": 1,
          "Product": "Office 365",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 89.99,
          "QuotelineItemId": "0QLSG0000039GAR4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAR4A2",
          "Quantity": 1,
          "Product": "Noise-Canceling Headphones",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 15.26,
          "QuotelineItemId": "0QLSG0000039GAO4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAO4A2",
          "Quantity": 1,
          "Product": "Laptop Bag",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 79.99,
          "QuotelineItemId": "0QLSG0000039GAQ4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAQ4A2",
          "Quantity": 1,
          "Product": "Laptop Stand",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        },
        {
          "ParentReference": "0Q0SG000001KUJ70AO",
          "UnitPrice": 1049,
          "QuotelineItemId": "0QLSG0000039GAP4A2",
          "children": [],
          "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAP4A2",
          "Quantity": 1,
          "Product": "Laptop",
          "ParentQuoteLineItem": "0QLSG0000039GAN4A2"
        }
      ],
      "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GAN4A2",
      "Quantity": 1,
      "Product": "Laptop Productivity Bundle"
    },
    {
      "ParentReference": "0Q0SG000001KUJ70AO",
      "UnitPrice": 299.99,
      "QuotelineItemId": "0QLSG0000039GBw4AM",
      "children": [],
      "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBw4AM",
      "Quantity": 1,
      "Product": "Fluid Film Corrosion Inhibitor"
    },
    {
      "ParentReference": "0Q0SG000001KUJ70AO",
      "UnitPrice": 89.99,
      "QuotelineItemId": "0QLSG0000039GBy4AM",
      "children": [],
      "IdPath": "/0000000f21yf15g00251776309742657f187dfdcda58448c856e36bb5ceff8f1/0Q0SG000001KUJ70AO/0QLSG0000039GBy4AM",
      "Quantity": 1,
      "Product": "EasyDye"
    }
  ],
  "AccountName": "Sales Rep Luke Account",
  "Name": "DocumentationHierarchyQuote"
}
 
Cargando
Salesforce Help | Article