Skip to content
Back to blog

Export CPQ data and inspect JSON as a table

CPQ DevKit™ for Salesforce includes a couple of “quality of life” tools that are great for investigations and reviews: exporting data to files and viewing JSON in a table UI.

Export Products (Product2) to a file

Run:

  • CPQ DevKit™ for Salesforce: Export Products from Salesforce into a File

You’ll be prompted for:

  1. Output folder
  2. Output file name

Control the output format and fields

In VS Code settings, you can configure:

  • sfdcQcp.export.products.outputFormat (csv or json)
  • sfdcQcp.export.products.fields (the fields used in the SOQL SELECT)

Tip: keep the field list small at first—Product2 exports can get large quickly.

View JSON as a table

When you’re looking at:

  • QuoteModel JSON (downloaded into data/)
  • Export JSON files
  • Any other JSON you want to explore

…run:

  • View JSON as Table

This opens a webview-based table viewer that makes it easier to scan arrays, sort, and understand large datasets compared to scrolling raw JSON.