Tag: suiteQL

How to use the suiteql to fetch the data from NetSuite records using postman

The following curl can be used for fetching the data from NetSuite records using Suiteql. curl –location ‘https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=1000&offset=0’ –header ‘Content-Type: application/json’ –header ‘Accept: application/json’ –header ‘prefer: transient’ –header ‘Authorization: OAuth realm=”[AccountID]”,oauth_consumer_key=”[CONSUMER_KEY]”,oauth_token=”[ACCESS_TOKEN]”,oauth_signature_method=”HMAC-SHA256″,oauth_timestamp=”1711082395″,oauth_nonce=”lE426dBrpwV”,oauth_version=”1.0″,oauth_signature=”[OAUTH_SIGNATURE]”‘ –data ‘{       “q”: “SELECT transaction.id AS upstreamId, customer.companyName, customer.entitytitle, customer.entityid, transaction.number, ”’D/M/YYYY”’ AS dateFormat, transaction.tranDate AS invoiceDate, transaction.dueDate AS paymentDueDate, transaction.total AS invoiceValue, transaction.total… Continue reading How to use the suiteql to fetch the data from NetSuite records using postman

What exactly does the customScriptId option do on query.runSuiteQL?

Introduction: SuiteQL, NetSuite’s SQL-based query language, provides a powerful tool for retrieving data. One lesser-known but useful feature is the customScriptId option available in the query.runSuiteQL method. This unique identifier proves valuable in identifying and resolving potential performance issues with queries. Using customScriptId: To leverage the customScriptId option, include a unique string value in the… Continue reading What exactly does the customScriptId option do on query.runSuiteQL?

SuiteQL is the Future

Demo: Running SuiteQL Query Tool for Getting Unit of Measure Check out Tim Dietrich’s SuiteQL Query Tool (free). Download the zip file and extract it. Create a suitelet record in the NetSuite account and run it. Run the Query “SELECT uom.unitname, uom.conversionrate FROM unitsType INNER JOIN unitsTypeUom as uom ON (unitsType.id = uom.unitstype)”

Suite talk Rest API setup

Importing the Postman Collection To import the Postman collection: Download the REST web services Postman collection of sample requests from the SuiteTalk tools download page at https://<accountID>.app.netsuite.com/app/external/integration/integrationDownloadPage.nl. To access this page, you must substitute your account ID, and the REST web services permission must be assigned to your role. Unzip the archive. Click Import in… Continue reading Suite talk Rest API setup

Record catalog for suiteQL reference. Act like NetSuite Database record browser.

The Records Catalog in NetSuite is a valuable reference tool that provides comprehensive information about the NetSuite model structure and behavior. This tool serves as a guide for developers, administrators, and system users to better understand the available record types and fields within the NetSuite platform. The main functionalities and features of the Records Catalog… Continue reading Record catalog for suiteQL reference. Act like NetSuite Database record browser.

N/query module overview.

Understanding N/query module NetSuite, a leading cloud-based ERP platform, offers a robust set of tools and modules to help businesses streamline their operations. The N/query module is especially important for querying and manipulating data within NetSuite. In this article, we will look at the N/query module, and its key features, and provide a live example… Continue reading N/query module overview.

SuiteQL to generate a Customer saved search in Power BI via ODBC connector

The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a Customer saved search in Power BI via ODBC connector

SuiteQL to generate a saved search in Power BI via ODBC connector

The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a saved search in Power BI via ODBC connector