Add/update db_notes
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": "9341d5c3-e008-4446-932b-3497c2a8d170",
"db_table_id": "53371d4e-d899-4de8-aa6b-a148b3ba6522",
"id_in_table": "6de44032-d1f5-441d-b2a5-783c0dbe1a8f",
"user_id": "0a73741b-e89d-4f40-8afa-fa4f8fd57c7b",
"date_add": "2026-03-07T13:13:08.2888445+00:00",
"dateutc_add": "2026-03-07T13:13:08.2888445+00:00",
"notes": "sample string 7",
"source_db_table_id": "8606d29d-c77a-429b-bc42-35433d4ba6e1",
"source_id_in_table": "b5d82d25-19f3-4240-bfd4-ebb318af5069",
"updated_by_user_id": "7bde1add-cabf-4775-a7e9-82d07d30d9de",
"date_update": "2026-03-07T13:13:08.2888445+00:00",
"dateutc_update": "2026-03-07T13:13:08.2888445+00:00",
"modified_dateutc": "2026-03-07T13:13:08.2888445+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-03-07T13:13:08.288Z</date_add> <date_update>2026-03-07T13:13:08.288Z</date_update> <dateutc_add>2026-03-07T13:13:08.288Z</dateutc_add> <dateutc_update>2026-03-07T13:13:08.288Z</dateutc_update> <db_table_id>53371d4e-d899-4de8-aa6b-a148b3ba6522</db_table_id> <id>9341d5c3-e008-4446-932b-3497c2a8d170</id> <id_in_table>6de44032-d1f5-441d-b2a5-783c0dbe1a8f</id_in_table> <modified_dateutc>2026-03-07T13:13:08.288Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>8606d29d-c77a-429b-bc42-35433d4ba6e1</source_db_table_id> <source_id_in_table>b5d82d25-19f3-4240-bfd4-ebb318af5069</source_id_in_table> <updated_by_user_id>7bde1add-cabf-4775-a7e9-82d07d30d9de</updated_by_user_id> <user_id>0a73741b-e89d-4f40-8afa-fa4f8fd57c7b</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": "9dbc1a63-7521-4c31-9b30-9abe34d5e016",
"db_table_id": "ef1809f6-ee71-413e-ba50-66ebdda86abc",
"id_in_table": "985e3d58-d7a8-485e-9bd8-c9f2d502ba3a",
"user_id": "48a100d9-4215-4e71-8572-1bd264ae1abd",
"date_add": "2026-03-07T13:13:08.3008451+00:00",
"dateutc_add": "2026-03-07T13:13:08.3008451+00:00",
"notes": "sample string 7",
"source_db_table_id": "cba10b4d-0551-4728-899b-9abf4dee4abc",
"source_id_in_table": "fcd31eb8-2959-4a55-a5e4-bbb675fd9a04",
"updated_by_user_id": "20e20dcd-7579-40b6-ada5-dba1d7566637",
"date_update": "2026-03-07T13:13:08.3008451+00:00",
"dateutc_update": "2026-03-07T13:13:08.3008451+00:00",
"modified_dateutc": "2026-03-07T13:13:08.3008451+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-03-07T13:13:08.300Z</date_add> <date_update>2026-03-07T13:13:08.300Z</date_update> <dateutc_add>2026-03-07T13:13:08.300Z</dateutc_add> <dateutc_update>2026-03-07T13:13:08.300Z</dateutc_update> <db_table_id>ef1809f6-ee71-413e-ba50-66ebdda86abc</db_table_id> <id>9dbc1a63-7521-4c31-9b30-9abe34d5e016</id> <id_in_table>985e3d58-d7a8-485e-9bd8-c9f2d502ba3a</id_in_table> <modified_dateutc>2026-03-07T13:13:08.300Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>cba10b4d-0551-4728-899b-9abf4dee4abc</source_db_table_id> <source_id_in_table>fcd31eb8-2959-4a55-a5e4-bbb675fd9a04</source_id_in_table> <updated_by_user_id>20e20dcd-7579-40b6-ada5-dba1d7566637</updated_by_user_id> <user_id>48a100d9-4215-4e71-8572-1bd264ae1abd</user_id> </db_notes>