GET api/DMS/1/0/GetFieldList?databaseId={databaseId}&tableId={tableId}
Obtiene el listado de los registros de una tabla del DMS.
Información del Request
Parametros de la URI
| Nombre | Descripción | Tipo | Información Adicional |
|---|---|---|---|
| databaseId | integer |
Required |
|
| tableId | string |
Required |
Parametros del Body
Información del Response
Descripción de los parametros
SFE.Core.Layer.Models.FunctionResultOfSFE.Core.Modules.DMS.TableFields| Nombre | Descripción | Tipo | Información Adicional |
|---|---|---|---|
| Result | SFE.Core.Modules.DMS.TableFields |
N/A |
|
| ResponseCode | string |
N/A |
|
| TotalRecords | integer |
N/A |
Ejemplos de response:
application/json, text/json
Ejemplo:
{
"Result": {
"DatabaseId": 1,
"TableId": "sample string 2",
"RecordId": "sample string 3",
"Fields": [
{
"_Name": "sample string 1",
"_Type": "sample string 2",
"_Maxlength": 3,
"_Label": "sample string 4",
"_Options": [
{
"_Text": "sample string 1",
"_Value": "sample string 2"
},
{
"_Text": "sample string 1",
"_Value": "sample string 2"
}
],
"_Default": "sample string 5",
"_Required": true,
"_Data": "sample string 7"
},
{
"_Name": "sample string 1",
"_Type": "sample string 2",
"_Maxlength": 3,
"_Label": "sample string 4",
"_Options": [
{
"_Text": "sample string 1",
"_Value": "sample string 2"
},
{
"_Text": "sample string 1",
"_Value": "sample string 2"
}
],
"_Default": "sample string 5",
"_Required": true,
"_Data": "sample string 7"
}
],
"ToTableId": "sample string 4",
"ToRecordId": "sample string 5"
},
"ResponseCode": "sample string 1",
"TotalRecords": 2
}
application/xml, text/xml
Ejemplo:
<FunctionResultOfTableFields1JVIocMK xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/SFE.Core.Layer.Models">
<ResponseCode>sample string 1</ResponseCode>
<Result xmlns:d2p1="http://schemas.datacontract.org/2004/07/SFE.Core.Modules.DMS">
<d2p1:DatabaseId>1</d2p1:DatabaseId>
<d2p1:Fields>
<d2p1:TableField>
<d2p1:_Data>sample string 7</d2p1:_Data>
<d2p1:_Default>sample string 5</d2p1:_Default>
<d2p1:_Label>sample string 4</d2p1:_Label>
<d2p1:_Maxlength>3</d2p1:_Maxlength>
<d2p1:_Name>sample string 1</d2p1:_Name>
<d2p1:_Options>
<d2p1:Option>
<d2p1:_Text>sample string 1</d2p1:_Text>
<d2p1:_Value>sample string 2</d2p1:_Value>
</d2p1:Option>
<d2p1:Option>
<d2p1:_Text>sample string 1</d2p1:_Text>
<d2p1:_Value>sample string 2</d2p1:_Value>
</d2p1:Option>
</d2p1:_Options>
<d2p1:_Required>true</d2p1:_Required>
<d2p1:_Type>sample string 2</d2p1:_Type>
</d2p1:TableField>
<d2p1:TableField>
<d2p1:_Data>sample string 7</d2p1:_Data>
<d2p1:_Default>sample string 5</d2p1:_Default>
<d2p1:_Label>sample string 4</d2p1:_Label>
<d2p1:_Maxlength>3</d2p1:_Maxlength>
<d2p1:_Name>sample string 1</d2p1:_Name>
<d2p1:_Options>
<d2p1:Option>
<d2p1:_Text>sample string 1</d2p1:_Text>
<d2p1:_Value>sample string 2</d2p1:_Value>
</d2p1:Option>
<d2p1:Option>
<d2p1:_Text>sample string 1</d2p1:_Text>
<d2p1:_Value>sample string 2</d2p1:_Value>
</d2p1:Option>
</d2p1:_Options>
<d2p1:_Required>true</d2p1:_Required>
<d2p1:_Type>sample string 2</d2p1:_Type>
</d2p1:TableField>
</d2p1:Fields>
<d2p1:RecordId>sample string 3</d2p1:RecordId>
<d2p1:TableId>sample string 2</d2p1:TableId>
<d2p1:ToRecordId>sample string 5</d2p1:ToRecordId>
<d2p1:ToTableId>sample string 4</d2p1:ToTableId>
</Result>
<TotalRecords>2</TotalRecords>
</FunctionResultOfTableFields1JVIocMK>