Skip to main content
POST
/
api
/
datawarehouse
/
v1
/
connection
/
{connection_id}
/
upload
/
{upload_id}
/
table-constraints
IngestTableConstraints
curl --request POST \
  --url https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/table-constraints \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "stateAt": "2023-11-07T05:31:56Z",
  "tableConstraints": [
    {
      "constraints": [
        {
          "name": "<string>",
          "type": "<string>",
          "columns": [
            "<string>"
          ],
          "foreignKeyTarget": {
            "objectName": "<string>",
            "instanceName": "<string>",
            "databaseName": "<string>",
            "schemaName": "<string>"
          },
          "foreignKeyTargetColumns": [
            "<string>"
          ],
          "indexType": "<string>",
          "expression": "<string>",
          "isUnique": true,
          "isEnforced": true
        }
      ]
    }
  ]
}
'
{}

Documentation Index

Fetch the complete documentation index at: https://docs.synq.io/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

​
Authorization
string
header
required

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

Path Parameters

​
connection_id
string
required
​
upload_id
string<uuid>
required

Body

application/json
​
stateAt
string<date-time>
required

Time at which state was collected timestamp.gt = 2022-01-01T00:00:00Z timestamp.gt_lt = 2022-01-01T00:00:00Z timestamp.gt_lt_exclusive = 2022-01-01T00:00:00Z timestamp.gt_lte = 2022-01-01T00:00:00Z timestamp.gt_lte_exclusive = 2022-01-01T00:00:00Z timestamp.lt_now = true

Examples:

"2023-01-15T01:30:15.01Z"

"2024-12-25T12:00:00Z"

​
tableConstraints
TableConstraints · object[]

Response

200 - application/json

Success

The response is of type IngestTableConstraintsResponse · object.