Sourcier Importer icon

Sourcier Importer

Map spreadsheet columns to Bullhorn entity fields with dynamic discovery and type coercion

Sourcier Importer

AI-generated

Summary

Map columns from input data to Bullhorn entity fields with optional type coercion and filtering, producing two outputs: mapped items and skipped items.

Inputs

  • Authentication (required) — Choose the Sourcier authentication method: 'BHH User Credentials' or 'BHH Enterprise Credentials'.
  • Bullhorn Entity (required) — Select the Bullhorn entity type (e.g., Candidate, ClientContact, Lead) to map input columns to. Use the refresh button to update available fields.
  • Column Mappings (required) — Define one or more mappings from source column names in the input data to Bullhorn entity fields.
  • Options — Optional settings including:
  • Force Refresh: bypass metadata cache to fetch fresh Bullhorn field definitions.
  • Include Unmapped Columns: include all original input columns in output's _raw property.
  • Filter Empty Rows: skip rows where all mapped columns are empty.
  • Source Tag: add a label for downstream routing in _source.tag.
  • Type Coercion: coerce input values to target field data types.

Output shape

Two lists of items, one with mapped output data and one with skipped rows.

The first output contains items with a JSON structure including _source metadata (entity, row number, optional tag) and a 'mapped' object with Bullhorn field keys and coerced or raw values. If enabled, all original columns appear under _raw. The second output contains skipped rows either filtered due to emptiness or errors, including _source with reason or error message and optionally _raw input data. This operation does not modify Bullhorn data but prepares mapped data for downstream use.

Links

Discussion