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": "a860c23a-e43a-44f8-866e-cb51140d8b04",
"db_table_id": "1e80ab92-bef2-4e5a-97bc-da22ecb6a4b8",
"id_in_table": "be31b255-3154-480b-8a3c-505849640a68",
"user_id": "6547bb2b-1f79-4e23-b684-515ed1e519df",
"date_add": "2026-11-12T14:27:14.9462779+00:00",
"dateutc_add": "2026-11-12T14:27:14.9462779+00:00",
"notes": "sample string 7",
"source_db_table_id": "5fba7433-b807-4de4-ad08-311291829e5d",
"source_id_in_table": "c87d580a-b1b2-43c2-94bf-d6ec3a080edd",
"updated_by_user_id": "9ecdafab-8aed-4bb9-830f-68f386f687dc",
"date_update": "2026-11-12T14:27:14.9462779+00:00",
"dateutc_update": "2026-11-12T14:27:14.9462779+00:00",
"modified_dateutc": "2026-11-12T14:27:14.9462779+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:14.946Z</date_add> <date_update>2026-11-12T14:27:14.946Z</date_update> <dateutc_add>2026-11-12T14:27:14.946Z</dateutc_add> <dateutc_update>2026-11-12T14:27:14.946Z</dateutc_update> <db_table_id>1e80ab92-bef2-4e5a-97bc-da22ecb6a4b8</db_table_id> <id>a860c23a-e43a-44f8-866e-cb51140d8b04</id> <id_in_table>be31b255-3154-480b-8a3c-505849640a68</id_in_table> <modified_dateutc>2026-11-12T14:27:14.946Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>5fba7433-b807-4de4-ad08-311291829e5d</source_db_table_id> <source_id_in_table>c87d580a-b1b2-43c2-94bf-d6ec3a080edd</source_id_in_table> <updated_by_user_id>9ecdafab-8aed-4bb9-830f-68f386f687dc</updated_by_user_id> <user_id>6547bb2b-1f79-4e23-b684-515ed1e519df</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": "d9be7dfe-fc34-4e43-a0d1-b832b77eaa85",
"db_table_id": "c2d62be8-dfa0-4afb-8d09-632074ec8385",
"id_in_table": "615ade45-a7cf-48cb-b2c6-82f8e9dfa333",
"user_id": "61f51020-66c8-4976-a80f-5e917028441c",
"date_add": "2026-11-12T14:27:14.9462779+00:00",
"dateutc_add": "2026-11-12T14:27:14.9462779+00:00",
"notes": "sample string 7",
"source_db_table_id": "385bc7eb-663c-4f4f-9fe9-f151c275ee71",
"source_id_in_table": "43ea3ee2-1752-4a07-bb86-ab4b730dd409",
"updated_by_user_id": "75edf5d2-73b9-4ab2-b8db-fe95180990b2",
"date_update": "2026-11-12T14:27:14.9462779+00:00",
"dateutc_update": "2026-11-12T14:27:14.9462779+00:00",
"modified_dateutc": "2026-11-12T14:27:14.9462779+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:14.946Z</date_add> <date_update>2026-11-12T14:27:14.946Z</date_update> <dateutc_add>2026-11-12T14:27:14.946Z</dateutc_add> <dateutc_update>2026-11-12T14:27:14.946Z</dateutc_update> <db_table_id>c2d62be8-dfa0-4afb-8d09-632074ec8385</db_table_id> <id>d9be7dfe-fc34-4e43-a0d1-b832b77eaa85</id> <id_in_table>615ade45-a7cf-48cb-b2c6-82f8e9dfa333</id_in_table> <modified_dateutc>2026-11-12T14:27:14.946Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>385bc7eb-663c-4f4f-9fe9-f151c275ee71</source_db_table_id> <source_id_in_table>43ea3ee2-1752-4a07-bb86-ab4b730dd409</source_id_in_table> <updated_by_user_id>75edf5d2-73b9-4ab2-b8db-fe95180990b2</updated_by_user_id> <user_id>61f51020-66c8-4976-a80f-5e917028441c</user_id> </db_notes>