Add/update db_notes
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": "3e60bf10-c1fa-445b-99e0-38b22886a7f9",
"db_table_id": "ba96bc71-632d-44b7-a4a8-60f154377c3e",
"id_in_table": "0e690aee-d14a-475b-8f35-b55a4c44ae1b",
"user_id": "cd4ebe61-1cf4-47c7-93e4-cf86031adc97",
"date_add": "2026-01-11T21:00:00.8314049+00:00",
"dateutc_add": "2026-01-11T21:00:00.8314049+00:00",
"notes": "sample string 7",
"source_db_table_id": "bdf2e285-e2a5-482f-91ec-b9481731e0b6",
"source_id_in_table": "ed4f73f5-7591-4319-9055-2d58f1073afa",
"updated_by_user_id": "4ec5e976-a6d4-472c-ad0f-a7b6c1909a4c",
"date_update": "2026-01-11T21:00:00.8314049+00:00",
"dateutc_update": "2026-01-11T21:00:00.8314049+00:00",
"modified_dateutc": "2026-01-11T21:00:00.8314049+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-01-11T21:00:00.831Z</date_add> <date_update>2026-01-11T21:00:00.831Z</date_update> <dateutc_add>2026-01-11T21:00:00.831Z</dateutc_add> <dateutc_update>2026-01-11T21:00:00.831Z</dateutc_update> <db_table_id>ba96bc71-632d-44b7-a4a8-60f154377c3e</db_table_id> <id>3e60bf10-c1fa-445b-99e0-38b22886a7f9</id> <id_in_table>0e690aee-d14a-475b-8f35-b55a4c44ae1b</id_in_table> <modified_dateutc>2026-01-11T21:00:00.831Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>bdf2e285-e2a5-482f-91ec-b9481731e0b6</source_db_table_id> <source_id_in_table>ed4f73f5-7591-4319-9055-2d58f1073afa</source_id_in_table> <updated_by_user_id>4ec5e976-a6d4-472c-ad0f-a7b6c1909a4c</updated_by_user_id> <user_id>cd4ebe61-1cf4-47c7-93e4-cf86031adc97</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": "5f872a20-7d37-4bff-b701-748d7d620fdd",
"db_table_id": "985d3bc0-fc32-4c62-a370-3641bc855cc3",
"id_in_table": "362fa25d-31c0-4b85-a946-14401d6ab27a",
"user_id": "db1b147e-e6df-47ec-9e20-2fcd5e8d3aba",
"date_add": "2026-01-11T21:00:00.8415283+00:00",
"dateutc_add": "2026-01-11T21:00:00.8415283+00:00",
"notes": "sample string 7",
"source_db_table_id": "26cbd192-5e72-4bf3-ba19-c96ddafb4036",
"source_id_in_table": "6c53a965-a4da-4f7d-a9c1-278b7b615b16",
"updated_by_user_id": "86165d6e-44fa-4b4d-ae00-785f239c35f3",
"date_update": "2026-01-11T21:00:00.8415283+00:00",
"dateutc_update": "2026-01-11T21:00:00.8415283+00:00",
"modified_dateutc": "2026-01-11T21:00:00.8415283+00:00"
}
application/xml, text/xml
Sample:
<db_notes xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <date_add>2026-01-11T21:00:00.841Z</date_add> <date_update>2026-01-11T21:00:00.841Z</date_update> <dateutc_add>2026-01-11T21:00:00.841Z</dateutc_add> <dateutc_update>2026-01-11T21:00:00.841Z</dateutc_update> <db_table_id>985d3bc0-fc32-4c62-a370-3641bc855cc3</db_table_id> <id>5f872a20-7d37-4bff-b701-748d7d620fdd</id> <id_in_table>362fa25d-31c0-4b85-a946-14401d6ab27a</id_in_table> <modified_dateutc>2026-01-11T21:00:00.841Z</modified_dateutc> <notes>sample string 7</notes> <source_db_table_id>26cbd192-5e72-4bf3-ba19-c96ddafb4036</source_db_table_id> <source_id_in_table>6c53a965-a4da-4f7d-a9c1-278b7b615b16</source_id_in_table> <updated_by_user_id>86165d6e-44fa-4b4d-ae00-785f239c35f3</updated_by_user_id> <user_id>db1b147e-e6df-47ec-9e20-2fcd5e8d3aba</user_id> </db_notes>