/
[GET] /tables

[GET] /tables

/api/bpm/db/tables

Description

An endpoint for retrieving information about the database tables to take prompt actions on workflows.

Required Systemrole

R_WFADM_START (ID = 20)

Request
Method

GET

Request Optional Query Parameter

  • locked(Boolean): If the parameter is true, then overview of all locks in database tables are returned.

Response
Format

JSON

Minimum Version

1.2.0

Request
Example

/api/bpm/db/tables?locked=true

/api/bpm/db/tables?locked=false

Result
Example when locked=true

{ "objects": [{ "id": "6BFA52A12BF24BCEA30C49194336CB6A", "name": "oswfactivities", "status": "unlocked" },{ "id": "7615794F24D2450F94A2DA560CE545CA", "name": "oswftimers", "status": "locked", "server": "WF-System1", "threadId": "1235", "lockTime": "2025-10-10T15:03:47+02:00" }], "numItems": 2, "hasMoreItems": false, "totalNumItems": 2 }

Result
Example when locked=false

Not implemented yet!