Validate CSV file before bulk upload

Validates a CSV file for device bulk upload without actually creating/updating devices. Use this endpoint to preview validation errors before submitting a bulk upload.

Validation Categories

Structure Errors

• Header row must have exactly 21 columns
• Each data row must have exactly 21 columns
• Header names must match expected column names (case-insensitive)
• Maximum 1000 data rows allowed

Required Field Errors

For Create operations (Delete=false, Update=false):

• Device Name is required
• Device Unique ID is required
• Account ID is required
• Device Type ID is required
• Heartbeat Period is required

For Update/Delete operations:

• Device Unique ID is required
• Account ID is required

Format Errors

• Heartbeat Period: Must be an integer >= 0. Negative values are not allowed.
• Boolean fields (Active, Enforce Secure MQTT, Delete, Update): Must be true, false, or empty.
• Metadata: Each entry must be in format key:value.

Reference Errors

• Account ID must reference a valid, accessible company
• Device Type ID must reference a valid device type

Permission Errors

• User must have access to all companies referenced in the CSV

Warnings (Non-blocking)

• Empty rows are detected and will be skipped during import