Retrieves all items
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
db_info_field| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier | |
| db_info_id |
db_info_id |
globally unique identifier | |
| db_input_type_id |
Constant that refer to the kind of info field (like textarea, datetime) |
globally unique identifier | |
| sequence |
Order field, need to order by sequence asc |
integer | |
| title |
The label of the field |
string |
Max length: 100 |
| default_value |
Contains the value that should be used when no value exists |
string |
Max length: 255 |
| is_readonly |
Avoid user to edit the value using the UI |
boolean | |
| is_mandatory |
is_mandatory |
boolean | |
| reference_db_info_field_id | globally unique identifier | ||
| visible_on_app |
visible_on_app |
boolean | |
| udf_name |
To know the POI is stored on udf_ columns or on the dbinfodata table |
string |
Max length: 20 |
| archived | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
Sample:
{
"id": "499b458c-d835-4d8b-b3d6-b4b9770e31e8",
"db_info_id": "33b59bb7-d8ab-4787-b734-f9487b832931",
"db_input_type_id": "a343adfb-2fd4-45ce-a980-3c7940e3a268",
"sequence": 4,
"title": "sample string 5",
"default_value": "sample string 6",
"is_readonly": true,
"is_mandatory": true,
"reference_db_info_field_id": "c3eb2a50-e776-4af4-8ca0-352367df460c",
"visible_on_app": true,
"udf_name": "sample string 11",
"archived": true,
"modified_dateutc": "2026-06-16T21:18:56.0364988+00:00"
}
application/xml, text/xml
Sample:
<db_info_field xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <archived>true</archived> <db_info_id>33b59bb7-d8ab-4787-b734-f9487b832931</db_info_id> <db_input_type_id>a343adfb-2fd4-45ce-a980-3c7940e3a268</db_input_type_id> <default_value>sample string 6</default_value> <id>499b458c-d835-4d8b-b3d6-b4b9770e31e8</id> <is_mandatory>true</is_mandatory> <is_readonly>true</is_readonly> <modified_dateutc>2026-06-16T21:18:56.036Z</modified_dateutc> <reference_db_info_field_id>c3eb2a50-e776-4af4-8ca0-352367df460c</reference_db_info_field_id> <sequence>4</sequence> <title>sample string 5</title> <udf_name>sample string 11</udf_name> <visible_on_app>true</visible_on_app> </db_info_field>