Execute a SuiteQL query against NetSuite

SuiteQL query results

POST /v1/tenants/{tenant_id}/netsuite/suiteql

cURL

curl --request POST \
  --url 'https://api.sync.stateset.com/v1/tenants/{tenant_id}/netsuite/suiteql' \
  --header "x-stateset-api-key: $STATESET_SYNC_API_KEY" \
  --header 'Content-Type: application/json' \
  --data '{
  "query": "string"
}'

200

{
  "items": [
    {}
  ],
  "raw": {}
}

Path parameters

tenant_id · string · required

Tenant identifier

Request body

object

query · string · required

SuiteQL query string (read-only SELECT)

Response

object

items · object[] · required

Query result rows

raw · object · required

Raw API response

Status codes

Code	Meaning
200	SuiteQL query results
401	Unauthorized
422	Invalid SuiteQL query
424	NetSuite integration not configured
502	NetSuite API error

cURL

curl --request POST \
  --url 'https://api.sync.stateset.com/v1/tenants/{tenant_id}/netsuite/suiteql' \
  --header "x-stateset-api-key: $STATESET_SYNC_API_KEY" \
  --header 'Content-Type: application/json' \
  --data '{
  "query": "string"
}'

200

{
  "items": [
    {}
  ],
  "raw": {}
}