Input and output templates
Last updated
Last updated
Format: CSV, XLS, XLSX (In the case of XLS or XLSX, Clear will read only the first sheet in the file).
Template:
Purchase Document Line ObjectIn addition to the fields in the Clear PR template, we support up to 10 additional fields that can be ingested into Clear as custom fields (eg. Tax codes / ERP usernames/others).
Format: CSV (irrespective of the input file)
Template with Sample Data:
The template of the file will be the same as the input file. However, in addition to the columns in the input file, there will be 2 additional columns that have "No. of Errors" and "Error Message".
Format: GZIP File
This file will be in JSON Lines format where each line in the file is a separate JSON object.
Sample File:
Format: GZIP File
Sample File: