JiwaAPI

DB_AutoTranLinesQuery

**DB_AutoTranLinesQuery** Parameters:
Name	Parameter	Data Type	Required
DBAutoTranLineID	query	string	No
DBAutoTranLineIDStartsWith	query	string	No
DBAutoTranLineIDEndsWith	query	string	No
DBAutoTranLineIDContains	query	string	No
DBAutoTranLineIDLike	query	string	No
DBAutoTranLineIDBetween	query	string[]	No
DBAutoTranLineIDIn	query	string[]	No
DBAutoTranID	query	string	No
DBAutoTranIDStartsWith	query	string	No
DBAutoTranIDEndsWith	query	string	No
DBAutoTranIDContains	query	string	No
DBAutoTranIDLike	query	string	No
DBAutoTranIDBetween	query	string[]	No
DBAutoTranIDIn	query	string[]	No
SourceDBBatchID	query	string	No
SourceDBBatchIDStartsWith	query	string	No
SourceDBBatchIDEndsWith	query	string	No
SourceDBBatchIDContains	query	string	No
SourceDBBatchIDLike	query	string	No
SourceDBBatchIDBetween	query	string[]	No
SourceDBBatchIDIn	query	string[]	No
SourceBatchNo	query	string	No
SourceBatchNoStartsWith	query	string	No
SourceBatchNoEndsWith	query	string	No
SourceBatchNoContains	query	string	No
SourceBatchNoLike	query	string	No
SourceBatchNoBetween	query	string[]	No
SourceBatchNoIn	query	string[]	No
SourceReceiptType	query	short?	No
SourceReceiptTypeGreaterThanOrEqualTo	query	short?	No
SourceReceiptTypeGreaterThan	query	short?	No
SourceReceiptTypeLessThan	query	short?	No
SourceReceiptTypeLessThanOrEqualTo	query	short?	No
SourceReceiptTypeNotEqualTo	query	short?	No
SourceReceiptTypeBetween	query	short[]	No
SourceReceiptTypeIn	query	short[]	No
SourceDesc	query	string	No
SourceDescStartsWith	query	string	No
SourceDescEndsWith	query	string	No
SourceDescContains	query	string	No
SourceDescLike	query	string	No
SourceDescBetween	query	string[]	No
SourceDescIn	query	string[]	No
PostingDue	query	DateTime?	No
PostingDueGreaterThanOrEqualTo	query	DateTime?	No
PostingDueGreaterThan	query	DateTime?	No
PostingDueLessThan	query	DateTime?	No
PostingDueLessThanOrEqualTo	query	DateTime?	No
PostingDueNotEqualTo	query	DateTime?	No
PostingDueBetween	query	Nullable<DateTime>[]	No
PostingDueIn	query	Nullable<DateTime>[]	No
Reason	query	string	No
ReasonStartsWith	query	string	No
ReasonEndsWith	query	string	No
ReasonContains	query	string	No
ReasonLike	query	string	No
ReasonBetween	query	string[]	No
ReasonIn	query	string[]	No
DestDBBatchID	query	string	No
DestDBBatchIDStartsWith	query	string	No
DestDBBatchIDEndsWith	query	string	No
DestDBBatchIDContains	query	string	No
DestDBBatchIDLike	query	string	No
DestDBBatchIDBetween	query	string[]	No
DestDBBatchIDIn	query	string[]	No
DestBatchNo	query	string	No
DestBatchNoStartsWith	query	string	No
DestBatchNoEndsWith	query	string	No
DestBatchNoContains	query	string	No
DestBatchNoLike	query	string	No
DestBatchNoBetween	query	string[]	No
DestBatchNoIn	query	string[]	No
LineNum	query	short?	No
LineNumGreaterThanOrEqualTo	query	short?	No
LineNumGreaterThan	query	short?	No
LineNumLessThan	query	short?	No
LineNumLessThanOrEqualTo	query	short?	No
LineNumNotEqualTo	query	short?	No
LineNumBetween	query	short[]	No
LineNumIn	query	short[]	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	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	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_AutoTranLines** Parameters:
Name	Parameter	Data Type	Required
DBAutoTranLineID	form	string	No
DBAutoTranID	form	string	No
SourceDBBatchID	form	string	No
SourceBatchNo	form	string	No
SourceReceiptType	form	short	No
SourceDesc	form	string	No
PostingDue	form	DateTime?	No
Reason	form	string	No
DestDBBatchID	form	string	No
DestBatchNo	form	string	No
LineNum	form	short	No
LastSavedDateTime	form	DateTime	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_AutoTranLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<DB_AutoTranLinesQuery 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>
  <DBAutoTranID>String</DBAutoTranID>
  <DBAutoTranIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAutoTranIDBetween>
  <DBAutoTranIDContains>String</DBAutoTranIDContains>
  <DBAutoTranIDEndsWith>String</DBAutoTranIDEndsWith>
  <DBAutoTranIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAutoTranIDIn>
  <DBAutoTranIDLike>String</DBAutoTranIDLike>
  <DBAutoTranIDStartsWith>String</DBAutoTranIDStartsWith>
  <DBAutoTranLineID>String</DBAutoTranLineID>
  <DBAutoTranLineIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAutoTranLineIDBetween>
  <DBAutoTranLineIDContains>String</DBAutoTranLineIDContains>
  <DBAutoTranLineIDEndsWith>String</DBAutoTranLineIDEndsWith>
  <DBAutoTranLineIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DBAutoTranLineIDIn>
  <DBAutoTranLineIDLike>String</DBAutoTranLineIDLike>
  <DBAutoTranLineIDStartsWith>String</DBAutoTranLineIDStartsWith>
  <DestBatchNo>String</DestBatchNo>
  <DestBatchNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestBatchNoBetween>
  <DestBatchNoContains>String</DestBatchNoContains>
  <DestBatchNoEndsWith>String</DestBatchNoEndsWith>
  <DestBatchNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestBatchNoIn>
  <DestBatchNoLike>String</DestBatchNoLike>
  <DestBatchNoStartsWith>String</DestBatchNoStartsWith>
  <DestDBBatchID>String</DestDBBatchID>
  <DestDBBatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestDBBatchIDBetween>
  <DestDBBatchIDContains>String</DestDBBatchIDContains>
  <DestDBBatchIDEndsWith>String</DestDBBatchIDEndsWith>
  <DestDBBatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestDBBatchIDIn>
  <DestDBBatchIDLike>String</DestDBBatchIDLike>
  <DestDBBatchIDStartsWith>String</DestDBBatchIDStartsWith>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <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.microsoft.com/2003/10/Serialization/Arrays">
    <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>
  <LineNum>0</LineNum>
  <LineNumBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </LineNumBetween>
  <LineNumGreaterThan>0</LineNumGreaterThan>
  <LineNumGreaterThanOrEqualTo>0</LineNumGreaterThanOrEqualTo>
  <LineNumIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </LineNumIn>
  <LineNumLessThan>0</LineNumLessThan>
  <LineNumLessThanOrEqualTo>0</LineNumLessThanOrEqualTo>
  <LineNumNotEqualTo>0</LineNumNotEqualTo>
  <PostingDue>0001-01-01T00:00:00</PostingDue>
  <PostingDueBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </PostingDueBetween>
  <PostingDueGreaterThan>0001-01-01T00:00:00</PostingDueGreaterThan>
  <PostingDueGreaterThanOrEqualTo>0001-01-01T00:00:00</PostingDueGreaterThanOrEqualTo>
  <PostingDueIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </PostingDueIn>
  <PostingDueLessThan>0001-01-01T00:00:00</PostingDueLessThan>
  <PostingDueLessThanOrEqualTo>0001-01-01T00:00:00</PostingDueLessThanOrEqualTo>
  <PostingDueNotEqualTo>0001-01-01T00:00:00</PostingDueNotEqualTo>
  <Reason>String</Reason>
  <ReasonBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReasonBetween>
  <ReasonContains>String</ReasonContains>
  <ReasonEndsWith>String</ReasonEndsWith>
  <ReasonIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReasonIn>
  <ReasonLike>String</ReasonLike>
  <ReasonStartsWith>String</ReasonStartsWith>
  <SourceBatchNo>String</SourceBatchNo>
  <SourceBatchNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceBatchNoBetween>
  <SourceBatchNoContains>String</SourceBatchNoContains>
  <SourceBatchNoEndsWith>String</SourceBatchNoEndsWith>
  <SourceBatchNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceBatchNoIn>
  <SourceBatchNoLike>String</SourceBatchNoLike>
  <SourceBatchNoStartsWith>String</SourceBatchNoStartsWith>
  <SourceDBBatchID>String</SourceDBBatchID>
  <SourceDBBatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceDBBatchIDBetween>
  <SourceDBBatchIDContains>String</SourceDBBatchIDContains>
  <SourceDBBatchIDEndsWith>String</SourceDBBatchIDEndsWith>
  <SourceDBBatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceDBBatchIDIn>
  <SourceDBBatchIDLike>String</SourceDBBatchIDLike>
  <SourceDBBatchIDStartsWith>String</SourceDBBatchIDStartsWith>
  <SourceDesc>String</SourceDesc>
  <SourceDescBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceDescBetween>
  <SourceDescContains>String</SourceDescContains>
  <SourceDescEndsWith>String</SourceDescEndsWith>
  <SourceDescIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceDescIn>
  <SourceDescLike>String</SourceDescLike>
  <SourceDescStartsWith>String</SourceDescStartsWith>
  <SourceReceiptType>0</SourceReceiptType>
  <SourceReceiptTypeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </SourceReceiptTypeBetween>
  <SourceReceiptTypeGreaterThan>0</SourceReceiptTypeGreaterThan>
  <SourceReceiptTypeGreaterThanOrEqualTo>0</SourceReceiptTypeGreaterThanOrEqualTo>
  <SourceReceiptTypeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:short>0</d2p1:short>
  </SourceReceiptTypeIn>
  <SourceReceiptTypeLessThan>0</SourceReceiptTypeLessThan>
  <SourceReceiptTypeLessThanOrEqualTo>0</SourceReceiptTypeLessThanOrEqualTo>
  <SourceReceiptTypeNotEqualTo>0</SourceReceiptTypeNotEqualTo>
</DB_AutoTranLinesQuery>

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

<QueryResponseOfDB_AutoTranLines7kRqkrSv 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_AutoTranLines>
      <d2p1:_x003C_DBAutoTranID_x003E_k__BackingField>String</d2p1:_x003C_DBAutoTranID_x003E_k__BackingField>
      <d2p1:_x003C_DBAutoTranLineID_x003E_k__BackingField>String</d2p1:_x003C_DBAutoTranLineID_x003E_k__BackingField>
      <d2p1:_x003C_DestBatchNo_x003E_k__BackingField>String</d2p1:_x003C_DestBatchNo_x003E_k__BackingField>
      <d2p1:_x003C_DestDBBatchID_x003E_k__BackingField>String</d2p1:_x003C_DestDBBatchID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LineNum_x003E_k__BackingField>0</d2p1:_x003C_LineNum_x003E_k__BackingField>
      <d2p1:_x003C_PostingDue_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_PostingDue_x003E_k__BackingField>
      <d2p1:_x003C_Reason_x003E_k__BackingField>String</d2p1:_x003C_Reason_x003E_k__BackingField>
      <d2p1:_x003C_SourceBatchNo_x003E_k__BackingField>String</d2p1:_x003C_SourceBatchNo_x003E_k__BackingField>
      <d2p1:_x003C_SourceDBBatchID_x003E_k__BackingField>String</d2p1:_x003C_SourceDBBatchID_x003E_k__BackingField>
      <d2p1:_x003C_SourceDesc_x003E_k__BackingField>String</d2p1:_x003C_SourceDesc_x003E_k__BackingField>
      <d2p1:_x003C_SourceReceiptType_x003E_k__BackingField>0</d2p1:_x003C_SourceReceiptType_x003E_k__BackingField>
    </d2p1:DB_AutoTranLines>
  </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_AutoTranLines7kRqkrSv>