Appearance
appdata.query.history ​
List statements offered to the app's SQL endpoint, admitted or refused
Statements this app has run, newest first, from the SQL audit log.
Overview ​
| Property | Value |
|---|---|
| Workflow type | Atomic |
| Library | App-appdata |
| Version | 1.0 |
Input Schema ​
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
organization_uuid | uuid | Yes | — | — |
identity_app_uuid | uuid | Yes | — | — |
actor_user_uuid | uuid | No | — | Platform user this query belongs to; authorship and private visibility key off it |
mine_only | boolean | No | — | Only statements this user ran (default true when actor_user_uuid is given) |
admitted_only | boolean | No | — | — |
search | string | No | — | Substring of the statement |
since | string | No | — | ISO-8601; only statements offered at or after this moment |
until | string | No | — | ISO-8601; only statements offered before this moment |
limit | integer | No | — | — |
offset | integer | No | — | — |
Output Schema ​
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
organization_uuid | uuid | Yes | — | — |
identity_app_uuid | uuid | Yes | — | — |
entries | list | No | — | — |
entry_count | integer | No | — | — |
total | integer | No | — | — |
limit | integer | No | — | — |
offset | integer | No | — | — |
since | string | No | — | — |
until | string | No | — | — |
error | string | No | — | Error message when the read failed |
error_type | string | No | — | Error class name when the read failed |
States ​
| State | Initial | Terminal | Success | Auto-advance | Description |
|---|---|---|---|---|---|
done | Yes | Yes | Yes | — | — |
Outcomes ​
| Outcome | Type | Description | State Data Keys |
|---|---|---|---|
listed | SUCCESS | List statements offered to the app's SQL endpoint, admitted or refused | entry_count, total |
failed | FAILURE | Appdata workflow failed | failure_reason |
API Usage ​
bash
POST /api/workflows/start
Content-Type: application/json
{
"workflow_type": "appdata.query.history",
"initial_data": {
"organization_uuid": "value",
"identity_app_uuid": "value"
}
}