Hi Johnny. I think you may not have any great options for calling the SuiteQL API via REST with our snaps in the short term with the current limitations of our REST OAuth1 account type. I have learned that this account type was designed around a particular way of using OAuth1 for a particular SAS but it’s clearly not going to work with NetSuite.
Until we address this (which is not on our roadmap currently as far as I know), your other options involve our NetSuite snap pack:
Write a NetSuite RESTlet that does what you need. That’s a script that you write and install in your NetSuite account. You would then use our new NetSuite Call RESTlet snap to call it from a pipeline, and it executes on the NetSuite server. The script can access a variety of NetSuite server-side APIs to access your data. Our snap handles the complexity of NetSuite’s OAuth1 authentication. This is a new snap that will be included in our May release, but is also available now as a patch for our Feb release. We have two customers using it.
See if our other NetSuite snaps might do what you need. They use NetSuite’s SOAP-based SuiteTalk API. Many of our customers have found these sufficient for their needs.
We are planning on eventually providing more direct support in our NetSuite snap pack for NetSuite’s newer REST-based APIs (apart from RESTlets). These APIs are new in the past year, I believe.
Hope that helps.