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 | globally unique identifier | ||
| source_id_in_table | globally unique identifier | ||
| updated_by_user_id | globally unique identifier | ||
| date_update | date | ||
| dateutc_update | date | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Request Formats :
application/json, text/json
Sample:
{
"id": "a4ad0715-e99a-4003-8d44-3b7b0029d2d5",
"db_table_id": "1cafdb5a-dcad-4c83-81e8-2d2c964265e2",
"id_in_table": "8487adc2-37a5-4379-8200-61339b363814",
"user_id": "f584f07f-6465-459f-9f49-ee75ede88e91",
"date_add": "2026-06-16T22:28:39.1469298+00:00",
"dateutc_add": "2026-06-16T22:28:39.1469298+00:00",
"notes": "sample string 7",
"source_db_table_id": "ea8adeaa-8698-47ca-9597-92d5ed80dafc",
"source_id_in_table": "f06519c7-c69c-4aff-b8d3-23f3f9b21d48",
"updated_by_user_id": "a8d64437-175f-46ee-a12e-24b486528527",
"date_update": "2026-06-16T22:28:39.1469298+00:00",
"dateutc_update": "2026-06-16T22:28:39.1469298+00:00",
"modified_dateutc": "2026-06-16T22:28:39.1469298+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T22:28:39.146Z</date_add> <date_update>2026-06-16T22:28:39.146Z</date_update> <dateutc_add>2026-06-16T22:28:39.146Z</dateutc_add> <dateutc_update>2026-06-16T22:28:39.146Z</dateutc_update> <db_table_id>1cafdb5a-dcad-4c83-81e8-2d2c964265e2</db_table_id> <id>a4ad0715-e99a-4003-8d44-3b7b0029d2d5</id> <id_in_table>8487adc2-37a5-4379-8200-61339b363814</id_in_table> <modified_dateutc>2026-06-16T22:28:39.146Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>ea8adeaa-8698-47ca-9597-92d5ed80dafc</source_db_table_id> <source_id_in_table>f06519c7-c69c-4aff-b8d3-23f3f9b21d48</source_id_in_table> <updated_by_user_id>a8d64437-175f-46ee-a12e-24b486528527</updated_by_user_id> <user_id>f584f07f-6465-459f-9f49-ee75ede88e91</user_id> </db_notes>
Response Information
Resource Description :
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 | globally unique identifier | ||
| source_id_in_table | globally unique identifier | ||
| updated_by_user_id | globally unique identifier | ||
| date_update | date | ||
| dateutc_update | date | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
Sample:
{
"id": "dfb0d99b-8990-4635-898e-de10f0ca4f53",
"db_table_id": "67684734-7c6e-4b9c-a40d-4e797d1ed1ed",
"id_in_table": "14b393fb-79fc-42b4-bc64-03d50ef09dca",
"user_id": "527597b9-aa75-4aa9-b98d-c07a7befdbc5",
"date_add": "2026-06-16T22:28:39.1469298+00:00",
"dateutc_add": "2026-06-16T22:28:39.1469298+00:00",
"notes": "sample string 7",
"source_db_table_id": "4e9e3885-2f8e-4c2a-b56c-26936ef899ae",
"source_id_in_table": "bc65a886-fc5f-4dcc-945b-d1c1dbcfdeaa",
"updated_by_user_id": "e3d8b89b-2bcc-4fd2-9700-0b1f64c8e4af",
"date_update": "2026-06-16T22:28:39.1469298+00:00",
"dateutc_update": "2026-06-16T22:28:39.1469298+00:00",
"modified_dateutc": "2026-06-16T22:28:39.1469298+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T22:28:39.146Z</date_add> <date_update>2026-06-16T22:28:39.146Z</date_update> <dateutc_add>2026-06-16T22:28:39.146Z</dateutc_add> <dateutc_update>2026-06-16T22:28:39.146Z</dateutc_update> <db_table_id>67684734-7c6e-4b9c-a40d-4e797d1ed1ed</db_table_id> <id>dfb0d99b-8990-4635-898e-de10f0ca4f53</id> <id_in_table>14b393fb-79fc-42b4-bc64-03d50ef09dca</id_in_table> <modified_dateutc>2026-06-16T22:28:39.146Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>4e9e3885-2f8e-4c2a-b56c-26936ef899ae</source_db_table_id> <source_id_in_table>bc65a886-fc5f-4dcc-945b-d1c1dbcfdeaa</source_id_in_table> <updated_by_user_id>e3d8b89b-2bcc-4fd2-9700-0b1f64c8e4af</updated_by_user_id> <user_id>527597b9-aa75-4aa9-b98d-c07a7befdbc5</user_id> </db_notes>