You are here:
JSON Output for Hierarchy Transformation in Document Generation
This sample JSON output represents 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"
}
Did this article solve your issue?
Let us know so we can improve!
