JiwaAPI

CR_AutoTranLinesQuery

**CR_AutoTranLinesQuery** Parameters:
Name	Parameter	Data Type	Required
CRAutoTranLineID	query	string	No
CRAutoTranLineIDStartsWith	query	string	No
CRAutoTranLineIDEndsWith	query	string	No
CRAutoTranLineIDContains	query	string	No
CRAutoTranLineIDLike	query	string	No
CRAutoTranLineIDBetween	query	string[]	No
CRAutoTranLineIDIn	query	string[]	No
CRAutoTranID	query	string	No
CRAutoTranIDStartsWith	query	string	No
CRAutoTranIDEndsWith	query	string	No
CRAutoTranIDContains	query	string	No
CRAutoTranIDLike	query	string	No
CRAutoTranIDBetween	query	string[]	No
CRAutoTranIDIn	query	string[]	No
SourceCRBatchID	query	string	No
SourceCRBatchIDStartsWith	query	string	No
SourceCRBatchIDEndsWith	query	string	No
SourceCRBatchIDContains	query	string	No
SourceCRBatchIDLike	query	string	No
SourceCRBatchIDBetween	query	string[]	No
SourceCRBatchIDIn	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
DestCRBatchID	query	string	No
DestCRBatchIDStartsWith	query	string	No
DestCRBatchIDEndsWith	query	string	No
DestCRBatchIDContains	query	string	No
DestCRBatchIDLike	query	string	No
DestCRBatchIDBetween	query	string[]	No
DestCRBatchIDIn	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<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

**CR_AutoTranLines** Parameters:
Name	Parameter	Data Type	Required
CRAutoTranLineID	form	string	No
CRAutoTranID	form	string	No
SourceCRBatchID	form	string	No
SourceBatchNo	form	string	No
SourceReceiptType	form	short	No
SourceDesc	form	string	No
PostingDue	form	DateTime?	No
Reason	form	string	No
DestCRBatchID	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/CR_AutoTranLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<CR_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>
  <CRAutoTranID>String</CRAutoTranID>
  <CRAutoTranIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRAutoTranIDBetween>
  <CRAutoTranIDContains>String</CRAutoTranIDContains>
  <CRAutoTranIDEndsWith>String</CRAutoTranIDEndsWith>
  <CRAutoTranIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRAutoTranIDIn>
  <CRAutoTranIDLike>String</CRAutoTranIDLike>
  <CRAutoTranIDStartsWith>String</CRAutoTranIDStartsWith>
  <CRAutoTranLineID>String</CRAutoTranLineID>
  <CRAutoTranLineIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRAutoTranLineIDBetween>
  <CRAutoTranLineIDContains>String</CRAutoTranLineIDContains>
  <CRAutoTranLineIDEndsWith>String</CRAutoTranLineIDEndsWith>
  <CRAutoTranLineIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRAutoTranLineIDIn>
  <CRAutoTranLineIDLike>String</CRAutoTranLineIDLike>
  <CRAutoTranLineIDStartsWith>String</CRAutoTranLineIDStartsWith>
  <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>
  <DestCRBatchID>String</DestCRBatchID>
  <DestCRBatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestCRBatchIDBetween>
  <DestCRBatchIDContains>String</DestCRBatchIDContains>
  <DestCRBatchIDEndsWith>String</DestCRBatchIDEndsWith>
  <DestCRBatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DestCRBatchIDIn>
  <DestCRBatchIDLike>String</DestCRBatchIDLike>
  <DestCRBatchIDStartsWith>String</DestCRBatchIDStartsWith>
  <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>
  <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>
  <SourceCRBatchID>String</SourceCRBatchID>
  <SourceCRBatchIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceCRBatchIDBetween>
  <SourceCRBatchIDContains>String</SourceCRBatchIDContains>
  <SourceCRBatchIDEndsWith>String</SourceCRBatchIDEndsWith>
  <SourceCRBatchIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceCRBatchIDIn>
  <SourceCRBatchIDLike>String</SourceCRBatchIDLike>
  <SourceCRBatchIDStartsWith>String</SourceCRBatchIDStartsWith>
  <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>
</CR_AutoTranLinesQuery>

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

<QueryResponseOfCR_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:CR_AutoTranLines>
      <d2p1:_x003C_CRAutoTranID_x003E_k__BackingField>String</d2p1:_x003C_CRAutoTranID_x003E_k__BackingField>
      <d2p1:_x003C_CRAutoTranLineID_x003E_k__BackingField>String</d2p1:_x003C_CRAutoTranLineID_x003E_k__BackingField>
      <d2p1:_x003C_DestBatchNo_x003E_k__BackingField>String</d2p1:_x003C_DestBatchNo_x003E_k__BackingField>
      <d2p1:_x003C_DestCRBatchID_x003E_k__BackingField>String</d2p1:_x003C_DestCRBatchID_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_SourceCRBatchID_x003E_k__BackingField>String</d2p1:_x003C_SourceCRBatchID_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:CR_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>
</QueryResponseOfCR_AutoTranLines7kRqkrSv>