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": "67435550-7ada-4ac2-bffe-f60ea1551f15",
"db_table_id": "c65ac162-2cb6-44b9-be6e-e7e16b55290e",
"id_in_table": "82b8fd77-89d7-46d8-814b-e5505ad4ca45",
"user_id": "259f9578-c9db-473b-92a2-1d417bc6eb03",
"date_add": "2026-06-16T21:16:36.2617384+00:00",
"dateutc_add": "2026-06-16T21:16:36.2617384+00:00",
"notes": "sample string 7",
"source_db_table_id": "f3215b93-3e31-4404-b362-a326eb2b640a",
"source_id_in_table": "9c44557c-494f-44fa-919c-878cf231002c",
"updated_by_user_id": "99aef420-bd0e-4ea2-9e2e-f12ac7d4d53f",
"date_update": "2026-06-16T21:16:36.2617384+00:00",
"dateutc_update": "2026-06-16T21:16:36.2617384+00:00",
"modified_dateutc": "2026-06-16T21:16:36.2617384+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T21:16:36.261Z</date_add> <date_update>2026-06-16T21:16:36.261Z</date_update> <dateutc_add>2026-06-16T21:16:36.261Z</dateutc_add> <dateutc_update>2026-06-16T21:16:36.261Z</dateutc_update> <db_table_id>c65ac162-2cb6-44b9-be6e-e7e16b55290e</db_table_id> <id>67435550-7ada-4ac2-bffe-f60ea1551f15</id> <id_in_table>82b8fd77-89d7-46d8-814b-e5505ad4ca45</id_in_table> <modified_dateutc>2026-06-16T21:16:36.261Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>f3215b93-3e31-4404-b362-a326eb2b640a</source_db_table_id> <source_id_in_table>9c44557c-494f-44fa-919c-878cf231002c</source_id_in_table> <updated_by_user_id>99aef420-bd0e-4ea2-9e2e-f12ac7d4d53f</updated_by_user_id> <user_id>259f9578-c9db-473b-92a2-1d417bc6eb03</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": "9d518917-eaf8-4c3b-970d-ee08debb6944",
"db_table_id": "8d92fcd9-4c8c-41ec-8de1-d2b7f21a862d",
"id_in_table": "b11480fc-3b60-4674-b784-318c3e5d7a99",
"user_id": "47a24e45-b8e6-4b9b-9610-61bd5ee8dbc4",
"date_add": "2026-06-16T21:16:36.5554889+00:00",
"dateutc_add": "2026-06-16T21:16:36.5554889+00:00",
"notes": "sample string 7",
"source_db_table_id": "1024fb64-0e0d-4382-9ed0-ef72592defc3",
"source_id_in_table": "0f92ad11-e05f-442e-bf92-adaa551c93b9",
"updated_by_user_id": "2f8d9370-1504-4b66-9e4f-807086df29ed",
"date_update": "2026-06-16T21:16:36.5554889+00:00",
"dateutc_update": "2026-06-16T21:16:36.5554889+00:00",
"modified_dateutc": "2026-06-16T21:16:36.5554889+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T21:16:36.555Z</date_add> <date_update>2026-06-16T21:16:36.555Z</date_update> <dateutc_add>2026-06-16T21:16:36.555Z</dateutc_add> <dateutc_update>2026-06-16T21:16:36.555Z</dateutc_update> <db_table_id>8d92fcd9-4c8c-41ec-8de1-d2b7f21a862d</db_table_id> <id>9d518917-eaf8-4c3b-970d-ee08debb6944</id> <id_in_table>b11480fc-3b60-4674-b784-318c3e5d7a99</id_in_table> <modified_dateutc>2026-06-16T21:16:36.555Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>1024fb64-0e0d-4382-9ed0-ef72592defc3</source_db_table_id> <source_id_in_table>0f92ad11-e05f-442e-bf92-adaa551c93b9</source_id_in_table> <updated_by_user_id>2f8d9370-1504-4b66-9e4f-807086df29ed</updated_by_user_id> <user_id>47a24e45-b8e6-4b9b-9610-61bd5ee8dbc4</user_id> </db_notes>