Skip to main content
POST
/
queries
Create query
curl --request POST \
  --url https://api.flipsidecrypto.xyz/public/v3/queries \
  --header 'Content-Type: application/json' \
  --data '
{
  "name": "<string>",
  "sql": "<string>",
  "description": "<string>",
  "metadata": null,
  "userAgent": "web",
  "parameters": [],
  "agentRunId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "dataSourceId": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
}
'
{
  "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "name": "<string>",
  "sql": "<string>",
  "lastSuccessfulRunId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "lastQueryRunId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "slug": "<string>",
  "parameters": [
    {
      "name": "<string>",
      "type": "string",
      "description": "<string>",
      "defaultValue": "<string>"
    }
  ],
  "agentRunId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "dataSourceId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "organizationId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "createdById": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "updatedById": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "createdAt": "2023-11-07T05:31:56Z",
  "updatedAt": "2023-11-07T05:31:56Z",
  "description": "<string>",
  "metadata": null,
  "userAgent": "web"
}

Body

application/json
​
name
string
required
Required string length: 1 - 500
​
sql
string
required
​
description
string | null
Maximum string length: 2000
​
metadata
unknown
​
userAgent
enum<string> | null
Available options:
web,
cli,
internal-cli,
api,
slack,
discord,
telegram,
schedule,
unknown,
null
​
parameters
object[] | null
​
agentRunId
string<uuid> | null
​
dataSourceId
string<uuid> | null

Response

Query created successfully

​
id
string<uuid>
required
​
name
string
required
Required string length: 1 - 500
​
sql
string
required
​
lastSuccessfulRunId
string<uuid> | null
required
​
lastQueryRunId
string<uuid> | null
required
​
slug
string
required
Maximum string length: 255
​
parameters
object[] | null
required
​
agentRunId
string<uuid> | null
required
​
dataSourceId
string<uuid> | null
required
​
organizationId
string<uuid>
required
​
createdById
string<uuid>
required
​
updatedById
string<uuid>
required
​
createdAt
string<date-time>
required
​
updatedAt
string<date-time>
required
​
description
string | null
Maximum string length: 2000
​
metadata
unknown
​
userAgent
enum<string> | null
Available options:
web,
cli,
internal-cli,
api,
slack,
discord,
telegram,
schedule,
unknown,
null