Creates or updates multiple notes in one call.

Request Information

URI Parameters :

None.

Body Parameters :

db_notes
NameDescriptionTypeAdditional 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

Sample:
{
  "id": "73efbcf4-9b17-48e3-b60f-187beea2c86b",
  "db_table_id": "2cf41351-a2e6-47d1-b1e2-6dbf847d297b",
  "id_in_table": "4a1f2989-cef8-474c-af81-833b25a24c38",
  "user_id": "6f033c60-8837-4684-9023-36233ea97d23",
  "date_add": "2026-09-16T08:33:11.137307+00:00",
  "dateutc_add": "2026-09-16T08:33:11.137307+00:00",
  "notes": "sample string 7",
  "source_db_table_id": "84679f6c-d3b4-40f5-a9b3-20f66f66f5d6",
  "source_id_in_table": "abd1e376-b5d1-4621-8255-770b085cbea5",
  "updated_by_user_id": "4e1cb151-9f72-4f43-b874-08c76b1f7afc",
  "date_update": "2026-09-16T08:33:11.137307+00:00",
  "dateutc_update": "2026-09-16T08:33:11.137307+00:00",
  "modified_dateutc": "2026-09-16T08:33:11.137307+00:00"
}

application/xml, text/xml

Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <date_add>2026-09-16T08:33:11.137Z</date_add>
  <date_update>2026-09-16T08:33:11.137Z</date_update>
  <dateutc_add>2026-09-16T08:33:11.137Z</dateutc_add>
  <dateutc_update>2026-09-16T08:33:11.137Z</dateutc_update>
  <db_table_id>2cf41351-a2e6-47d1-b1e2-6dbf847d297b</db_table_id>
  <id>73efbcf4-9b17-48e3-b60f-187beea2c86b</id>
  <id_in_table>4a1f2989-cef8-474c-af81-833b25a24c38</id_in_table>
  <modified_dateutc>2026-09-16T08:33:11.137Z</modified_dateutc>
  <notes>sample string 7</notes>
  <source_db_table_id>84679f6c-d3b4-40f5-a9b3-20f66f66f5d6</source_db_table_id>
  <source_id_in_table>abd1e376-b5d1-4621-8255-770b085cbea5</source_id_in_table>
  <updated_by_user_id>4e1cb151-9f72-4f43-b874-08c76b1f7afc</updated_by_user_id>
  <user_id>6f033c60-8837-4684-9023-36233ea97d23</user_id>
</db_notes>

Response Information

Resource Description :

IHttpActionResult containing the batch save results for each processed record.

db_notes
NameDescriptionTypeAdditional 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

Sample:
{
  "id": "5ad3be6a-00b6-42a4-b42f-cf55f91ff957",
  "db_table_id": "b1113e0e-07ec-4411-b576-5ea60c68ed38",
  "id_in_table": "753de0e9-3bb4-4276-ab78-8e24a855c343",
  "user_id": "cdeddd42-6810-439e-98b8-c6ab9916c78f",
  "date_add": "2026-09-16T08:33:11.2020174+00:00",
  "dateutc_add": "2026-09-16T08:33:11.2020174+00:00",
  "notes": "sample string 7",
  "source_db_table_id": "0e59b48a-eac6-4087-a31e-1a52e639fbab",
  "source_id_in_table": "b1ab907b-9410-4a93-bb87-3367bb2cc6b2",
  "updated_by_user_id": "5d59bc4a-0955-4c23-9835-9dc534bccaa1",
  "date_update": "2026-09-16T08:33:11.2020174+00:00",
  "dateutc_update": "2026-09-16T08:33:11.2020174+00:00",
  "modified_dateutc": "2026-09-16T08:33:11.2020174+00:00"
}

application/xml, text/xml

Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <date_add>2026-09-16T08:33:11.202Z</date_add>
  <date_update>2026-09-16T08:33:11.202Z</date_update>
  <dateutc_add>2026-09-16T08:33:11.202Z</dateutc_add>
  <dateutc_update>2026-09-16T08:33:11.202Z</dateutc_update>
  <db_table_id>b1113e0e-07ec-4411-b576-5ea60c68ed38</db_table_id>
  <id>5ad3be6a-00b6-42a4-b42f-cf55f91ff957</id>
  <id_in_table>753de0e9-3bb4-4276-ab78-8e24a855c343</id_in_table>
  <modified_dateutc>2026-09-16T08:33:11.202Z</modified_dateutc>
  <notes>sample string 7</notes>
  <source_db_table_id>0e59b48a-eac6-4087-a31e-1a52e639fbab</source_db_table_id>
  <source_id_in_table>b1ab907b-9410-4a93-bb87-3367bb2cc6b2</source_id_in_table>
  <updated_by_user_id>5d59bc4a-0955-4c23-9835-9dc534bccaa1</updated_by_user_id>
  <user_id>cdeddd42-6810-439e-98b8-c6ab9916c78f</user_id>
</db_notes>