importFromDatabase

Load data from your app’s database into a workflow table for processing:

{
  importFromDatabase: {
    appId: "{{var.appId}}",
    tableName: "Connection",
    whereColumn: "status",
    whereValue: "active",
  },
  outputTable: "active_connections",
  outputSchema: {
    id: "VARCHAR",
    userId: "VARCHAR",
    service: "VARCHAR",
  },
}

Field	Required	Description
`appId`	Yes	App identifier (typically `"{{var.appId}}"`)
`tableName`	Yes	Source table name
`outputTable`	Yes	Name of the table this step produces
`outputSchema`	Yes	Column names and types for the result output table
`whereColumn`	No	Column to filter by
`whereValue`	No	Value to match — required if `whereColumn` is set

Import steps support fieldMapping to rename columns and generate values like IDs and timestamps.

Validation

Check
`appId`, `tableName`, `outputTable`, `outputSchema` are required
`whereColumn` and `whereValue` must both be set if either is provided
`tableName` exists in the app database
`whereColumn` exists in source table
`outputSchema` columns exist in source table (skipped when fieldMapping is provided)

Defining workflows

serviceCall

⌘I

Platform Docs

Synthetiq Desktop

Synthetiq CLI

App Framework

Services Framework

Workflows Framework

Platform API

Deployments

importFromDatabase

Validation

​Validation

Validation