# Collection commands: export, query

URL: /code/cli/collection/verbs · Id: `page:code/cli/collection/verbs`

> The Collection Verbs export, query as CLI commands, with inputs, result, refusals and an example.

Reference for [Collection](/business/nouns/collection), one group of [Collection commands](/code/cli/collection).

### Collection.export
Export writes a Collection’s records to a file or the Startup’s warehouse, once or on a schedule. [Verb page](/business/nouns/collection/export?interface=cli).

```text
npx startup-builder do Collection.export --json '<input>' [--try | --send | --do]
```

Emits [`Collection.exported`](/business/events/Collection.exported).

**Inputs**

| Input | Type | Required | Description |
| --- | --- | --- | --- |
| `collection` | [Collection](/business/nouns/collection) | Yes | The Collection to export. |
| `to` | `string` | Yes | A file format, or the warehouse Integration that receives it. |
| `cadence` | `string` | No | How often it repeats; omitted, it runs once. |

**Returns**

| Output | Type | Required | Description |
| --- | --- | --- | --- |
| `file` | [File](/business/nouns/file) | No | The exported File, for a one-time export. |
| `collection` | [Collection](/business/nouns/collection) | Yes | The Collection exported. |

**Refuses when**

| Check | Error | Fix | Then call |
| --- | --- | --- | --- |
| The key is valid, but its scopes do not allow this operation. | [`forbidden`](/code/api/errors/forbidden) | Use a key whose scopes cover the operation, or ask an owner of the namespace to grant them. | None. |

**Example**

```bash
npx startup-builder do Collection.export --json '{"collection":"collection_txTK8QorKn","to":"Example to"}'
```

### Collection.query
Query reads any Nouns the caller’s Permissions allow, by SQL or a Relationship path, across every System in one call. [Verb page](/business/nouns/collection/query?interface=cli).

```text
npx startup-builder do Collection.query --json '<input>' [--try | --send | --do]
```

Emits [`Collection.queried`](/business/events/Collection.queried).

**Inputs**

| Input | Type | Required | Description |
| --- | --- | --- | --- |
| `query` | `text` | Yes | SQL, or a Relationship path such as `customer.subscriptions.invoices`. |
| `save` | `boolean` | No | True saves it as a Collection defined by the query. |

**Returns**

| Output | Type | Required | Description |
| --- | --- | --- | --- |
| `rows` | `json` | Yes | The matching records. |
| `collection` | [Collection](/business/nouns/collection) | Yes | The Collection the query read. |

**Refuses when**

| Check | Error | Fix | Then call |
| --- | --- | --- | --- |
| The key is valid, but its scopes do not allow this operation. | [`forbidden`](/code/api/errors/forbidden) | Use a key whose scopes cover the operation, or ask an owner of the namespace to grant them. | None. |

**Example**

```bash
npx startup-builder do Collection.query --json '{"query":"Example query"}'
```