ImportCsvBody

Body for Import CSV. The file must already be uploaded to Floqer; pass its object key.

Properties

file_refstringrequired

Object key of the already-uploaded file, exactly as Floqer issued it. Not a URL — a URL is rejected. The file must have been uploaded by someone in your organization.

mappingobjectrequired

Column header in the file -> input field name on the sheet. Field names come from List Inputs and must match exactly (case- and whitespace-sensitive). Headers are read from row 1; naming a header the file does not have fails the import and reports which one. Columns omitted here are not imported; input fields with no column are left empty. Two columns may not map to the same field.

sheet_namestring

XLSX only — which worksheet to import. Defaults to the first sheet in the workbook. Naming a sheet the workbook does not have fails the import.

run_after_importstring

What to run once the rows are imported. Scoped to the imported rows only — pre-existing rows on the sheet are never touched. `none` (default) — import, don't run. `first_10` — queue up to 10 of the imported rows; recommended before committing to a full file. `all` — queue every imported row (WARNING: full credit cost = N rows x actions in chain; verify output on `first_10` first).

"none""first_10""all"

Example

ImportCsvBody example
{
  "file_ref": "leads.csv_jane@acme.com_9f3c1a2b-4d5e-6f70-8a9b-0c1d2e3f4a5b.csv",
  "mapping": {
    "Email": "email",
    "Company Name": "company_name",
    "LinkedIn URL": "linkedin_url"
  },
  "sheet_name": "string",
  "run_after_import": "none"
}