Request Information
URI Parameters :
None.
Body Parameters :
db_notes| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| db_table_id |
Table Id db notes linked to |
globally unique identifier |
Optionally required : db_table_id or db_table_name must be provided |
| id_in_table |
Item id on the given table on which db note linked to |
globally unique identifier |
Required |
| user_id |
Created User ID |
globally unique identifier |
Optionally required : user_id, user_code or user must be provided |
| date_add |
Date Added. Auto-filled by NOW if empty |
date | |
| dateutc_add |
Date UTC Added |
date | |
| notes |
Notes |
string |
Required |
| source_db_table_id | globally unique identifier | ||
| source_id_in_table | globally unique identifier | ||
| updated_by_user_id | globally unique identifier | ||
| date_update | date | ||
| dateutc_update | date | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Request Formats :
application/json, text/json
Sample:
{
"id": "139db498-9478-4b40-bb0c-d56807aeeef2",
"db_table_id": "f5732387-8075-4587-99c3-abc155fb4f42",
"id_in_table": "7551373b-ae23-49cc-9b8b-a29ec2c94c26",
"user_id": "b3e57580-d5e4-47fa-843d-c1159c0c9527",
"date_add": "2026-01-11T20:58:18.0918394+00:00",
"dateutc_add": "2026-01-11T20:58:18.0918394+00:00",
"notes": "sample string 7",
"source_db_table_id": "473271d7-4c7b-4c2a-b0d5-d2e846280748",
"source_id_in_table": "974a5d7c-8e40-4706-9b0e-3f8777698e76",
"updated_by_user_id": "647cb759-8278-4a92-b371-96a449892d70",
"date_update": "2026-01-11T20:58:18.0918394+00:00",
"dateutc_update": "2026-01-11T20:58:18.0918394+00:00",
"modified_dateutc": "2026-01-11T20:58:18.0918394+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-01-11T20:58:18.091Z</date_add> <date_update>2026-01-11T20:58:18.091Z</date_update> <dateutc_add>2026-01-11T20:58:18.091Z</dateutc_add> <dateutc_update>2026-01-11T20:58:18.091Z</dateutc_update> <db_table_id>f5732387-8075-4587-99c3-abc155fb4f42</db_table_id> <id>139db498-9478-4b40-bb0c-d56807aeeef2</id> <id_in_table>7551373b-ae23-49cc-9b8b-a29ec2c94c26</id_in_table> <modified_dateutc>2026-01-11T20:58:18.091Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>473271d7-4c7b-4c2a-b0d5-d2e846280748</source_db_table_id> <source_id_in_table>974a5d7c-8e40-4706-9b0e-3f8777698e76</source_id_in_table> <updated_by_user_id>647cb759-8278-4a92-b371-96a449892d70</updated_by_user_id> <user_id>b3e57580-d5e4-47fa-843d-c1159c0c9527</user_id> </db_notes>
Response Information
Resource Description :
db_notes| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| db_table_id |
Table Id db notes linked to |
globally unique identifier |
Optionally required : db_table_id or db_table_name must be provided |
| id_in_table |
Item id on the given table on which db note linked to |
globally unique identifier |
Required |
| user_id |
Created User ID |
globally unique identifier |
Optionally required : user_id, user_code or user must be provided |
| date_add |
Date Added. Auto-filled by NOW if empty |
date | |
| dateutc_add |
Date UTC Added |
date | |
| notes |
Notes |
string |
Required |
| source_db_table_id | globally unique identifier | ||
| source_id_in_table | globally unique identifier | ||
| updated_by_user_id | globally unique identifier | ||
| date_update | date | ||
| dateutc_update | date | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
Sample:
{
"id": "82e96732-8b54-40ce-ab91-db765ef8b75d",
"db_table_id": "fb8242fe-d787-4f1d-9144-2ea82acc3001",
"id_in_table": "2eeb3618-52fe-46ae-b1a5-901e026fd420",
"user_id": "1a675f4b-8bcb-435d-87af-26a23424d6db",
"date_add": "2026-01-11T20:58:18.0918394+00:00",
"dateutc_add": "2026-01-11T20:58:18.0918394+00:00",
"notes": "sample string 7",
"source_db_table_id": "fb0991e9-0e2f-44d5-916a-adb147c9fd65",
"source_id_in_table": "f00caafa-4126-4864-af02-d72426341e8a",
"updated_by_user_id": "ad1a2e5e-97f4-41cc-835f-97db2b22023f",
"date_update": "2026-01-11T20:58:18.0918394+00:00",
"dateutc_update": "2026-01-11T20:58:18.0918394+00:00",
"modified_dateutc": "2026-01-11T20:58:18.0918394+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-01-11T20:58:18.091Z</date_add> <date_update>2026-01-11T20:58:18.091Z</date_update> <dateutc_add>2026-01-11T20:58:18.091Z</dateutc_add> <dateutc_update>2026-01-11T20:58:18.091Z</dateutc_update> <db_table_id>fb8242fe-d787-4f1d-9144-2ea82acc3001</db_table_id> <id>82e96732-8b54-40ce-ab91-db765ef8b75d</id> <id_in_table>2eeb3618-52fe-46ae-b1a5-901e026fd420</id_in_table> <modified_dateutc>2026-01-11T20:58:18.091Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>fb0991e9-0e2f-44d5-916a-adb147c9fd65</source_db_table_id> <source_id_in_table>f00caafa-4126-4864-af02-d72426341e8a</source_id_in_table> <updated_by_user_id>ad1a2e5e-97f4-41cc-835f-97db2b22023f</updated_by_user_id> <user_id>1a675f4b-8bcb-435d-87af-26a23424d6db</user_id> </db_notes>