Published on May 28, 2020.

Here's a follow-up to this post. It's a native NetSuite version of the PHP-based SuiteQL Query Tool mentioned in this post.

In a blog post last week, I wrote about how I've been using NetSuite's SuiteTalk REST Web Services, and its support for executing SuiteQL queries in particular. This has quickly become my preferred technique for integration projects that involve retrieving data from NetSuite, especially when the data needs to be retrieved as quickly as possible, or when the integration involves retrieving data from multiple related tables.

To make developing SuiteQL queries a little easier, I've created a browser-based tool. It's a PHP-based application that I've been referring to as the "SuiteQL Query Tool." A few screenshots of the application are included below.

To use the tool, you enter a SuiteSQL query and click the submit button. The app sends the query to the SuiteTalk REST API, and displays the JSON-encoded result. The elapsed time between the API call being made and the response being received is also displayed.

When entering a query, you can use whatever formatting that you prefer - with tabs, returns, and so on. The app removes any whitespace from the query before sending it to the SuiteTalk REST API.

The tool also supports specifying a limit and an offset for the query, so the developer can paginate the results as they refine the query. Clicking the "gear" icon in the top right corner of query textarea reveals the limit and offset settings, as shown here.

I developed the app using RapidWeaver, along with the Foundry theme and its stacks. The resulting UI is Bootstrap-based.

Admittedly, this is a very simple application. However, I'm finding it to be quite helpful - especially when I'm working on some of the more complex SuiteQL queries that my integration projects require.

If there's enough interest in the app, then I might make it available as a free download. So if you're interested, please drop me a line.