> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# 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`](#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 ...) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>