Update all import mappings in bulk

Replaces all field mappings for an import in a single request. This is the primary way to configure how CSV columns map to entity fields.

What this does:

• Deletes all existing mappings for the import
• Creates new mappings from your request
• Automatically adds dependency mappings (e.g., if you map OrganizationMember, it will also create Organization mapping if needed)
• Validates that all column IDs exist in the import
• Triggers re-validation of all mappings
• Returns the updated mappings in AI format

AI Mapping Format: Each mapping specifies an entity type and its field mappings:

{
  "mappings": [
    {
      "type": "Employee",
      "fields": {
        "firstName": { "mapTo": "column-uuid-here" },
        "lastName": { "mapTo": "column-uuid-here" },
        "email": { "mapTo": "column-uuid-here" },
        "role": {
          "mapTo": "column-uuid-here",
          "valueMappings": { "Manager": "manager", "Developer": "developer" }
        }
      },
      "customLookupFields": ["email"]  // optional: fields to use for finding existing records
    }
  ]
}

Field Mapping Properties:

• mapTo: Required - The UUID of the CSV column (get column IDs from GET /{importId})
• defaultValue: Optional - Default value if CSV cell is empty
• valueMappings: Optional - Map CSV values to entity values (e.g., “Yes” → true, “Manager” → “manager”)

Custom Lookup Fields: Specify which fields should be used to find existing records for updates. If a record matches on these fields, it will be updated; otherwise, a new record will be created.

• Can include both built-in fields (e.g., “email”, “firstName”) and custom fields (e.g., “customField_abc123”)
• If not specified, uses the entity’s default requiredToUpdate fields
• Example: Use “email” for Employees, or a custom “externalId” field for Projects

Important Notes:

• mapTo must be a column UUID from the import (get from GET /{importId} response), not a column name
• All column IDs must exist in the import
• Dependencies are automatically created (e.g., Organization for OrganizationMember, Project for Task)
• Custom fields are referenced as customField_{fieldId} in field names
• After updating, run a dry-run to validate mappings before execution

curl -X PUT "https://leadtime.app/api/public/imports-management/d2ee76e3-95d7-4b98-8d5d-98dc1fb79364/mappings" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
  "mappings": [
    {
      "customLookupFields": [
        "email"
      ],
      "fields": {
        "email": {
          "mapTo": "b4gg98g5-17f9-6d10-0f7f-10fe3hd91586"
        },
        "firstName": {
          "mapTo": "d2ee76e3-95d7-4b98-8d5d-98dc1fb79364"
        },
        "lastName": {
          "mapTo": "a3ff87f4-06e8-5c09-9e6e-09ed2gc80475"
        }
      },
      "type": "Employee"
    }
  ]
}'

const response = await fetch("https://leadtime.app/api/public/imports-management/d2ee76e3-95d7-4b98-8d5d-98dc1fb79364/mappings", {
  method: "PUT",
  headers: {
    "Authorization": "Bearer YOUR_ACCESS_TOKEN",
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
  "mappings": [
    {
      "customLookupFields": [
        "email"
      ],
      "fields": {
        "email": {
          "mapTo": "b4gg98g5-17f9-6d10-0f7f-10fe3hd91586"
        },
        "firstName": {
          "mapTo": "d2ee76e3-95d7-4b98-8d5d-98dc1fb79364"
        },
        "lastName": {
          "mapTo": "a3ff87f4-06e8-5c09-9e6e-09ed2gc80475"
        }
      },
      "type": "Employee"
    }
  ]
})
});

import requests

response = requests.put(
    "https://leadtime.app/api/public/imports-management/d2ee76e3-95d7-4b98-8d5d-98dc1fb79364/mappings",
    headers={
        "Authorization": "Bearer YOUR_ACCESS_TOKEN",
        "Content-Type": "application/json"
    },
    json={
  "mappings": [
    {
      "customLookupFields": [
        "email"
      ],
      "fields": {
        "email": {
          "mapTo": "b4gg98g5-17f9-6d10-0f7f-10fe3hd91586"
        },
        "firstName": {
          "mapTo": "d2ee76e3-95d7-4b98-8d5d-98dc1fb79364"
        },
        "lastName": {
          "mapTo": "a3ff87f4-06e8-5c09-9e6e-09ed2gc80475"
        }
      },
      "type": "Employee"
    }
  ]
},
)

{
  "mappings": [
    null
  ],
  "success": true
}