Skip to main content
GET
/
api
/
datachecks
/
sqltests
/
v1
ListSqlTests
curl --request GET \
  --url https://developer.synq.io/api/datachecks/sqltests/v1 \
  --header 'Authorization: Bearer <token>'
{
  "sqlTests": [
    {
      "platform": {
        "bigquery": {
          "project": "<string>"
        }
      },
      "id": "<string>",
      "name": "<string>",
      "description": "<string>",
      "severity": "SEVERITY_UNSPECIFIED",
      "sqlExpression": "<string>",
      "recurrenceRule": "<string>",
      "annotations": [
        {
          "name": "<string>",
          "values": [
            "<string>"
          ]
        }
      ],
      "saveFailures": true,
      "template": {
        "identifier": {
          "airflowDag": {
            "integrationId": "<string>",
            "dagId": "<string>"
          }
        },
        "acceptedValuesTest": {
          "columnName": "<string>",
          "acceptedValues": [
            {
              "stringLiteral": "<string>",
              "expression": "<string>"
            }
          ]
        }
      },
      "configId": "<string>",
      "source": "SOURCE_APP"
    }
  ],
  "pageInfo": {
    "totalCount": 123,
    "count": 123,
    "lastId": "<string>"
  }
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

annotations.name
string
required

String key for the annotation.

Required string length: 1 - 100
annotations.values
string[]

Optional list of values that the annotation can carry.

Maximum length: 20
integrationIds
string[]
ids
string[]
configIds
string[]
sources
enum<string>[]
pagination.cursor
string

Cursor for the next page of results. If not provided, returns the first page.

pagination.pageSize
integer

Maximum number of items to return in a single page. If not provided, defaults vary per API.

Required range: x >= 0

Response

200 - application/json

Success

pageInfo
object
required

Paging information

sqlTests
SqlTest · object[]