Depot Connector

🔌 Depot Connector

The Depot enables runbooks to store, update, and lookup reference data or configuration settings shared across different automation workflows.

⚡ Triggers

Field Update

• Starts a runbook when a specific field value in a Depot table is updated.
• Receives webhook notifications when changes occur on a configured table.

⚡ Actions

Add Rows

• Adds one or more rows (up to 1,000) to a specified Depot table.
• Used for bulk data insertion or populating tables from external sources.

Lookup

• Searches a specific column for a value and returns matching data from that row.
• Returns the first matching row's column data.

📥 Input Parameters

• Table name (String, Required): The name of the table to interact with (max 256 characters).
• Columns (Array, Required): List of up to 10 column definitions.
• rows (Array[Object], Required for Add Rows): Array of row objects to add.
• lookup_column_name (String, Required for Lookup): The column to search in.

📤 Output

• row_id (String): The identifier of the row that was updated or created.
• new_value (String): The updated value after a field change.
• columns (Array[Object]): Array of name/value pairs from a matching row during a lookup.

📌 Use Cases

• Reference Data: Maintaining tables for impact levels or priority mappings.
• Data Enrichment: Cross-referencing lookup tables during runbook execution to enrich integration data.
• Workflow Triggers: Reacting to data changes in the Depot to trigger downstream notifications or automation.

⚠️ Notes

• Limits: Each table is limited to a maximum of 10 columns.
• Seed Rows: Tables can be pre-populated with up to 10,000 initial rows.
• Dynamic Populated: Column names are automatically populated from the outbound connection's table definition.

‍