Table | Syntho Documentation

put

Update table

Authorizations

sessionidstringRequired

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

Body

Responses

200

Success: updated table

application/json

503

Message: unable to fetch table from external service

put

/api/v1/table/

PUT /api/v1/table/ HTTP/1.1
Host: /
Content-Type: application/json
Accept: */*
Content-Length: 312

{
  "tables": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "n_rows": 1,
      "n_rows_source": 1,
      "fk_scan": true,
      "is_excluded": true,
      "processing_config": {
        "type": "text"
      },
      "read_random_subset": true,
      "n_training_rows": 1,
      "max_sequence_length": 1,
      "long_sequence_threshold": 1,
      "adjust_n_rows_allowed": true,
      "order_by_columns": [
        "text"
      ]
    }
  ]
}

{
  "ids": [
    "123e4567-e89b-12d3-a456-426614174000"
  ],
  "status": "text"
}

put

Authorizations

sessionidstringRequired

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

Path parameters

database_idstringRequired

Query parameters

is_excludedbooleanRequired

Body

schema_namesany ofOptionalDefault: null

string[]Optional

or

nullOptional

table_idsany ofOptionalDefault: null

string · uuid[]Optional

or

nullOptional

not_table_idsany ofOptionalDefault: null

string · uuid[]Optional

or

nullOptional

Responses

204

No response body

put

/api/v1/table/{database_id}/exclude/

PUT /api/v1/table/{database_id}/exclude/?is_excluded=true HTTP/1.1
Host: /
Content-Type: application/json
Accept: */*
Content-Length: 135

{
  "schema_names": [
    "text"
  ],
  "table_ids": [
    "123e4567-e89b-12d3-a456-426614174000"
  ],
  "not_table_ids": [
    "123e4567-e89b-12d3-a456-426614174000"
  ]
}

204

No response body

No content

get

Get single table

Authorizations

sessionidstringRequired

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

Path parameters

table_idstringRequired

Responses

200

Success: Single table

application/json

503

Message: unable to fetch table from external service

get

/api/v1/table/{table_id}/

GET /api/v1/table/{table_id}/ HTTP/1.1
Host: /
Accept: */*

{
  "id": "123e4567-e89b-12d3-a456-426614174000",
  "n_rows": 1,
  "n_rows_source": 1,
  "fk_scan": true,
  "is_excluded": true,
  "processing_config": {
    "type": "text"
  },
  "read_random_subset": true,
  "n_training_rows": 1,
  "max_sequence_length": 1,
  "long_sequence_threshold": 1,
  "adjust_n_rows_allowed": true,
  "order_by_columns": [
    "text"
  ],
  "database_id": "123e4567-e89b-12d3-a456-426614174000",
  "name": "text",
  "schema_name": "text",
  "primary_keys": [],
  "unique_columns": [
    [
      "text"
    ]
  ],
  "index_columns": [
    [
      "text"
    ]
  ],
  "check_constraints": [
    {}
  ],
  "data_in_target": true,
  "sample_noise_ratio": 1,
  "max_n_feat_per_model": 1,
  "feat_model_train_order": "text",
  "end_of_sequence_token": 1,
  "min_sample_size": 1,
  "columns": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "generator_id": "123e4567-e89b-12d3-a456-426614174000",
      "name": "text",
      "idx": 1,
      "dtype": "text",
      "col_dtype": "categorical",
      "sql_type": "text",
      "unique": true,
      "nullable": true,
      "autoincrement": true,
      "pii_scan": true,
      "has_pii": true,
      "has_unprotected_pii": true,
      "min_value": "text",
      "max_value": "text",
      "pii": [
        {
          "id": "123e4567-e89b-12d3-a456-426614174000",
          "column_id": "123e4567-e89b-12d3-a456-426614174000",
          "pii_type": "text",
          "confidence_score": 1,
          "scan_type": "text",
          "explanation": {},
          "generation_method": "text"
        }
      ],
      "cardinality_threshold": 1,
      "rare_category_replacement": "text",
      "clip_threshold": 1,
      "locale": "text",
      "pii_mock_replace": true,
      "pii_deselected_entities": [
        "text"
      ],
      "generator_config": {
        "name": "text",
        "params": {},
        "links": [
          {
            "association": "text",
            "params": {},
            "generator": {}
          }
        ]
      },
      "default_generator_config": {
        "name": "text",
        "params": {},
        "links": [
          {
            "association": "text",
            "params": {},
            "generator": {}
          }
        ]
      },
      "is_rejected": true,
      "is_key": true,
      "is_pk": true,
      "is_fk": true,
      "is_uk": true,
      "is_referred": true,
      "database_exclude_from_write": true,
      "sync_status": "new",
      "sync_diff": [
        "DATA_TYPE_UPDATE"
      ]
    }
  ],
  "n_columns": 1,
  "subsetting_config": {
    "id": "123e4567-e89b-12d3-a456-426614174000",
    "table_id": "123e4567-e89b-12d3-a456-426614174000",
    "processing_type": "text",
    "percentage": 1,
    "is_linked": true,
    "where_clause": "text"
  },
  "has_unprotected_pii": true,
  "sync_status": "new",
  "sync_diff": [
    "PRIMARY_KEY_UPDATE"
  ],
  "warnings": [
    "HAS_EXCLUDED_REFERENCES"
  ],
  "index": 1,
  "kind": "text",
  "engine_id": "123e4567-e89b-12d3-a456-426614174000",
  "applied_steps": [
    {
      "column_id": "123e4567-e89b-12d3-a456-426614174000",
      "column_name": "text",
      "generator_name": "text",
      "cardinality_threshold": 1,
      "rare_category_replacement": "text",
      "clip_threshold": 1,
      "generator_type": "Dynamic"
    }
  ],
  "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"
    }
  ],
  "supported_table_processors": [
    {
      "type": "SingleTableModel",
      "fields": [
        {
          "type": "text",
          "text": "text",
          "default": "text"
        }
      ],
      "enabled": true,
      "messages": [
        "OVERSAMPLING_DISABLED"
      ]
    }
  ],
  "has_data_learner": true
}

get

List first 100 rows of table

Authorizations

sessionidstringRequired

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

Path parameters

table_idstringRequired

Responses

200

Success: List of table rows

application/json

400

Error: could not validate data returned by external service

503

Message: unable to fetch table preview from external service

get

/api/v1/table/{table_id}/preview/

GET /api/v1/table/{table_id}/preview/ HTTP/1.1
Host: /
Accept: */*

{
  "results": [
    {}
  ]
}

post

Update table subsetting config

Authorizations

sessionidstringRequired

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

Path parameters

table_idstringRequired

Body

processing_typestringRequired

percentageany ofOptionalDefault: null

integerOptional

or

nullOptional

where_clauseany ofOptionalDefault: null

stringOptional

or

nullOptional

Responses

200

Success: set subject table config

application/json

503

Message: unable to fetch table from external service

post

/api/v1/table/{table_id}/set_subsetting/

POST /api/v1/table/{table_id}/set_subsetting/ HTTP/1.1
Host: /
Content-Type: application/json
Accept: */*
Content-Length: 63

{
  "processing_type": "text",
  "percentage": 1,
  "where_clause": "text"
}

{
  "id": "123e4567-e89b-12d3-a456-426614174000",
  "n_rows": 1,
  "n_rows_source": 1,
  "fk_scan": true,
  "is_excluded": true,
  "processing_config": {
    "type": "text"
  },
  "read_random_subset": true,
  "n_training_rows": 1,
  "max_sequence_length": 1,
  "long_sequence_threshold": 1,
  "adjust_n_rows_allowed": true,
  "order_by_columns": [
    "text"
  ],
  "database_id": "123e4567-e89b-12d3-a456-426614174000",
  "name": "text",
  "schema_name": "text",
  "primary_keys": [],
  "unique_columns": [
    [
      "text"
    ]
  ],
  "index_columns": [
    [
      "text"
    ]
  ],
  "check_constraints": [
    {}
  ],
  "data_in_target": true,
  "sample_noise_ratio": 1,
  "max_n_feat_per_model": 1,
  "feat_model_train_order": "text",
  "end_of_sequence_token": 1,
  "min_sample_size": 1,
  "columns": [
    {
      "id": "123e4567-e89b-12d3-a456-426614174000",
      "table_id": "123e4567-e89b-12d3-a456-426614174000",
      "generator_id": "123e4567-e89b-12d3-a456-426614174000",
      "name": "text",
      "idx": 1,
      "dtype": "text",
      "col_dtype": "categorical",
      "sql_type": "text",
      "unique": true,
      "nullable": true,
      "autoincrement": true,
      "pii_scan": true,
      "has_pii": true,
      "has_unprotected_pii": true,
      "min_value": "text",
      "max_value": "text",
      "pii": [
        {
          "id": "123e4567-e89b-12d3-a456-426614174000",
          "column_id": "123e4567-e89b-12d3-a456-426614174000",
          "pii_type": "text",
          "confidence_score": 1,
          "scan_type": "text",
          "explanation": {},
          "generation_method": "text"
        }
      ],
      "cardinality_threshold": 1,
      "rare_category_replacement": "text",
      "clip_threshold": 1,
      "locale": "text",
      "pii_mock_replace": true,
      "pii_deselected_entities": [
        "text"
      ],
      "generator_config": {
        "name": "text",
        "params": {},
        "links": [
          {
            "association": "text",
            "params": {},
            "generator": {}
          }
        ]
      },
      "default_generator_config": {
        "name": "text",
        "params": {},
        "links": [
          {
            "association": "text",
            "params": {},
            "generator": {}
          }
        ]
      },
      "is_rejected": true,
      "is_key": true,
      "is_pk": true,
      "is_fk": true,
      "is_uk": true,
      "is_referred": true,
      "database_exclude_from_write": true,
      "sync_status": "new",
      "sync_diff": [
        "DATA_TYPE_UPDATE"
      ]
    }
  ],
  "n_columns": 1,
  "subsetting_config": {
    "id": "123e4567-e89b-12d3-a456-426614174000",
    "table_id": "123e4567-e89b-12d3-a456-426614174000",
    "processing_type": "text",
    "percentage": 1,
    "is_linked": true,
    "where_clause": "text"
  },
  "has_unprotected_pii": true,
  "sync_status": "new",
  "sync_diff": [
    "PRIMARY_KEY_UPDATE"
  ],
  "warnings": [
    "HAS_EXCLUDED_REFERENCES"
  ],
  "index": 1,
  "kind": "text"
}

Good morning