NetSuite

Query records and run SuiteQL queries via the NetSuite REST API.

Environment Variables

• NETSUITE_ACCOUNT_ID - Account ID (e.g. 1234567)
• NETSUITE_TOKEN_ID - Token-based auth token ID
• NETSUITE_TOKEN_SECRET - Token-based auth token secret

SuiteQL query

curl -s -X POST \
  "https://$NETSUITE_ACCOUNT_ID.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $NETSUITE_TOKEN_SECRET" \
  -H "prefer: transient" \
  -d '{"q":"SELECT id, companyname, email FROM customer WHERE rownum <= 10"}' | jq '.items[]'

List invoices

curl -s -X POST \
  "https://$NETSUITE_ACCOUNT_ID.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $NETSUITE_TOKEN_SECRET" \
  -H "prefer: transient" \
  -d '{"q":"SELECT id, tranid, entity, total, status FROM transaction WHERE type = '\''CustInvc'\'' AND rownum <= 10"}' | jq '.items[]'

Get record

curl -s \
  "https://$NETSUITE_ACCOUNT_ID.suitetalk.api.netsuite.com/services/rest/record/v1/customer/CUSTOMER_ID" \
  -H "Authorization: Bearer $NETSUITE_TOKEN_SECRET" | jq '{id, companyName, email, phone}'

Notes

• Token-based authentication used. OAuth 1.0 may be required for some setups.
• Always confirm before creating or modifying records.