Storage

SDK reference for storage — Manage saved SQL queries and execute queries against project storage.

Manage saved SQL queries and execute queries against project storage.

listQueries

GET

Usage:

const result = await swirls.client.storage.listQueries({
  projectId: '...',
})

Input:

Parameter	Type	Required	Description
`projectId`	`string`	Yes

GET

Usage:

const result = await swirls.client.storage.getQuery({
  id: '...',
})

Input:

Parameter	Type	Required	Description
`id`	`string`	Yes

POST

Usage:

const result = await swirls.client.storage.createQuery({
  projectId: '...',
  name: '...',
  sql: '...',
})

Input:

Parameter	Type	Required
`projectId`	`string`	Yes
`name`	`string`	Yes
`sql`	`string`	Yes

Output:

PUT

Usage:

const result = await swirls.client.storage.updateQuery({
  id: '...',
})

Input:

Parameter	Type	Required
`id`	`string`	Yes
`name`	`string`	No
`sql`	`string`	No

Output:

DELETE

Usage:

const result = await swirls.client.storage.deleteQuery({
  id: '...',
})

Input:

Parameter	Type	Required	Description
`id`	`string`	Yes

POST

Usage:

const result = await swirls.client.storage.executeQuery({
  projectId: '...',
  sql: '...',
})

Input:

Parameter	Type	Required	Description
`projectId`	`string`	Yes
`sql`	`string`	Yes

Output:

Field	Type	Description
`columns`	`string[]`
`rows`	`unknown[][]`