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

NombreDescripciónTipoInformació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
NombreDescripciónTipoInformació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>