JiwaAPI

<back to all web services

CR_AutoTranQuery

Requires Authentication
CR_AutoTranQuery Parameters:
NameParameterData TypeRequiredDescription
CRAutoTranIDquerystringNo
CRAutoTranIDStartsWithquerystringNo
CRAutoTranIDEndsWithquerystringNo
CRAutoTranIDContainsquerystringNo
CRAutoTranIDLikequerystringNo
CRAutoTranIDBetweenquerystring[]No
CRAutoTranIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
RunDateTimequeryDateTime?No
RunDateTimeGreaterThanOrEqualToqueryDateTime?No
RunDateTimeGreaterThanqueryDateTime?No
RunDateTimeLessThanqueryDateTime?No
RunDateTimeLessThanOrEqualToqueryDateTime?No
RunDateTimeNotEqualToqueryDateTime?No
RunDateTimeBetweenqueryNullable<DateTime>[]No
RunDateTimeInqueryNullable<DateTime>[]No
UserNamequerystringNo
UserNameStartsWithquerystringNo
UserNameEndsWithquerystringNo
UserNameContainsquerystringNo
UserNameLikequerystringNo
UserNameBetweenquerystring[]No
UserNameInquerystring[]No
RunNoquerystringNo
RunNoStartsWithquerystringNo
RunNoEndsWithquerystringNo
RunNoContainsquerystringNo
RunNoLikequerystringNo
RunNoBetweenquerystring[]No
RunNoInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
CR_AutoTran Parameters:
NameParameterData TypeRequiredDescription
CRAutoTranIDformstringNo
LastSavedDateTimeformDateTime?No
RunDateTimeformDateTime?No
UserNameformstringNo
RunNoformstringNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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_AutoTranQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<CR_AutoTranQuery 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>
  <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>
  <RunDateTime>0001-01-01T00:00:00</RunDateTime>
  <RunDateTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </RunDateTimeBetween>
  <RunDateTimeGreaterThan>0001-01-01T00:00:00</RunDateTimeGreaterThan>
  <RunDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</RunDateTimeGreaterThanOrEqualTo>
  <RunDateTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </RunDateTimeIn>
  <RunDateTimeLessThan>0001-01-01T00:00:00</RunDateTimeLessThan>
  <RunDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</RunDateTimeLessThanOrEqualTo>
  <RunDateTimeNotEqualTo>0001-01-01T00:00:00</RunDateTimeNotEqualTo>
  <RunNo>String</RunNo>
  <RunNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RunNoBetween>
  <RunNoContains>String</RunNoContains>
  <RunNoEndsWith>String</RunNoEndsWith>
  <RunNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RunNoIn>
  <RunNoLike>String</RunNoLike>
  <RunNoStartsWith>String</RunNoStartsWith>
  <UserName>String</UserName>
  <UserNameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserNameBetween>
  <UserNameContains>String</UserNameContains>
  <UserNameEndsWith>String</UserNameEndsWith>
  <UserNameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UserNameIn>
  <UserNameLike>String</UserNameLike>
  <UserNameStartsWith>String</UserNameStartsWith>
</CR_AutoTranQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfCR_AutoTran7kRqkrSv 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_AutoTran>
      <d2p1:_x003C_CRAutoTranID_x003E_k__BackingField>String</d2p1:_x003C_CRAutoTranID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_RunDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_RunDateTime_x003E_k__BackingField>
      <d2p1:_x003C_RunNo_x003E_k__BackingField>String</d2p1:_x003C_RunNo_x003E_k__BackingField>
      <d2p1:_x003C_UserName_x003E_k__BackingField>String</d2p1:_x003C_UserName_x003E_k__BackingField>
    </d2p1:CR_AutoTran>
  </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_AutoTran7kRqkrSv>