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
Body Params
file
required

CSV file to validate

Responses

400

The request was malformed or contained invalid parameters.

401

You are not authorized

500

An unexpected error was encountered.

Language
Credentials
Header
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json