GET api/P1QueryDefinition/ApplicableColumns?projectId={projectId}

all searchable columns

Request Information

URI Parameters

NameDescriptionTypeAdditional information
projectId

integer

Required

Body Parameters

None.

Response Information

Resource Description

all searchable columns

API_Data_IEnumerableOfSearchableColumn
NameDescriptionTypeAdditional information
Success

boolean

None.
Error

ErrorInfo

None.
Data

Collection of SearchableColumn

None.

Response Formats

application/json, text/json

Sample: 
{
  "Success": true,
  "Error": {
    "ErrorCode": 1,
    "ErrorMessage": "sample string 1"
  },
  "Data": [
    {
      "FieldId": 1,
      "FieldName": "sample string 2",
      "FieldTypeId": 3,
      "SearchConditionType": 4
    },
    {
      "FieldId": 1,
      "FieldName": "sample string 2",
      "FieldTypeId": 3,
      "SearchConditionType": 4
    }
  ]
}

application/xml, text/xml

Sample: 
<API_Data_ArrayOfSearchableColumn xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/TechExcel.DTKService.Model.Common">
  <Data xmlns:d2p1="http://schemas.datacontract.org/2004/07/TechExcel.DTKService.Model.Search">
    <d2p1:SearchableColumn>
      <d2p1:FieldId>1</d2p1:FieldId>
      <d2p1:FieldName>sample string 2</d2p1:FieldName>
      <d2p1:FieldTypeId>3</d2p1:FieldTypeId>
      <d2p1:SearchConditionType>4</d2p1:SearchConditionType>
    </d2p1:SearchableColumn>
    <d2p1:SearchableColumn>
      <d2p1:FieldId>1</d2p1:FieldId>
      <d2p1:FieldName>sample string 2</d2p1:FieldName>
      <d2p1:FieldTypeId>3</d2p1:FieldTypeId>
      <d2p1:SearchConditionType>4</d2p1:SearchConditionType>
    </d2p1:SearchableColumn>
  </Data>
  <Error>
    <ErrorCode>1</ErrorCode>
    <ErrorMessage>sample string 1</ErrorMessage>
  </Error>
  <Success>true</Success>
</API_Data_ArrayOfSearchableColumn>