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": "5975b1c7-39bc-454e-9f25-e66cc8be06a4",
"db_table_id": "76e27853-7ae0-4d66-a834-75d4c73c8e05",
"id_in_table": "e56f997a-19d2-4674-9cfa-1e0f53f31481",
"user_id": "b1950ca9-919c-435d-8e74-9ca46500815a",
"date_add": "2026-06-16T21:15:51.7611734+00:00",
"dateutc_add": "2026-06-16T21:15:51.7611734+00:00",
"notes": "sample string 7",
"source_db_table_id": "1bd8f559-290e-47e8-9eb7-0e29527f0f79",
"source_id_in_table": "bdd84d70-62af-45f5-8bbb-29b13de934ac",
"updated_by_user_id": "bde742b9-2640-408b-b937-95bdfc0f214b",
"date_update": "2026-06-16T21:15:51.7611734+00:00",
"dateutc_update": "2026-06-16T21:15:51.7611734+00:00",
"modified_dateutc": "2026-06-16T21:15:51.7722342+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T21:15:51.761Z</date_add> <date_update>2026-06-16T21:15:51.761Z</date_update> <dateutc_add>2026-06-16T21:15:51.761Z</dateutc_add> <dateutc_update>2026-06-16T21:15:51.761Z</dateutc_update> <db_table_id>76e27853-7ae0-4d66-a834-75d4c73c8e05</db_table_id> <id>5975b1c7-39bc-454e-9f25-e66cc8be06a4</id> <id_in_table>e56f997a-19d2-4674-9cfa-1e0f53f31481</id_in_table> <modified_dateutc>2026-06-16T21:15:51.772Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>1bd8f559-290e-47e8-9eb7-0e29527f0f79</source_db_table_id> <source_id_in_table>bdd84d70-62af-45f5-8bbb-29b13de934ac</source_id_in_table> <updated_by_user_id>bde742b9-2640-408b-b937-95bdfc0f214b</updated_by_user_id> <user_id>b1950ca9-919c-435d-8e74-9ca46500815a</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": "dcfd1816-8da1-4c4d-b9b4-abc98addcbbb",
"db_table_id": "4ebb8575-adb9-46cb-9ce1-f499dbe3b0c3",
"id_in_table": "96efb215-452a-4c56-8187-0df18066a18f",
"user_id": "d03511d9-4ef6-45af-a41b-0b577cb860ee",
"date_add": "2026-06-16T21:15:51.9017951+00:00",
"dateutc_add": "2026-06-16T21:15:51.9017951+00:00",
"notes": "sample string 7",
"source_db_table_id": "ee66371a-dc27-4d15-87a3-4813c948081f",
"source_id_in_table": "f388246b-c962-4848-a7ec-00bfdc5dc085",
"updated_by_user_id": "d427e013-8b7f-41fc-833c-9d4ac5def139",
"date_update": "2026-06-16T21:15:51.9017951+00:00",
"dateutc_update": "2026-06-16T21:15:51.9017951+00:00",
"modified_dateutc": "2026-06-16T21:15:51.9017951+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-06-16T21:15:51.901Z</date_add> <date_update>2026-06-16T21:15:51.901Z</date_update> <dateutc_add>2026-06-16T21:15:51.901Z</dateutc_add> <dateutc_update>2026-06-16T21:15:51.901Z</dateutc_update> <db_table_id>4ebb8575-adb9-46cb-9ce1-f499dbe3b0c3</db_table_id> <id>dcfd1816-8da1-4c4d-b9b4-abc98addcbbb</id> <id_in_table>96efb215-452a-4c56-8187-0df18066a18f</id_in_table> <modified_dateutc>2026-06-16T21:15:51.901Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>ee66371a-dc27-4d15-87a3-4813c948081f</source_db_table_id> <source_id_in_table>f388246b-c962-4848-a7ec-00bfdc5dc085</source_id_in_table> <updated_by_user_id>d427e013-8b7f-41fc-833c-9d4ac5def139</updated_by_user_id> <user_id>d03511d9-4ef6-45af-a41b-0b577cb860ee</user_id> </db_notes>