> ## Documentation Index
> Fetch the complete documentation index at: https://docs.azalt.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Import sites from CSV

> Import multiple sites from a CSV file with validation and error reporting.

**Import Features**:
- Bulk site creation from structured CSV data
- Hierarchical relationship establishment
- Custom metadata import for external system integration
- Validation and error reporting for each row
- Rollback capabilities for failed imports

**CSV Format Support**:
- Standard site information (name, description, location)
- Parent-child hierarchy definitions
- Geographic coordinates and location metadata
- Custom metadata columns for external identifiers
- Flexible column mapping for different data sources

**Validation and Error Handling**:
- Schema validation for each site record
- Duplicate detection and handling
- Hierarchical consistency checks
- Detailed error reporting with row numbers
- Partial import support with error skipping

**Use Cases**:
- Initial organizational setup and migration
- Bulk organizational restructuring
- Integration with external systems and databases
- Automated site provisioning workflows

**Import Results**:
- Summary of successful and failed imports
- Detailed error messages for troubleshooting
- Created site IDs for further reference
- Validation warnings and recommendations

Requires site manager permissions due to the significant organizational impact of bulk site creation and hierarchy changes.



## OpenAPI

````yaml https://app.azalt.co/api/v1/openapi.json post /sites/import
openapi: 3.0.3
info:
  title: Erguvan Public API
  version: 1.0.0
servers:
  - url: https://app.azalt.co/api/v1
security: []
paths:
  /sites/import:
    post:
      tags:
        - Site
      summary: Import sites from CSV
      description: >-
        Import multiple sites from a CSV file with validation and error
        reporting.


        **Import Features**:

        - Bulk site creation from structured CSV data

        - Hierarchical relationship establishment

        - Custom metadata import for external system integration

        - Validation and error reporting for each row

        - Rollback capabilities for failed imports


        **CSV Format Support**:

        - Standard site information (name, description, location)

        - Parent-child hierarchy definitions

        - Geographic coordinates and location metadata

        - Custom metadata columns for external identifiers

        - Flexible column mapping for different data sources


        **Validation and Error Handling**:

        - Schema validation for each site record

        - Duplicate detection and handling

        - Hierarchical consistency checks

        - Detailed error reporting with row numbers

        - Partial import support with error skipping


        **Use Cases**:

        - Initial organizational setup and migration

        - Bulk organizational restructuring

        - Integration with external systems and databases

        - Automated site provisioning workflows


        **Import Results**:

        - Summary of successful and failed imports

        - Detailed error messages for troubleshooting

        - Created site IDs for further reference

        - Validation warnings and recommendations


        Requires site manager permissions due to the significant organizational
        impact of bulk site creation and hierarchy changes.
      operationId: importSites
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                csvContent:
                  type: string
                organizationId:
                  type: string
              required:
                - csvContent
                - organizationId
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
                properties:
                  success:
                    type: number
                  failed:
                    type: number
                  errors:
                    type: array
                    items:
                      type: string
                  logs:
                    type: array
                    items:
                      type: string
                required:
                  - success
                  - failed
                  - errors
                  - logs
        '400':
          description: Invalid input data
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/error.BAD_REQUEST'
        '401':
          description: Authorization not provided
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/error.UNAUTHORIZED'
        '403':
          description: Insufficient access
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/error.FORBIDDEN'
        '500':
          description: Internal server error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/error.INTERNAL_SERVER_ERROR'
      security:
        - Authorization: []
components:
  schemas:
    error.BAD_REQUEST:
      type: object
      properties:
        message:
          type: string
          description: The error message
          example: Invalid input data
        code:
          type: string
          description: The error code
          example: BAD_REQUEST
        issues:
          type: array
          items:
            type: object
            properties:
              message:
                type: string
            required:
              - message
          description: An array of issues that were responsible for the error
          example: []
      required:
        - message
        - code
      title: Invalid input data error (400)
      description: The error information
      example:
        code: BAD_REQUEST
        message: Invalid input data
        issues: []
    error.UNAUTHORIZED:
      type: object
      properties:
        message:
          type: string
          description: The error message
          example: Authorization not provided
        code:
          type: string
          description: The error code
          example: UNAUTHORIZED
        issues:
          type: array
          items:
            type: object
            properties:
              message:
                type: string
            required:
              - message
          description: An array of issues that were responsible for the error
          example: []
      required:
        - message
        - code
      title: Authorization not provided error (401)
      description: The error information
      example:
        code: UNAUTHORIZED
        message: Authorization not provided
        issues: []
    error.FORBIDDEN:
      type: object
      properties:
        message:
          type: string
          description: The error message
          example: Insufficient access
        code:
          type: string
          description: The error code
          example: FORBIDDEN
        issues:
          type: array
          items:
            type: object
            properties:
              message:
                type: string
            required:
              - message
          description: An array of issues that were responsible for the error
          example: []
      required:
        - message
        - code
      title: Insufficient access error (403)
      description: The error information
      example:
        code: FORBIDDEN
        message: Insufficient access
        issues: []
    error.INTERNAL_SERVER_ERROR:
      type: object
      properties:
        message:
          type: string
          description: The error message
          example: Internal server error
        code:
          type: string
          description: The error code
          example: INTERNAL_SERVER_ERROR
        issues:
          type: array
          items:
            type: object
            properties:
              message:
                type: string
            required:
              - message
          description: An array of issues that were responsible for the error
          example: []
      required:
        - message
        - code
      title: Internal server error error (500)
      description: The error information
      example:
        code: INTERNAL_SERVER_ERROR
        message: Internal server error
        issues: []
  securitySchemes:
    Authorization:
      type: http
      scheme: bearer

````