Retrieves the item with the specified key

Request Information

URI Parameters :

NameDescriptionTypeAdditional information
id

globally unique identifier

Required

Body Parameters :

None.

Response Information

Resource Description :

IHttpActionResult

db_info_field
NameDescriptionTypeAdditional 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
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date

Response Formats

application/json, text/json

Sample: 
{
  "id": "801f1a86-95b5-43c2-b9a8-8798c7edeb30",
  "db_info_id": "a036d829-d624-4214-9b44-0a233376717b",
  "db_input_type_id": "2ebff3ae-3f40-4a17-9eaa-f85516b95fb9",
  "sequence": 4,
  "title": "sample string 5",
  "default_value": "sample string 6",
  "is_readonly": true,
  "is_mandatory": true,
  "reference_db_info_field_id": "54fb49b3-cc12-4fc4-ab24-8862c8060a85",
  "visible_on_app": true,
  "udf_name": "sample string 11",
  "modified_dateutc": "2026-01-11T21:06:21.162947+00:00"
}

application/xml, text/xml

Sample: 
<db_info_field xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <db_info_id>a036d829-d624-4214-9b44-0a233376717b</db_info_id>
  <db_input_type_id>2ebff3ae-3f40-4a17-9eaa-f85516b95fb9</db_input_type_id>
  <default_value>sample string 6</default_value>
  <id>801f1a86-95b5-43c2-b9a8-8798c7edeb30</id>
  <is_mandatory>true</is_mandatory>
  <is_readonly>true</is_readonly>
  <modified_dateutc>2026-01-11T21:06:21.162Z</modified_dateutc>
  <reference_db_info_field_id>54fb49b3-cc12-4fc4-ab24-8862c8060a85</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>