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": "701dfbdd-27ef-4a60-b7c3-d0e62e68497d",
"db_table_id": "f6ef9ac2-bec4-42dd-a602-99f10b9d0bf8",
"id_in_table": "c80fdfc4-5621-4417-bf4c-100800c9d89b",
"user_id": "d59778ff-7de1-403d-a2bb-7eadd94fcc44",
"date_add": "2026-03-07T13:12:04.5610958+00:00",
"dateutc_add": "2026-03-07T13:12:04.5610958+00:00",
"notes": "sample string 7",
"source_db_table_id": "a33616e4-f446-4517-9fc6-0d55d6093cc1",
"source_id_in_table": "75b83cd7-7ea4-49d0-8634-da6c8e1ae943",
"updated_by_user_id": "1bedefe6-8977-4d66-8beb-29acd1c50240",
"date_update": "2026-03-07T13:12:04.5610958+00:00",
"dateutc_update": "2026-03-07T13:12:04.5610958+00:00",
"modified_dateutc": "2026-03-07T13:12:04.5610958+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-03-07T13:12:04.561Z</date_add> <date_update>2026-03-07T13:12:04.561Z</date_update> <dateutc_add>2026-03-07T13:12:04.561Z</dateutc_add> <dateutc_update>2026-03-07T13:12:04.561Z</dateutc_update> <db_table_id>f6ef9ac2-bec4-42dd-a602-99f10b9d0bf8</db_table_id> <id>701dfbdd-27ef-4a60-b7c3-d0e62e68497d</id> <id_in_table>c80fdfc4-5621-4417-bf4c-100800c9d89b</id_in_table> <modified_dateutc>2026-03-07T13:12:04.561Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>a33616e4-f446-4517-9fc6-0d55d6093cc1</source_db_table_id> <source_id_in_table>75b83cd7-7ea4-49d0-8634-da6c8e1ae943</source_id_in_table> <updated_by_user_id>1bedefe6-8977-4d66-8beb-29acd1c50240</updated_by_user_id> <user_id>d59778ff-7de1-403d-a2bb-7eadd94fcc44</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": "2f3758f5-d892-42d2-b5d4-61a9e1f95350",
"db_table_id": "590bec2c-5507-4750-8d91-d39ca67f8a5a",
"id_in_table": "9e1b1a97-ab50-4694-9a05-0dcaa13c32fc",
"user_id": "fd010565-5ca6-48b7-b37d-fede3d63a977",
"date_add": "2026-03-07T13:12:04.5610958+00:00",
"dateutc_add": "2026-03-07T13:12:04.5610958+00:00",
"notes": "sample string 7",
"source_db_table_id": "a7773f7a-4647-42c1-b823-79bdbbbf1c82",
"source_id_in_table": "0ac9a69c-458e-411e-a548-2cb44886e3f0",
"updated_by_user_id": "1a1f6bc6-1c76-45d1-aeba-6e9f6cdc51b0",
"date_update": "2026-03-07T13:12:04.5610958+00:00",
"dateutc_update": "2026-03-07T13:12:04.5610958+00:00",
"modified_dateutc": "2026-03-07T13:12:04.5610958+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-03-07T13:12:04.561Z</date_add> <date_update>2026-03-07T13:12:04.561Z</date_update> <dateutc_add>2026-03-07T13:12:04.561Z</dateutc_add> <dateutc_update>2026-03-07T13:12:04.561Z</dateutc_update> <db_table_id>590bec2c-5507-4750-8d91-d39ca67f8a5a</db_table_id> <id>2f3758f5-d892-42d2-b5d4-61a9e1f95350</id> <id_in_table>9e1b1a97-ab50-4694-9a05-0dcaa13c32fc</id_in_table> <modified_dateutc>2026-03-07T13:12:04.561Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>a7773f7a-4647-42c1-b823-79bdbbbf1c82</source_db_table_id> <source_id_in_table>0ac9a69c-458e-411e-a548-2cb44886e3f0</source_id_in_table> <updated_by_user_id>1a1f6bc6-1c76-45d1-aeba-6e9f6cdc51b0</updated_by_user_id> <user_id>fd010565-5ca6-48b7-b37d-fede3d63a977</user_id> </db_notes>