Foreign Keys

get

List of foreign keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Responses

200

Success: List of foreign keys

application/json

422

Message: unable to fetch engine from external service

application/json

get/api/v1/foreign_keys/{database_id}/

HTTPcURLJavaScriptPython

GET /api/v1/foreign_keys/{database_id}/ HTTP/1.1
Accept: */*

{
  "foreign_keys": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "references_table_id": "123e4567-e89b-12d3-a456-426614174000",
      "name": "text",
      "apply": true,
      "is_virtual": true,
      "scan_result": 1,
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text",
      "sync_status": "new"
    }
  ]
}

post

Create virtual foreign key

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Body

application/json

Responses

200

Success: Created foreign keys

application/json

idstring · nullableOptionalDefault: null

codestringRequired

titlestringRequired

bodystring[]Required

durabilitystring · enum · nullableOptionalDefault: temporaryPossible values:

durationinteger · nullableOptionalDefault: 5000

kindstring · enum · nullableOptionalDefault: infoPossible values:

payloadanyOptionalDefault: null

actionobject · Action · nullableOptionalDefault: null

displaystring · enum · nullableOptionalDefault: notificationPossible values:

created_atstring · nullableOptionalDefault: null

400

Import error

application/json

post/api/v1/foreign_keys/{database_id}/create/

HTTPcURLJavaScriptPython

POST /api/v1/foreign_keys/{database_id}/create/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 276

{
  "foreign_keys": [
    {
      "name": "text",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "references_table_id": "123e4567-e89b-12d3-a456-426614174000",
      "apply": true,
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text"
    }
  ]
}

{
  "id": "text",
  "code": "text",
  "title": "text",
  "body": [
    "text"
  ],
  "durability": "temporary",
  "duration": 5000,
  "kind": "info",
  "details": {
    "ANY_ADDITIONAL_PROPERTY": [
      "text"
    ]
  },
  "payload": null,
  "action": {},
  "display": "notification",
  "created_at": "text"
}

get

Export list of foreign keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Responses

200

Success: Exported list of foreign keys

application/json

503

Message: unable to fetch engine from external service

get/api/v1/foreign_keys/{database_id}/export/

HTTPcURLJavaScriptPython

GET /api/v1/foreign_keys/{database_id}/export/ HTTP/1.1
Accept: */*

{
  "foreign_keys": [
    {
      "apply": true,
      "name": "text",
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text"
    }
  ]
}

post

Filter foreign keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Query parameters

elements_per_pageintegerOptional

keywordstringOptional

requested_pageintegerOptional

Body

application/json

is_virtualboolean · nullableRequired

is_appliedboolean · nullableRequired

fk_columnsstring[] · nullableRequired

pk_columnsstring[] · nullableRequired

table_idsstring[] · nullableRequired

Responses

200

Success: Paginated filtered list of foreign keys

application/json

503

Message: unable to fetch engine from external service

post/api/v1/foreign_keys/{database_id}/filter/

HTTPcURLJavaScriptPython

POST /api/v1/foreign_keys/{database_id}/filter/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 102

{
  "is_virtual": true,
  "is_applied": true,
  "fk_columns": [
    "text"
  ],
  "pk_columns": [
    "text"
  ],
  "table_ids": [
    "text"
  ]
}

{
  "foreign_keys": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "references_table_id": "123e4567-e89b-12d3-a456-426614174000",
      "name": "text",
      "apply": true,
      "is_virtual": true,
      "scan_result": 1,
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text",
      "sync_status": "new"
    }
  ],
  "pagination": {
    "total_elements": 1,
    "total_pages": 1,
    "current_page": 1,
    "returned_elements": 1,
    "is_last_page": true
  }
}

post

Import list of foreign keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Body

application/json

Responses

200

Success: list of foreign keys imported

application/json

idstring · nullableOptionalDefault: null

codestringRequired

titlestringRequired

bodystring[]Required

durabilitystring · enum · nullableOptionalDefault: temporaryPossible values:

durationinteger · nullableOptionalDefault: 5000

kindstring · enum · nullableOptionalDefault: infoPossible values:

payloadanyOptionalDefault: null

actionobject · Action · nullableOptionalDefault: null

displaystring · enum · nullableOptionalDefault: notificationPossible values:

created_atstring · nullableOptionalDefault: null

400

Import error

application/json

503

Message: unable to fetch engine from external service

post/api/v1/foreign_keys/{database_id}/import/

HTTPcURLJavaScriptPython

POST /api/v1/foreign_keys/{database_id}/import/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 165

{
  "foreign_keys": [
    {
      "apply": true,
      "name": "text",
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text"
    }
  ]
}

{
  "id": "text",
  "code": "text",
  "title": "text",
  "body": [
    "text"
  ],
  "durability": "temporary",
  "duration": 5000,
  "kind": "info",
  "details": {
    "ANY_ADDITIONAL_PROPERTY": [
      "text"
    ]
  },
  "payload": null,
  "action": {},
  "display": "notification",
  "created_at": "text"
}

post

Scan for foreign keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Query parameters

allow_pk_stringsbooleanOptional

bidirectional_data_checkbooleanOptional

column_name_checkbooleanOptional

data_batch_sizeintegerOptional

exact_data_type_checkbooleanOptional

n_scannersintegerOptional

pk_scanbooleanOptional

Responses

204

Success: Started the job

No content

503

Message: unable to fetch engine from external service

post/api/v1/foreign_keys/{database_id}/scan/

HTTPcURLJavaScriptPython

POST /api/v1/foreign_keys/{database_id}/scan/ HTTP/1.1
Accept: */*

No content

get

Get foreign keys stats

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

database_idstringRequired

Responses

200

Success: foreign keys stats

application/json

n_virtualinteger · nullableOptionalDefault: null

503

Message: unable to fetch engine from external service

get/api/v1/foreign_keys/{database_id}/stats/

HTTPcURLJavaScriptPython

GET /api/v1/foreign_keys/{database_id}/stats/ HTTP/1.1
Accept: */*

{
  "n_virtual": 1
}

delete

Delete foreign key

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Path parameters

foreign_key_idstringRequired

Responses

200Success

application/json

idstring · nullableOptionalDefault: null

codestringRequired

titlestringRequired

bodystring[]Required

durabilitystring · enum · nullableOptionalDefault: temporaryPossible values:

durationinteger · nullableOptionalDefault: 5000

kindstring · enum · nullableOptionalDefault: infoPossible values:

payloadanyOptionalDefault: null

actionobject · Action · nullableOptionalDefault: null

displaystring · enum · nullableOptionalDefault: notificationPossible values:

created_atstring · nullableOptionalDefault: null

delete/api/v1/foreign_keys/{foreign_key_id}/delete/

HTTPcURLJavaScriptPython

DELETE /api/v1/foreign_keys/{foreign_key_id}/delete/ HTTP/1.1
Accept: */*

200Success

{
  "id": "text",
  "code": "text",
  "title": "text",
  "body": [
    "text"
  ],
  "durability": "temporary",
  "duration": 5000,
  "kind": "info",
  "details": {
    "ANY_ADDITIONAL_PROPERTY": [
      "text"
    ]
  },
  "payload": null,
  "action": {},
  "display": "notification",
  "created_at": "text"
}

post

Resolve foreign_keys

Authorizations

authenticationOIDC

sessionidstringRequired

Log in using the POST /api/v1/auth/ endpoint

Body

application/json

Responses

200

Success: Resolved foreign keys

application/json

503

Message: unable to fetch engine from external service

post/api/v1/foreign_keys/update_batch/

HTTPcURLJavaScriptPython

POST /api/v1/foreign_keys/update_batch/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 320

{
  "foreign_keys": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "apply": true,
      "name": "text",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "references_table_id": "123e4567-e89b-12d3-a456-426614174000",
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text"
    }
  ]
}

{
  "foreign_keys": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "references_table_id": "123e4567-e89b-12d3-a456-426614174000",
      "name": "text",
      "apply": true,
      "is_virtual": true,
      "scan_result": 1,
      "fk_columns": [
        "text"
      ],
      "fk_schema": "text",
      "fk_table": "text",
      "pk_columns": [
        "text"
      ],
      "pk_schema": "text",
      "pk_table": "text",
      "sync_status": "new"
    }
  ]
}