Search documentation
karat

+

K

User Documentation ↗

Create Table Import

POST/api/v2/connectivity/connections/{connectionRid}/tableImports
Warning

This endpoint is in preview and may be modified or removed at any time. To use this endpoint, add preview=true to the request query parameters.

Creates a new TableImport.

Third-party applications using this endpoint via OAuth2 must request the following operation scope: api:connectivity-table-import-write.

Path parameters

connectionRid
string

The Resource Identifier (RID) of a Connection (also known as a source).

Query parameters

preview
boolean
optional

Enables the use of preview functionality.

Request body

CreateTableImportRequest
object
Hide child attributes

Hide child attributes

datasetRid
string

The RID of the output dataset.

importMode
string (enum)

Import mode governs how data is read from an external system, and written into a Foundry dataset.

SNAPSHOT: Defines a new dataset state consisting only of data from a particular import execution. APPEND: Purely additive and yields data from previous import executions in addition to newly added data.

Enum values: SNAPSHOT, APPEND

displayName
string
allowSchemaChanges
boolean
optional

Allow the TableImport to succeed if the schema of imported rows does not match the existing dataset's schema. Defaults to false for new table imports.

branchName
string
optional

The branch name in the output dataset that will contain the imported data. Defaults to master for most enrollments.

config
union

The import configuration for a specific connector type.

Show child attributes

Show child attributes

Response body

TableImport
object

The created TableImport

Hide child attributes

Hide child attributes

rid
string

The Resource Identifier (RID) of a TableImport (also known as a batch sync).

connectionRid
string

The RID of the Connection (also known as a source) that the Table Import uses to import data.

datasetRid
string

The RID of the output dataset.

branchName
string
optional

The branch name in the output dataset that will contain the imported data. Defaults to master for most enrollments.

displayName
string
importMode
string (enum)

Import mode governs how data is read from an external system, and written into a Foundry dataset.

SNAPSHOT: Defines a new dataset state consisting only of data from a particular import execution. APPEND: Purely additive and yields data from previous import executions in addition to newly added data.

Enum values: SNAPSHOT, APPEND

allowSchemaChanges
boolean

Allow the TableImport to succeed if the schema of imported rows does not match the existing dataset's schema. Defaults to false for new table imports.

config
union

The import configuration for a specific connector type.

Show child attributes

Show child attributes

Examples

Request

Copied!
1 2 3 4 5 curl -X POST \ -H "Content-type: application/json" \ -H "Authorization: Bearer $TOKEN" \ "https://$HOSTNAME/api/v2/connectivity/connections/ri.magritte..source.c078b71b-92f9-41b6-b0df-3760f411120b/tableImports?preview=true" \ -d '{"datasetRid":"ri.foundry.main.dataset.c26f11c8-cdb3-4f44-9f5d-9816ea1c82da","importMode":"SNAPSHOT","displayName":"My table import","allowSchemaChanges":true,"branchName":"master"}'

Response

Copied!
1 2 3 4 5 6 7 8 9 { "datasetRid": "ri.foundry.main.dataset.c26f11c8-cdb3-4f44-9f5d-9816ea1c82da", "importMode": "SNAPSHOT", "displayName": "My table import", "allowSchemaChanges": true, "connectionRid": "ri.magritte..source.c078b71b-92f9-41b6-b0df-3760f411120b", "branchName": "master", "rid": "ri.magritte..extract.27bb4f2b-63b8-44b8-a579-4e2bd65ba158" }

Error responses

Error Name
CreateTableImportPermissionDeniedError CodePERMISSION_DENIED
Status Code403
DescriptionCould not create the TableImport.
ParametersconnectionRid