Skip to content
Proud to collaborate with Microsoft for Startups

dgi.action.query-database ​

Execute a database query (requires organization_uuid)

Execute a database query

Overview ​

PropertyValue
Workflow typeLinear
LibraryApp-dgi
Version1.0

Input Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidYes—Organization UUID
querystringYes—SQL query or query description
parametersjsonNo—Query parameters

Output Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidNo——
querystringNo——
parametersjsonNo——
resultjsonNo——
failure_reasonstringNo——
failure_typestringNo——
failed_actionstringNo——
failed_at_statestringNo——
failed_stepstringNo——
failed_layerstringNo——
errorstringNo——
error_typestringNo——

States ​

StateInitialTerminalSuccessAuto-advanceDescription
pendingYesNo—execute—
executingNoNo—complete—
completedNoYesYes——
failedNoYesNo——

Transitions ​

FromActionToDescription
pendingexecuteexecuting—
executingcompletecompleted—
* (any state)failfailed—

API Usage ​

bash
POST /api/v1/workflows/dgi.action.query-database/start
Content-Type: application/json

{ ... input fields ... }