JiwaAPI

DB_DebtorSystemTemplateFieldsQuery

**DB_DebtorSystemTemplateFieldsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
DB_DebtorSystemTemplates_RecID	query	string	No
DB_DebtorSystemTemplates_RecIDStartsWith	query	string	No
DB_DebtorSystemTemplates_RecIDEndsWith	query	string	No
DB_DebtorSystemTemplates_RecIDContains	query	string	No
DB_DebtorSystemTemplates_RecIDLike	query	string	No
DB_DebtorSystemTemplates_RecIDBetween	query	string[]	No
DB_DebtorSystemTemplates_RecIDIn	query	string[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
Name	query	string	No
NameStartsWith	query	string	No
NameEndsWith	query	string	No
NameContains	query	string	No
NameLike	query	string	No
NameBetween	query	string[]	No
NameIn	query	string[]	No
FieldType	query	short?	No
FieldTypeGreaterThanOrEqualTo	query	short?	No
FieldTypeGreaterThan	query	short?	No
FieldTypeLessThan	query	short?	No
FieldTypeLessThanOrEqualTo	query	short?	No
FieldTypeNotEqualTo	query	short?	No
FieldTypeBetween	query	short[]	No
FieldTypeIn	query	short[]	No
ComboText	query	string	No
ComboTextStartsWith	query	string	No
ComboTextEndsWith	query	string	No
ComboTextContains	query	string	No
ComboTextLike	query	string	No
ComboTextBetween	query	string[]	No
ComboTextIn	query	string[]	No
DefaultValue	query	string	No
DefaultValueStartsWith	query	string	No
DefaultValueEndsWith	query	string	No
DefaultValueContains	query	string	No
DefaultValueLike	query	string	No
DefaultValueBetween	query	string[]	No
DefaultValueIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	No
RowHash	query	byte[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**DB_DebtorSystemTemplateFields** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
DB_DebtorSystemTemplates_RecID	form	string	No
LastSavedDateTime	form	DateTime?	No
Name	form	string	No
FieldType	form	short	No
ComboText	form	string	No
DefaultValue	form	string	No
ItemNo	form	int	No
RowHash	form	byte[]	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /xml/reply/DB_DebtorSystemTemplateFieldsQuery HTTP/1.1 
Host: localhost 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<DB_DebtorSystemTemplateFieldsQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <ComboText>String</ComboText>
  <ComboTextBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComboTextBetween>
  <ComboTextContains>String</ComboTextContains>
  <ComboTextEndsWith>String</ComboTextEndsWith>
  <ComboTextIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ComboTextIn>
  <ComboTextLike>String</ComboTextLike>
  <ComboTextStartsWith>String</ComboTextStartsWith>
  <DB_DebtorSystemTemplates_RecID>String</DB_DebtorSystemTemplates_RecID>
  <DB_DebtorSystemTemplates_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_DebtorSystemTemplates_RecIDBetween>
  <DB_DebtorSystemTemplates_RecIDContains>String</DB_DebtorSystemTemplates_RecIDContains>
  <DB_DebtorSystemTemplates_RecIDEndsWith>String</DB_DebtorSystemTemplates_RecIDEndsWith>
  <DB_DebtorSystemTemplates_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_DebtorSystemTemplates_RecIDIn>
  <DB_DebtorSystemTemplates_RecIDLike>String</DB_DebtorSystemTemplates_RecIDLike>
  <DB_DebtorSystemTemplates_RecIDStartsWith>String</DB_DebtorSystemTemplates_RecIDStartsWith>
  <DefaultValue>String</DefaultValue>
  <DefaultValueBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DefaultValueBetween>
  <DefaultValueContains>String</DefaultValueContains>
  <DefaultValueEndsWith>String</DefaultValueEndsWith>
  <DefaultValueIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DefaultValueIn>
  <DefaultValueLike>String</DefaultValueLike>
  <DefaultValueStartsWith>String</DefaultValueStartsWith>
  <FieldType>0</FieldType>
  <FieldTypeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </FieldTypeBetween>
  <FieldTypeGreaterThan>0</FieldTypeGreaterThan>
  <FieldTypeGreaterThanOrEqualTo>0</FieldTypeGreaterThanOrEqualTo>
  <FieldTypeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </FieldTypeIn>
  <FieldTypeLessThan>0</FieldTypeLessThan>
  <FieldTypeLessThanOrEqualTo>0</FieldTypeLessThanOrEqualTo>
  <FieldTypeNotEqualTo>0</FieldTypeNotEqualTo>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeBetween>
  <LastSavedDateTimeGreaterThan>0001-01-01T00:00:00</LastSavedDateTimeGreaterThan>
  <LastSavedDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeGreaterThanOrEqualTo>
  <LastSavedDateTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeIn>
  <LastSavedDateTimeLessThan>0001-01-01T00:00:00</LastSavedDateTimeLessThan>
  <LastSavedDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeLessThanOrEqualTo>
  <LastSavedDateTimeNotEqualTo>0001-01-01T00:00:00</LastSavedDateTimeNotEqualTo>
  <Name>String</Name>
  <NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameBetween>
  <NameContains>String</NameContains>
  <NameEndsWith>String</NameEndsWith>
  <NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameIn>
  <NameLike>String</NameLike>
  <NameStartsWith>String</NameStartsWith>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <RowHash>AA==</RowHash>
</DB_DebtorSystemTemplateFieldsQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfDB_DebtorSystemTemplateFields7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:DB_DebtorSystemTemplateFields>
      <d2p1:_x003C_ComboText_x003E_k__BackingField>String</d2p1:_x003C_ComboText_x003E_k__BackingField>
      <d2p1:_x003C_DB_DebtorSystemTemplates_RecID_x003E_k__BackingField>String</d2p1:_x003C_DB_DebtorSystemTemplates_RecID_x003E_k__BackingField>
      <d2p1:_x003C_DefaultValue_x003E_k__BackingField>String</d2p1:_x003C_DefaultValue_x003E_k__BackingField>
      <d2p1:_x003C_FieldType_x003E_k__BackingField>0</d2p1:_x003C_FieldType_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
    </d2p1:DB_DebtorSystemTemplateFields>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfDB_DebtorSystemTemplateFields7kRqkrSv>