# Dromo

Dromo is an intuitive spreadsheet importer that integrates seamlessly with your product, enabling users to match columns, correct errors, perform complex validations, transform values, and upload perfectly formatted data.

- **Category:** spreadsheets
- **Auth:** API_KEY
- **Composio Managed App Available?** N/A
- **Tools:** 8
- **Triggers:** 0
- **Slug:** `DROMO`
- **Version:** 20260217_00

## Tools

### Create Headless Import

**Slug:** `DROMO_CREATE_HEADLESS_IMPORT`

Tool to create a headless import in Dromo. Returns a signed upload URL for file uploads. Use this before uploading files to obtain the temporary upload URL.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `schema_id` | string | Yes | UUID of the saved schema defining data structure and validation rules |
| `initial_data` | string | No | JSON string containing array of objects to import directly instead of uploading a file |
| `original_filename` | string | No | Name of the file being imported (e.g., 'data.csv'). Required for file imports. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Create Import Schema

**Slug:** `DROMO_CREATE_IMPORT_SCHEMA`

Tool to create a new import schema in Dromo. Define fields, validation rules, and settings for data imports. Use this when setting up a new data import workflow or template.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `name` | string | Yes | Name of the import schema for identification and display |
| `hooks` | object | No | Webhook configuration for various import events. |
| `fields` | array | Yes | Array of field definitions that define the structure and validation for imported data. Must contain at least one field. |
| `settings` | object | Yes | Configuration settings for the import schema behavior and appearance |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Import Schema

**Slug:** `DROMO_DELETE_IMPORT_SCHEMA`

Tool to delete an import schema in Dromo. Use when you need to remove a schema definition that is no longer needed. This action is irreversible.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | UUID of the import schema to delete |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Import Schema

**Slug:** `DROMO_GET_IMPORT_SCHEMA`

Tool to retrieve an import schema by ID from Dromo. Returns the complete schema definition including fields, validation rules, settings, and webhook configurations. Use this to inspect schema structure, validate field requirements, or retrieve configuration details before creating imports.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | Unique identifier of the import schema to retrieve |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Import Schemas

**Slug:** `DROMO_LIST_IMPORT_SCHEMAS`

Tool to retrieve all import schemas configured for your Dromo organization. Use this to discover available schemas, their field definitions, validation rules, and settings before creating imports.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### List Uploads

**Slug:** `DROMO_LIST_UPLOADS`

Retrieves a paginated list of all file uploads stored by Dromo for your organization. Returns upload metadata including status, row counts, errors, user information, and file details. Use this to monitor import progress, track upload history, or retrieve upload IDs for further processing.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `end` | integer | No | Ending index for pagination (exclusive). Must be greater than start. Defaults to 10000. Maximum value is 10000. |
| `start` | integer | No | Starting index for pagination (inclusive). Defaults to 0. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Import Schema

**Slug:** `DROMO_UPDATE_IMPORT_SCHEMA`

Tool to update an existing import schema in Dromo. Modifies the schema definition including fields, validation rules, and settings. Use when you need to change field configurations, add/remove validators, or update import settings for an existing schema.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | UUID of the import schema to update |
| `name` | string | Yes | Display name for the import schema |
| `hooks` | object | No | Webhook configuration for various import events. |
| `fields` | array | Yes | List of field configurations defining the schema structure |
| `settings` | object | Yes | Configuration settings for the import schema |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Upload File To Headless Import

**Slug:** `DROMO_UPLOAD_FILE_TO_HEADLESS_IMPORT`

Upload a file to Dromo's headless import system using a presigned S3 URL. This action performs the actual file upload step in Dromo's headless import workflow: 1. First, create a headless import via POST to /headless/imports/ to get an upload URL 2. Then, use this action to upload the file to that URL 3. Dromo automatically processes the file once the upload completes The upload URL is valid for 30 minutes. This action performs an HTTP PUT request with the file content to the provided presigned S3 URL.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `file` | string | Yes | Raw file content as bytes. For CSV files, encode the CSV text as UTF-8 bytes. For binary files, provide the raw binary data. |
| `upload_url` | string | Yes | Presigned S3 URL obtained from creating a headless import. This URL is valid for 30 minutes and grants temporary permission to upload the file via HTTP PUT. Obtain this URL by creating a headless import with the Dromo API. |
| `content_type` | string | Yes | MIME type of the file being uploaded. Common values: 'text/csv' for CSV files, 'application/vnd.ms-excel' for Excel files, 'text/plain' for text files. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |