POST
/
api
/
datachecks
/
sqltests
/
v1
BatchUpsertSqlTests
curl --request POST \
  --url https://developer.synq.io/api/datachecks/sqltests/v1 \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "sqlTests": [
    {
      "platform": {
        "bigquery": {
          "project": "<string>"
        }
      },
      "id": "<string>",
      "name": "<string>",
      "sqlExpression": "<string>",
      "recurrenceRule": "<string>",
      "annotations": [
        {
          "name": "<string>",
          "values": [
            "<string>"
          ]
        }
      ],
      "saveFailures": true
    }
  ]
}'
{
  "createdIds": [
    "<string>"
  ],
  "updatedIds": [
    "<string>"
  ],
  "errors": [
    {
      "id": "<string>",
      "reason": "<string>"
    }
  ]
}

Authorizations

​
Authorization
string
header
required

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

Body

application/json
​
sqlTests
SqlTest · object[]

List of SqlTests to upsert. The upsert is performed based on the unique path provided for each SqlTest.

Response

200 - application/json

Success

​
createdIds
string[]

IDs for which SqlTests were created without error.

​
updatedIds
string[]

IDs for which SqlTests were updated without error.

​
errors
UpsertError · object[]

Errors raised while upsert. This list will be empty if there were no errors.