Creates a new 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": "0cd94507-0026-4ef2-9f56-486cf480b55a",
"db_table_id": "81c3eac8-ec8f-4fc4-8d60-52beeaf85ec0",
"id_in_table": "2ce1b979-b0c1-4304-b145-6009af1154a6",
"user_id": "afedca97-96fd-4338-8d78-37a2cab679b4",
"date_add": "2026-09-16T08:33:18.736683+00:00",
"dateutc_add": "2026-09-16T08:33:18.736683+00:00",
"notes": "sample string 7",
"source_db_table_id": "c0c9d0a7-74f4-4ec5-b322-c2aea4787154",
"source_id_in_table": "d55bdb61-5875-41c7-859a-0371837bb3ec",
"updated_by_user_id": "438c4a05-0783-46cf-98e6-f4a8aa30e418",
"date_update": "2026-09-16T08:33:18.736683+00:00",
"dateutc_update": "2026-09-16T08:33:18.736683+00:00",
"modified_dateutc": "2026-09-16T08:33:18.736683+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-09-16T08:33:18.736Z</date_add> <date_update>2026-09-16T08:33:18.736Z</date_update> <dateutc_add>2026-09-16T08:33:18.736Z</dateutc_add> <dateutc_update>2026-09-16T08:33:18.736Z</dateutc_update> <db_table_id>81c3eac8-ec8f-4fc4-8d60-52beeaf85ec0</db_table_id> <id>0cd94507-0026-4ef2-9f56-486cf480b55a</id> <id_in_table>2ce1b979-b0c1-4304-b145-6009af1154a6</id_in_table> <modified_dateutc>2026-09-16T08:33:18.736Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>c0c9d0a7-74f4-4ec5-b322-c2aea4787154</source_db_table_id> <source_id_in_table>d55bdb61-5875-41c7-859a-0371837bb3ec</source_id_in_table> <updated_by_user_id>438c4a05-0783-46cf-98e6-f4a8aa30e418</updated_by_user_id> <user_id>afedca97-96fd-4338-8d78-37a2cab679b4</user_id> </db_notes>
Response Information
Resource Description :
IHttpActionResult containing the created 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": "b9524eb1-4e8b-4cc3-9c91-958a3e62dccc",
"db_table_id": "729fa33f-a8ff-44f3-b469-7bddd82c8518",
"id_in_table": "9ad6990d-b3a8-46a1-bedc-6e366e70bac9",
"user_id": "82a073cf-7e0a-4e15-a9d8-29dadf3bf86f",
"date_add": "2026-09-16T08:33:18.736683+00:00",
"dateutc_add": "2026-09-16T08:33:18.736683+00:00",
"notes": "sample string 7",
"source_db_table_id": "62e9b46d-4a48-425a-8350-cb57baf5bca7",
"source_id_in_table": "9206cf3a-6a4d-4335-b6cc-7e263f4cf370",
"updated_by_user_id": "243b4cec-f61b-4cc7-84be-8ec914f802aa",
"date_update": "2026-09-16T08:33:18.736683+00:00",
"dateutc_update": "2026-09-16T08:33:18.736683+00:00",
"modified_dateutc": "2026-09-16T08:33:18.736683+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-09-16T08:33:18.736Z</date_add> <date_update>2026-09-16T08:33:18.736Z</date_update> <dateutc_add>2026-09-16T08:33:18.736Z</dateutc_add> <dateutc_update>2026-09-16T08:33:18.736Z</dateutc_update> <db_table_id>729fa33f-a8ff-44f3-b469-7bddd82c8518</db_table_id> <id>b9524eb1-4e8b-4cc3-9c91-958a3e62dccc</id> <id_in_table>9ad6990d-b3a8-46a1-bedc-6e366e70bac9</id_in_table> <modified_dateutc>2026-09-16T08:33:18.736Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>62e9b46d-4a48-425a-8350-cb57baf5bca7</source_db_table_id> <source_id_in_table>9206cf3a-6a4d-4335-b6cc-7e263f4cf370</source_id_in_table> <updated_by_user_id>243b4cec-f61b-4cc7-84be-8ec914f802aa</updated_by_user_id> <user_id>82a073cf-7e0a-4e15-a9d8-29dadf3bf86f</user_id> </db_notes>