oracle-suiteql

Oracle NetSuite SuiteQL - execute SuiteQL queries via REST (query NetSuite records with SQL-like syntax, paging with limit/offset)

Server path: /oracle-suiteql | Type: Application | PCID required: Yes

Tools

Tool	Description
oracle_suiteql_run_suite_ql	Execute a SuiteQL query

---

oracle_suiteql_run_suite_ql

Execute a SuiteQL query

Parameters:

Parameter	Type	Required	Default	Description
limit	integer	No	—	Number of results to return in a single page
offset	integer	No	—	Page offset for paging through results
q	string	Yes	—	The SuiteQL query (e.g. SELECT id, email FROM customer WHERE …)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "limit": {
      "type": "integer",
      "description": "Number of results to return in a single page"
    },
    "offset": {
      "type": "integer",
      "description": "Page offset for paging through results"
    },
    "q": {
      "type": "string",
      "description": "The SuiteQL query (e.g. SELECT id, email FROM customer WHERE ...)"
    }
  },
  "required": [
    "PCID",
    "q"
  ]
}