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 response id can be passed in the sample_data field when calling the Create Pipeline endpoint to easily create a pipeline with the joined data.

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

​
lume-api-key
string
headerrequired

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
Delete Target SchemaGet Joined Data