NetSuite SuiteQL REST API Hack
Use Postman Visualize to convert SuiteQL JSON results to an HTML table
So, you use NetSuite and Postman to explore your ERP data. Using NetSuite SuiteQL and Postman it’s a walk in the park. You even got used to reading the “Pretty” JSON response in the console.
But something is missing.
You would prefer to look at the data in a tabular fashion. Maybe copy/paste the data into excel for further manipulation. Maybe take a quick snapshot of the data and share it.
Enter Postman Visualize.
Applying a simple template in Postman, you can present your data in beautiful tables.
You can copy/pasted this data and the HTML file is stored in your temporary directory (on windows C:\Users\User Name\AppData\Local\Temp).
So, how to make this happen?
In Postman, in your SuiteQL request:
- Setup a template (A) in the Tests.
- You can use the sample template available below.
- Execute your request.
- Switch to the Visualize (B) result.
Please contact us with questions and we will be happy to assist you.
NetSuite is complicated – We make it simple
Leverage our knowledge base and decades of experience to maximize NetSuite’s functionality for your business. We know what NetSuite does well and what it doesn’t. Schedule your 1-hour optimization call with our expert NetSuite team today, our gift to you.