SuiteQL

   



Run SQL queries against NetSuite using SuiteQL through SuiteTalk Rest Webservices.

This class extends netsuite-rest

Installation

npm i suiteql

Quick Start

const suiteql = require('suiteql');
let suiteQL = new suiteql({
consumer_key: process.env.consumer_key,
consumer_secret_key: process.env.consumer_secret_key,
token: process.env.token,
token_secret: process.env.token_secret,
realm: process.env.realm,
base_url: process.env.base_url
});

query

query(string, limit = 1000, offset = 0)

- string - Select query to run

- limit - Limit number of rows, max is 1000

- offset - Rows to start from


This method returns with the promise support, response will be in JSON format

$3

let transactions = await suiteQL.query("select id from transaction", 10, 0);

queryAll (Stream)

When working on large number of rows, stream is handy

queryAll(string, limit = 1000)

- string - Select query to run

- limit - Limit number of rows, max is 1000

$3

let items = [];
let st = suiteQL.queryAll(
select
tranid, id from transaction
where
rownum <= 30
);

st.on("data", (data) => {
items.push(data);
});

st.on("end", () => {
console.log("stream ended")
});