Data Loader API upload requirements
Learn about requirements for uploading different file types and sizes in the Reltio Data Loader API.
The Data Loader has different requirements for uploading various file formats.
Supported file formats and sizes
| File format | Requirements |
|---|---|
| CSV (comma-separated value) |
For general CSV requirement specifications, see topic RFC 4180 - Common Format and MIME Type for Comma-Separated Values (CSV) Files. |
| Microsoft Excel |
|
| JSON |
Remote and local files have a limit of 10 million rows per file, regardless of file size. Note: The allocation remains the same regardless of the location where you’re uploading from (local file system or remote storage).
|
For information about other Data Loader requirements, see topic Get ready for Data Loader.
Trim special characters
Before data is loaded into Reltio, we ensure that the following special characters are trimmed:
- Leading and trailing spaces: ' '.
- Leading and trailing tabs: \t.
- New line: \n.
- Carriage return: r.
Trimming special characters does not apply to RELTIO_JSON files, since unlike a normal JSON file, the RELTIO_JSON file contains the information needed for the data upload without requiring additional table transformation.