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": "f76b2f40-3ac0-44e7-ba66-3dd9b19c6305",
"db_table_id": "2b2f9acb-0f9f-484f-9fee-ebc9ea1863f1",
"id_in_table": "77cc61f4-a26d-471a-a68d-2b6a65d28f45",
"user_id": "d806d0cd-fc07-44d3-ac28-c6d59388b816",
"date_add": "2026-11-12T14:27:07.3055207+00:00",
"dateutc_add": "2026-11-12T14:27:07.3055207+00:00",
"notes": "sample string 7",
"source_db_table_id": "a7a43903-fa50-40b9-910e-feb32b024373",
"source_id_in_table": "eedd6fed-fc9e-42fc-8aed-ea477f5c745d",
"updated_by_user_id": "e171563d-c47e-4c93-a20e-71a86379dc45",
"date_update": "2026-11-12T14:27:07.3055207+00:00",
"dateutc_update": "2026-11-12T14:27:07.3055207+00:00",
"modified_dateutc": "2026-11-12T14:27:07.3055207+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:07.305Z</date_add> <date_update>2026-11-12T14:27:07.305Z</date_update> <dateutc_add>2026-11-12T14:27:07.305Z</dateutc_add> <dateutc_update>2026-11-12T14:27:07.305Z</dateutc_update> <db_table_id>2b2f9acb-0f9f-484f-9fee-ebc9ea1863f1</db_table_id> <id>f76b2f40-3ac0-44e7-ba66-3dd9b19c6305</id> <id_in_table>77cc61f4-a26d-471a-a68d-2b6a65d28f45</id_in_table> <modified_dateutc>2026-11-12T14:27:07.305Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>a7a43903-fa50-40b9-910e-feb32b024373</source_db_table_id> <source_id_in_table>eedd6fed-fc9e-42fc-8aed-ea477f5c745d</source_id_in_table> <updated_by_user_id>e171563d-c47e-4c93-a20e-71a86379dc45</updated_by_user_id> <user_id>d806d0cd-fc07-44d3-ac28-c6d59388b816</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": "c0597dc7-e85c-45f4-8171-ccc5d5fbeab5",
"db_table_id": "bfba07fb-9965-4647-b2b5-a63e4393ab3e",
"id_in_table": "cd47188f-039f-4579-9d86-0ef748a98adc",
"user_id": "b5bf0e61-e854-4649-a946-5f55d761b63e",
"date_add": "2026-11-12T14:27:07.3055207+00:00",
"dateutc_add": "2026-11-12T14:27:07.3055207+00:00",
"notes": "sample string 7",
"source_db_table_id": "ead5aa89-218d-4019-99ee-371005b8bacd",
"source_id_in_table": "da5a2416-2965-44fb-9878-939c939488d6",
"updated_by_user_id": "31892014-d07d-45f1-8a41-416e0e834600",
"date_update": "2026-11-12T14:27:07.3055207+00:00",
"dateutc_update": "2026-11-12T14:27:07.3055207+00:00",
"modified_dateutc": "2026-11-12T14:27:07.3055207+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:07.305Z</date_add> <date_update>2026-11-12T14:27:07.305Z</date_update> <dateutc_add>2026-11-12T14:27:07.305Z</dateutc_add> <dateutc_update>2026-11-12T14:27:07.305Z</dateutc_update> <db_table_id>bfba07fb-9965-4647-b2b5-a63e4393ab3e</db_table_id> <id>c0597dc7-e85c-45f4-8171-ccc5d5fbeab5</id> <id_in_table>cd47188f-039f-4579-9d86-0ef748a98adc</id_in_table> <modified_dateutc>2026-11-12T14:27:07.305Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>ead5aa89-218d-4019-99ee-371005b8bacd</source_db_table_id> <source_id_in_table>da5a2416-2965-44fb-9878-939c939488d6</source_id_in_table> <updated_by_user_id>31892014-d07d-45f1-8a41-416e0e834600</updated_by_user_id> <user_id>b5bf0e61-e854-4649-a946-5f55d761b63e</user_id> </db_notes>