File Upload

Audiences specified by a list of identifiers with their associated traits

The file upload source enables you to upload CSV , TSV or JSON files containing emails, phone numbers, and other identifiers as well as their respective traits. In order for your first-party dataset to be properly ingested in your DCN, you must first ensure that it respects the specified format.

Formatting Your XLSX, CSV or TSV File

In order for your XLSX, CSV or TSV to be successfully ingested into your DCN, it must follow an established schema which is outlined within our tabular data schema section. Once your data has been properly organized and the columns follow the proper schema, you will be able to upload your file to your node.

File Upload also supports the above files in GZIP format.

Formatting Your JSON File

Your JSON object must follow the standardized ID profile detailed on the loading ID profiles section. Once the JSON object is formatted correctly, you will be able to upload it to your DCN, and all of your identifiers will be ingested alongside their scope and traits.

Uploading a File as a Data Source

Once your file is ready, you can upload your file as a source by going to Integrations > Sources. Within the source selection page, select "File Upload" and proceed to name your source.

By default an audience will be automatically created using the specified source name, you can use this audience for matching, activation, or exporting it to a destination.

Every subsequent file that you upload, within a previously set up source, will replace the previous file and will be added to the source history. This can be used either as a reference or to check the status of the processing of your source.

Creating Your File Upload Source via CLI

To create a file upload source, you need to have a file with type-prefixed identifiers which is either an XLSX, CSV, TSV or JSON file with proper formatting. You can create the source using the CLI by running the following command:

optable-cli source create file --file=<path>

For example, if the path to your file is /my/path/file.dat, you can create an audience with it as follows:

optable-cli source create file "new file upload" --file=/my/path/file.dat

A JSON description of the newly created dataset audience is returned on success.

Editing Your File Upload Source via CLI

To update your file upload source, run the following command:

optable-cli source ingest file <id> <file>

Last updated