Retrieves the db_info_data object with the specified key
Request Information
URI Parameters :
Name | Description | Type | Additional information |
---|---|---|---|
id | globally unique identifier |
Required |
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
db_info_dataName | Description | Type | Additional information |
---|---|---|---|
id |
Primary key |
globally unique identifier | |
target_id |
Foreign key of the object using his Odyssee Guid Primary Key |
globally unique identifier |
Optionally required : target_id or target_code must be provided |
target_code |
Foreign key of the object using ERP PK when adding/updating db_info_data |
string |
Optionally required : target_id or target_code must be provided |
db_table_id |
Foreign key to the table that own the "target_id" (Example:article,company,project) using Guid |
globally unique identifier |
Optionally required : db_table_id or db_table_name must be provided |
db_table_name |
Foreign key to the table that own the "target_id" (Example:article,company,project) using table name |
string |
Optionally required : db_table_id or db_table_name must be provided |
db_info_field_id | globally unique identifier |
Optionally required : db_info_field_id, db_info_field_name or db_info_field must be provided |
|
db_info_field_name | string |
Optionally required : db_info_field_id, db_info_field_name or db_info_field must be provided |
|
db_info_field | db_info_field |
Optionally required : db_info_field_id, db_info_field_name or db_info_field must be provided |
|
value |
The value of this info fields for this targetId. Follow the formating rules (API / HELP / Info Fields) |
string |
Required |
reference_back_office |
The Id/Ref of the back office for this object |
string |
Max length: 50 |
sys_logical_delete |
sys_logical_delete |
boolean | |
modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{ "id": "0b6c1d90-35b9-4a03-8a4a-8c6e94e00c0c", "target_id": "d921dbf6-38f4-4b93-86d9-7fbbce3a9ee0", "target_code": "sample string 3", "db_table_id": "fcac65c1-e7bc-4b5b-8c82-3e5d031c6d1b", "db_table_name": "sample string 5", "db_info_field_id": "b8b0112e-83e8-4a27-a3be-d21d7b539004", "db_info_field_name": "sample string 7", "value": "sample string 8", "reference_back_office": "sample string 9", "sys_logical_delete": true, "modified_dateutc": "2024-07-26T19:08:12.2168987+00:00" }