Column
Log in using the POST /api/v1/auth/ endpoint
Success: Column reset
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullPossible values: Column not found
POST /api/v1/column/{column_id}/reset/ HTTP/1.1
Accept: */*
{
"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",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"default_generator_config": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"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"
]
}Log in using the POST /api/v1/auth/ endpoint
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullPossible values: Message: unable to generate preview data using the settings provided
Message: unable to fetch column from external service
POST /api/v1/column/{column_id}/update_create/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 390
{
"id": "123e4567-e89b-12d3-a456-426614174000",
"cardinality_threshold": 1,
"rare_category_replacement": "text",
"clip_threshold": 1,
"locale": "text",
"pii_mock_replace": true,
"has_pii": true,
"generator_config": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"pii_deselected_entities": [
"text"
]
}{
"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",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"default_generator_config": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"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"
]
}Log in using the POST /api/v1/auth/ endpoint
nullnullnullnullnullnullPossible values: nullPossible values: nullnullfalseNAMEPossible values: Success: List of columns
nullMessage: unable to fetch database from external service
POST /api/v1/column/{database_id}/filter/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 492
{
"column_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"not_table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"schema_names": [
"text"
],
"column_names": [
"text"
],
"protected_status": "PROTECTED",
"pii_status": "PII",
"min_confidence_score": 1,
"max_confidence_score": 1,
"sort_descending": false,
"sort_by": "NAME",
"schema_entities_included": [
{
"schema_name": "text",
"entity": "table"
}
],
"schema_entities_excluded": [
{
"schema_name": "text",
"entity": "table"
}
]
}{
"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",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"default_generator_config": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"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"
],
"table_schema_name": "text",
"table_name": "text",
"is_excluded": true,
"suggested_generators": [
{
"generator": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"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"
}
}
]
}
],
"n_suggested": 1,
"stats": {
"n_protected": 1,
"n_unprotected": 1,
"n_non_pii": 1
},
"pagination": {
"total_elements": 1,
"total_pages": 1,
"current_page": 1,
"returned_elements": 1,
"is_last_page": true
}
}Log in using the POST /api/v1/auth/ endpoint
nulltemporaryPossible values: 5000infoPossible values: nullnullnotificationPossible values: nullMessage: unable to set generator using the settings provided
Message: unable to fetch database from external service
POST /api/v1/column/{database_id}/generator/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 462
{
"column_schema": {
"id": "123e4567-e89b-12d3-a456-426614174000",
"cardinality_threshold": 1,
"rare_category_replacement": "text",
"clip_threshold": 1,
"locale": "text",
"pii_mock_replace": true,
"has_pii": true,
"generator_config": {
"name": "text",
"display_name": "AI synthesize",
"params": {},
"links": [
{
"association": "text",
"params": {},
"generator": {}
}
],
"is_default": false,
"is_applied": true
},
"pii_deselected_entities": [
"text"
]
},
"column_ids": [
"123e4567-e89b-12d3-a456-426614174000"
]
}{
"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"
}Log in using the POST /api/v1/auth/ endpoint
nulltemporaryPossible values: 5000infoPossible values: nullnullnotificationPossible values: nullMessage: unable to fetch database from external service
POST /api/v1/column/{database_id}/pii/?has_pii=true HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 48
{
"ids": [
"123e4567-e89b-12d3-a456-426614174000"
]
}{
"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"
}Log in using the POST /api/v1/auth/ endpoint
nulltemporaryPossible values: 5000infoPossible values: nullnullnotificationPossible values: nullMessage: unable to fetch column from external service
POST /api/v1/column/{database_id}/reset_columns/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 55
{
"column_ids": [
"123e4567-e89b-12d3-a456-426614174000"
]
}{
"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"
}Log in using the POST /api/v1/auth/ endpoint
nullnullnullnullnullnullPossible values: nullPossible values: nullnullfalseNAMEPossible values: Success: Column PII Stats
nullnullnullMessage: unable to fetch database from external service
POST /api/v1/column/{database_id}/stats/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 492
{
"column_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"not_table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"schema_names": [
"text"
],
"column_names": [
"text"
],
"protected_status": "PROTECTED",
"pii_status": "PII",
"min_confidence_score": 1,
"max_confidence_score": 1,
"sort_descending": false,
"sort_by": "NAME",
"schema_entities_included": [
{
"schema_name": "text",
"entity": "table"
}
],
"schema_entities_excluded": [
{
"schema_name": "text",
"entity": "table"
}
]
}{
"n_protected": 1,
"n_unprotected": 1,
"n_non_pii": 1
}Log in using the POST /api/v1/auth/ endpoint
nullnullnullnullnullnullPossible values: nullPossible values: nullnullfalseNAMEPossible values: nulltemporaryPossible values: 5000infoPossible values: nullnullnotificationPossible values: nullMessage: unable to fetch database from external service
POST /api/v1/column/{database_id}/suggested/?apply=true HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 492
{
"column_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"not_table_ids": [
"123e4567-e89b-12d3-a456-426614174000"
],
"schema_names": [
"text"
],
"column_names": [
"text"
],
"protected_status": "PROTECTED",
"pii_status": "PII",
"min_confidence_score": 1,
"max_confidence_score": 1,
"sort_descending": false,
"sort_by": "NAME",
"schema_entities_included": [
{
"schema_name": "text",
"entity": "table"
}
],
"schema_entities_excluded": [
{
"schema_name": "text",
"entity": "table"
}
]
}{
"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"
}Log in using the POST /api/v1/auth/ endpoint
Message: unable to get supported generators using the settings provided
Message: unable to fetch database from external service
POST /api/v1/column/{database_id}/supported_generators/ HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 48
{
"ids": [
"123e4567-e89b-12d3-a456-426614174000"
]
}{
"Mockers": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Mask": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Calculated_column": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Dynamic": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Duplicate": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Exclude": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Hash": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
},
"Generate": {
"ANY_ADDITIONAL_PROPERTY": {
"display_name": "text",
"options": {
"text": "text",
"output": [
"categorical"
],
"suggested": {}
},
"fields": {
"ANY_ADDITIONAL_PROPERTY": {
"type": "text",
"default": "text",
"max_length": 1,
"read_only": false
}
}
}
}
}Last updated
Was this helpful?

