Database

Get Table Entries

GET /api/db/table/{tableName}/get

Query:

http://localhost:7766/api/db/table/test/get?limit=10&offset=0&columns=id,col1

{
    "data": [
        {
            "id": "2024|;|A",
            "col1": "5"
        },
        {
            "id": "2022|;|A",
            "col1": "4"
        }
    ],
    "count": 2,
    "offset": 0,
    "limit": 10,
    "total": 2
}

Search Table Entries

POST /api/db/table/{tableName}/search

Keywords: “EQUALS”, “NOTEQUALS” , “IN” , “GT” , “GTE” , “LT” , “LTE” , “NOTIN” , “LIKE” , “NOTLIKE” , “ILIKE” , “NOTILIKE” , “ISNULL”
Special Value: ”$#(TODAY)”

Body

Examples:

{
   "filter": {
       "id": "A"
   }
}

{
   "filter": {
       "id": {
           "IN":["A","B"]
       }
   }
}

{
"filter": {
    "AND": {
        "col1":"some condition",
        "id": {
            "IN": ["A","B"]
        }
    }
}
}

{
    "data": [
        {
            "db_id": 1,
            "id": "A",
            "col1": "some value"
        }
    ],
    "count": 1,
    "offset": 0,
    "limit": 10000,
    "total": 1
}

Insert Table Entry

POST /api/db/table/{tableName}/insert

Insert a single entry in a table. If no id is provided, the next db_id will be used.

Body

{
   "id":"123",
   "col1": "test"
}

{
    "id":"123",
    "col1": "test"
}

Update Table Entry

POST /api/db/table/{tableName}/update

Update a single entry in a table.

Body:

{
   "id":"123",
   "col1": "test",
   "col2": "test2"
}

status:200

Upsert Table Entry

POST /api/db/table/{tableName}/upsert

Updates or inserts (if id does not exist) a single entry in a table.

Body:

{
   "id":"123",
   "col1": "test",
   "col2": "test2"
}

status:200

Add entry in comment history

POST /api/db/table/{tableName}/commentHistoryEntry

Adds a comment history entry for an existing field. If the current content is not the expected format, it will be replaced with the posted single entry comment history.

Body

{
   "id":"A",
   "column": "col1",
   "text": "Some text for the entry",
   "user": "User 1"
}

status:200

Bulk Insert

POST /api/db/table/{tableName}/bulk/insert

Inserts multiple entries in a table. If no id is provided, the next db_id will be used.

Body [Array]:

Maximum Array Length: 10000

[
   {
   "id":"123",
   "col1": "test"
   },{
   "col1": "test2"
   }
]

[
    {
    "id":"123",
    "col1": "test"
    },{
    "id":"2",
    "col1": "test2"
    }
]

Bulk Update

POST /api/db/table/{tableName}/bulk/update

Updates multiple entries in a table.

Body [Array]:

Maximum Array Length: 10000

[
   {
   "id":"123",
   "col1": "test"
   },{
   "id":"2",
   "col1": "test2"
   }
]

status:200

Bulk Upsert

POST /api/db/table/{tableName}/bulk/upsert

Updates or inserts (if id does not exist) multiple entries in a table.

Body [Array]:

Maximum Array Length: 10000

[
   {
   "id":"123",
   "col1": "test"
   },{
   "id":"2",
   "col1": "test2"
   }
]

status:200

Delete Table Entry

POST /api/db/table/{tableName}/delete

Deletes entries in a table.
All entries can be deleted with ['*'], which will reset the db_id.

Body:

Maximum Array Length: 10000

{
   "ids": ["1","2"]
}

{
   "ids": ["*"]
}

status:200