Creates or updates a note.
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 |
Identifier of the database table this note originated from, when generated via integration/automation. |
globally unique identifier | |
| source_id_in_table |
Primary key of the source record (in the table identified by ) this note originated from. |
globally unique identifier | |
| updated_by_user_id |
Foreign key of the user who last updated this note. |
globally unique identifier | |
| date_update |
Local date and time this note was last updated. |
date | |
| dateutc_update |
UTC date and time this note was last updated. |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Request Formats :
application/json, text/json
{
"id": "4cc767f2-766e-417a-bfb8-e39b4e91a2e3",
"db_table_id": "add52fed-2a54-43bb-b469-7000bf985e39",
"id_in_table": "eb6d8c7d-1e56-4aab-ae34-2f59c5633e7e",
"user_id": "d52e318b-c77e-4817-9e93-3d1c2ba8b6ee",
"date_add": "2026-09-16T09:22:08.5031975+00:00",
"dateutc_add": "2026-09-16T09:22:08.5031975+00:00",
"notes": "sample string 7",
"source_db_table_id": "afebd680-921a-4b43-be3c-074a3f953f0c",
"source_id_in_table": "d18d890b-1d4d-486a-8922-6df6a7501ec0",
"updated_by_user_id": "a25e0c62-043d-454f-95bb-0f42a85443f4",
"date_update": "2026-09-16T09:22:08.5031975+00:00",
"dateutc_update": "2026-09-16T09:22:08.5031975+00:00",
"modified_dateutc": "2026-09-16T09:22:08.5031975+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-09-16T09:22:08.503Z</date_add> <date_update>2026-09-16T09:22:08.503Z</date_update> <dateutc_add>2026-09-16T09:22:08.503Z</dateutc_add> <dateutc_update>2026-09-16T09:22:08.503Z</dateutc_update> <db_table_id>add52fed-2a54-43bb-b469-7000bf985e39</db_table_id> <id>4cc767f2-766e-417a-bfb8-e39b4e91a2e3</id> <id_in_table>eb6d8c7d-1e56-4aab-ae34-2f59c5633e7e</id_in_table> <modified_dateutc>2026-09-16T09:22:08.503Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>afebd680-921a-4b43-be3c-074a3f953f0c</source_db_table_id> <source_id_in_table>d18d890b-1d4d-486a-8922-6df6a7501ec0</source_id_in_table> <updated_by_user_id>a25e0c62-043d-454f-95bb-0f42a85443f4</updated_by_user_id> <user_id>d52e318b-c77e-4817-9e93-3d1c2ba8b6ee</user_id> </db_notes>
Response Information
Resource Description :
IHttpActionResult containing the saved note.
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 |
Identifier of the database table this note originated from, when generated via integration/automation. |
globally unique identifier | |
| source_id_in_table |
Primary key of the source record (in the table identified by ) this note originated from. |
globally unique identifier | |
| updated_by_user_id |
Foreign key of the user who last updated this note. |
globally unique identifier | |
| date_update |
Local date and time this note was last updated. |
date | |
| dateutc_update |
UTC date and time this note was last updated. |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{
"id": "677bf709-c3d6-48af-969f-c14974620871",
"db_table_id": "86434b05-1583-4a55-b1b3-d90a145ca1d6",
"id_in_table": "bedf2363-65f8-4429-81ba-7456ce399e93",
"user_id": "3a51c347-ea2c-4df2-94a8-81f12f50af9a",
"date_add": "2026-09-16T09:22:08.5031975+00:00",
"dateutc_add": "2026-09-16T09:22:08.5031975+00:00",
"notes": "sample string 7",
"source_db_table_id": "53ca042b-3926-4981-ad7d-a29df75b8982",
"source_id_in_table": "967e6da4-a832-4cbf-96c0-07df6c175743",
"updated_by_user_id": "709e7b09-427b-41b3-8016-062c7a5e2b93",
"date_update": "2026-09-16T09:22:08.5031975+00:00",
"dateutc_update": "2026-09-16T09:22:08.5031975+00:00",
"modified_dateutc": "2026-09-16T09:22:08.5031975+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-09-16T09:22:08.503Z</date_add> <date_update>2026-09-16T09:22:08.503Z</date_update> <dateutc_add>2026-09-16T09:22:08.503Z</dateutc_add> <dateutc_update>2026-09-16T09:22:08.503Z</dateutc_update> <db_table_id>86434b05-1583-4a55-b1b3-d90a145ca1d6</db_table_id> <id>677bf709-c3d6-48af-969f-c14974620871</id> <id_in_table>bedf2363-65f8-4429-81ba-7456ce399e93</id_in_table> <modified_dateutc>2026-09-16T09:22:08.503Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>53ca042b-3926-4981-ad7d-a29df75b8982</source_db_table_id> <source_id_in_table>967e6da4-a832-4cbf-96c0-07df6c175743</source_id_in_table> <updated_by_user_id>709e7b09-427b-41b3-8016-062c7a5e2b93</updated_by_user_id> <user_id>3a51c347-ea2c-4df2-94a8-81f12f50af9a</user_id> </db_notes>