POST
/
joined_data

This endpoint allows you to upload multiple input files (CSV, JSON, or a single Excel file) to automatically detect table relationships and join them. The result has joined_data_id that can be used to create a pipeline using the Create Mapping endpoint using the , eliminating the need to provide new data to the pipeline.

The join_strategy parameter (either exact or fuzzy) will determine the method of joining: exact will trigger a direct join, while fuzzy will use fuzzy matching to create entity resolution in the batch of data.

The metadata parameter allows you to add your table relationships beforehand, if it is known.

Authorizations

Authorization
string
headerrequired

The access token received from the authorization server in the OAuth 2.0 flow.

Body

multipart/form-data
files
file[]
required

The source files to process

top_sheet_name
string
required

The topmost source file table name. The list of joined records will correspond 1:1 with the rows in this table.

metadata
string
default:

Mapping from source file table name to table metadata. Only sheets with metadata will be processed.

join_strategy
enum<string>

The strategy to use for joining tables.

Available options:
exact,
fuzzy

Response

200 - application/json
id
string
required

The id of the joined data.

name
string
required

The name of the source data file.

status
string
required

The status of the joined data.

created_at
string
required
updated_at
string | null
required
Get mappingGet pipeline