Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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
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: api.jiwa.com.au
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>