Creates or updates multiple notes in one call.
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": "4bce0b0f-4e29-4ac1-8692-e4d2f59d9efc",
"db_table_id": "8c7cbea5-f0f4-4634-bfe0-a0852a3e0c50",
"id_in_table": "78a1acfd-b647-4d7c-9ef5-330b1f3b0a53",
"user_id": "e55a40b6-56ce-48b5-8233-d257bd033a6a",
"date_add": "2026-11-12T14:27:02.5554467+00:00",
"dateutc_add": "2026-11-12T14:27:02.5554467+00:00",
"notes": "sample string 7",
"source_db_table_id": "3c357f3d-c430-4b69-9219-5ba35823cb05",
"source_id_in_table": "43401b83-166b-4f95-a993-53d05627035a",
"updated_by_user_id": "a30ede51-3d5f-4555-94b8-69cf1b1b0c99",
"date_update": "2026-11-12T14:27:02.5554467+00:00",
"dateutc_update": "2026-11-12T14:27:02.5554467+00:00",
"modified_dateutc": "2026-11-12T14:27:02.5554467+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:02.555Z</date_add> <date_update>2026-11-12T14:27:02.555Z</date_update> <dateutc_add>2026-11-12T14:27:02.555Z</dateutc_add> <dateutc_update>2026-11-12T14:27:02.555Z</dateutc_update> <db_table_id>8c7cbea5-f0f4-4634-bfe0-a0852a3e0c50</db_table_id> <id>4bce0b0f-4e29-4ac1-8692-e4d2f59d9efc</id> <id_in_table>78a1acfd-b647-4d7c-9ef5-330b1f3b0a53</id_in_table> <modified_dateutc>2026-11-12T14:27:02.555Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>3c357f3d-c430-4b69-9219-5ba35823cb05</source_db_table_id> <source_id_in_table>43401b83-166b-4f95-a993-53d05627035a</source_id_in_table> <updated_by_user_id>a30ede51-3d5f-4555-94b8-69cf1b1b0c99</updated_by_user_id> <user_id>e55a40b6-56ce-48b5-8233-d257bd033a6a</user_id> </db_notes>
Response Information
Resource Description :
IHttpActionResult containing the batch save results for each processed record.
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": "30852eab-9422-4f37-bdb7-f83e32c1fc80",
"db_table_id": "2b721dac-a1a3-438b-a4b3-69f12aaeabc6",
"id_in_table": "5007dead-9171-4a38-804d-a47408dc8cc3",
"user_id": "bf91bbb9-45e3-4cb5-a245-eed0836b77c7",
"date_add": "2026-11-12T14:27:02.5554467+00:00",
"dateutc_add": "2026-11-12T14:27:02.5554467+00:00",
"notes": "sample string 7",
"source_db_table_id": "b3dcc865-60fa-423f-a22c-1459ccb31e76",
"source_id_in_table": "a1ef4c42-ec21-477a-9390-e9ef9344f874",
"updated_by_user_id": "c28d8345-32b9-4316-8b44-166e3ec9e12b",
"date_update": "2026-11-12T14:27:02.5554467+00:00",
"dateutc_update": "2026-11-12T14:27:02.5554467+00:00",
"modified_dateutc": "2026-11-12T14:27:02.5554467+00:00"
}
application/xml, text/xml
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-11-12T14:27:02.555Z</date_add> <date_update>2026-11-12T14:27:02.555Z</date_update> <dateutc_add>2026-11-12T14:27:02.555Z</dateutc_add> <dateutc_update>2026-11-12T14:27:02.555Z</dateutc_update> <db_table_id>2b721dac-a1a3-438b-a4b3-69f12aaeabc6</db_table_id> <id>30852eab-9422-4f37-bdb7-f83e32c1fc80</id> <id_in_table>5007dead-9171-4a38-804d-a47408dc8cc3</id_in_table> <modified_dateutc>2026-11-12T14:27:02.555Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>b3dcc865-60fa-423f-a22c-1459ccb31e76</source_db_table_id> <source_id_in_table>a1ef4c42-ec21-477a-9390-e9ef9344f874</source_id_in_table> <updated_by_user_id>c28d8345-32b9-4316-8b44-166e3ec9e12b</updated_by_user_id> <user_id>bf91bbb9-45e3-4cb5-a245-eed0836b77c7</user_id> </db_notes>