JiwaAPI

CR_ForwardCoverTransactionsQuery

**CR_ForwardCoverTransactionsQuery** 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
CR_ForwardCover_RecID	query	string	No
CR_ForwardCover_RecIDStartsWith	query	string	No
CR_ForwardCover_RecIDEndsWith	query	string	No
CR_ForwardCover_RecIDContains	query	string	No
CR_ForwardCover_RecIDLike	query	string	No
CR_ForwardCover_RecIDBetween	query	string[]	No
CR_ForwardCover_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	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
TransactionDate	query	DateTime?	No
TransactionDateGreaterThanOrEqualTo	query	DateTime?	No
TransactionDateGreaterThan	query	DateTime?	No
TransactionDateLessThan	query	DateTime?	No
TransactionDateLessThanOrEqualTo	query	DateTime?	No
TransactionDateNotEqualTo	query	DateTime?	No
TransactionDateBetween	query	DateTime[]	No
TransactionDateIn	query	DateTime[]	No
FXAmount	query	decimal?	No
FXAmountGreaterThanOrEqualTo	query	decimal?	No
FXAmountGreaterThan	query	decimal?	No
FXAmountLessThan	query	decimal?	No
FXAmountLessThanOrEqualTo	query	decimal?	No
FXAmountNotEqualTo	query	decimal?	No
FXAmountBetween	query	decimal[]	No
FXAmountIn	query	decimal[]	No
HomeAmount	query	decimal?	No
HomeAmountGreaterThanOrEqualTo	query	decimal?	No
HomeAmountGreaterThan	query	decimal?	No
HomeAmountLessThan	query	decimal?	No
HomeAmountLessThanOrEqualTo	query	decimal?	No
HomeAmountNotEqualTo	query	decimal?	No
HomeAmountBetween	query	decimal[]	No
HomeAmountIn	query	decimal[]	No
SourceType	query	byte?	No
SourceTypeGreaterThanOrEqualTo	query	byte?	No
SourceTypeGreaterThan	query	byte?	No
SourceTypeLessThan	query	byte?	No
SourceTypeLessThanOrEqualTo	query	byte?	No
SourceTypeNotEqualTo	query	byte?	No
SourceTypeBetween	query	byte[]	No
SourceTypeIn	query	byte[]	No
SourceID	query	string	No
SourceIDStartsWith	query	string	No
SourceIDEndsWith	query	string	No
SourceIDContains	query	string	No
SourceIDLike	query	string	No
SourceIDBetween	query	string[]	No
SourceIDIn	query	string[]	No
SourceReference	query	string	No
SourceReferenceStartsWith	query	string	No
SourceReferenceEndsWith	query	string	No
SourceReferenceContains	query	string	No
SourceReferenceLike	query	string	No
SourceReferenceBetween	query	string[]	No
SourceReferenceIn	query	string[]	No
CRTrans_RecID	query	string	No
CRTrans_RecIDStartsWith	query	string	No
CRTrans_RecIDEndsWith	query	string	No
CRTrans_RecIDContains	query	string	No
CRTrans_RecIDLike	query	string	No
CRTrans_RecIDBetween	query	string[]	No
CRTrans_RecIDIn	query	string[]	No
TransactionType	query	byte?	No
TransactionTypeGreaterThanOrEqualTo	query	byte?	No
TransactionTypeGreaterThan	query	byte?	No
TransactionTypeLessThan	query	byte?	No
TransactionTypeLessThanOrEqualTo	query	byte?	No
TransactionTypeNotEqualTo	query	byte?	No
TransactionTypeBetween	query	byte[]	No
TransactionTypeIn	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

**CR_ForwardCoverTransactions** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
CR_ForwardCover_RecID	form	string	No
LastSavedDateTime	form	DateTime	No
TransactionDate	form	DateTime	No
FXAmount	form	decimal	No
HomeAmount	form	decimal	No
SourceType	form	byte	No
SourceID	form	string	No
SourceReference	form	string	No
CRTrans_RecID	form	string	No
TransactionType	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/CR_ForwardCoverTransactionsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<CR_ForwardCoverTransactionsQuery 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>
  <CRTrans_RecID>String</CRTrans_RecID>
  <CRTrans_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRTrans_RecIDBetween>
  <CRTrans_RecIDContains>String</CRTrans_RecIDContains>
  <CRTrans_RecIDEndsWith>String</CRTrans_RecIDEndsWith>
  <CRTrans_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CRTrans_RecIDIn>
  <CRTrans_RecIDLike>String</CRTrans_RecIDLike>
  <CRTrans_RecIDStartsWith>String</CRTrans_RecIDStartsWith>
  <CR_ForwardCover_RecID>String</CR_ForwardCover_RecID>
  <CR_ForwardCover_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CR_ForwardCover_RecIDBetween>
  <CR_ForwardCover_RecIDContains>String</CR_ForwardCover_RecIDContains>
  <CR_ForwardCover_RecIDEndsWith>String</CR_ForwardCover_RecIDEndsWith>
  <CR_ForwardCover_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CR_ForwardCover_RecIDIn>
  <CR_ForwardCover_RecIDLike>String</CR_ForwardCover_RecIDLike>
  <CR_ForwardCover_RecIDStartsWith>String</CR_ForwardCover_RecIDStartsWith>
  <FXAmount>0</FXAmount>
  <FXAmountBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAmountBetween>
  <FXAmountGreaterThan>0</FXAmountGreaterThan>
  <FXAmountGreaterThanOrEqualTo>0</FXAmountGreaterThanOrEqualTo>
  <FXAmountIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </FXAmountIn>
  <FXAmountLessThan>0</FXAmountLessThan>
  <FXAmountLessThanOrEqualTo>0</FXAmountLessThanOrEqualTo>
  <FXAmountNotEqualTo>0</FXAmountNotEqualTo>
  <HomeAmount>0</HomeAmount>
  <HomeAmountBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </HomeAmountBetween>
  <HomeAmountGreaterThan>0</HomeAmountGreaterThan>
  <HomeAmountGreaterThanOrEqualTo>0</HomeAmountGreaterThanOrEqualTo>
  <HomeAmountIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </HomeAmountIn>
  <HomeAmountLessThan>0</HomeAmountLessThan>
  <HomeAmountLessThanOrEqualTo>0</HomeAmountLessThanOrEqualTo>
  <HomeAmountNotEqualTo>0</HomeAmountNotEqualTo>
  <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>
  <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>
  <SourceID>String</SourceID>
  <SourceIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDBetween>
  <SourceIDContains>String</SourceIDContains>
  <SourceIDEndsWith>String</SourceIDEndsWith>
  <SourceIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceIDIn>
  <SourceIDLike>String</SourceIDLike>
  <SourceIDStartsWith>String</SourceIDStartsWith>
  <SourceReference>String</SourceReference>
  <SourceReferenceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceReferenceBetween>
  <SourceReferenceContains>String</SourceReferenceContains>
  <SourceReferenceEndsWith>String</SourceReferenceEndsWith>
  <SourceReferenceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SourceReferenceIn>
  <SourceReferenceLike>String</SourceReferenceLike>
  <SourceReferenceStartsWith>String</SourceReferenceStartsWith>
  <SourceType>0</SourceType>
  <SourceTypeBetween>AA==</SourceTypeBetween>
  <SourceTypeGreaterThan>0</SourceTypeGreaterThan>
  <SourceTypeGreaterThanOrEqualTo>0</SourceTypeGreaterThanOrEqualTo>
  <SourceTypeIn>AA==</SourceTypeIn>
  <SourceTypeLessThan>0</SourceTypeLessThan>
  <SourceTypeLessThanOrEqualTo>0</SourceTypeLessThanOrEqualTo>
  <SourceTypeNotEqualTo>0</SourceTypeNotEqualTo>
  <TransactionDate>0001-01-01T00:00:00</TransactionDate>
  <TransactionDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateBetween>
  <TransactionDateGreaterThan>0001-01-01T00:00:00</TransactionDateGreaterThan>
  <TransactionDateGreaterThanOrEqualTo>0001-01-01T00:00:00</TransactionDateGreaterThanOrEqualTo>
  <TransactionDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateIn>
  <TransactionDateLessThan>0001-01-01T00:00:00</TransactionDateLessThan>
  <TransactionDateLessThanOrEqualTo>0001-01-01T00:00:00</TransactionDateLessThanOrEqualTo>
  <TransactionDateNotEqualTo>0001-01-01T00:00:00</TransactionDateNotEqualTo>
  <TransactionType>0</TransactionType>
  <TransactionTypeBetween>AA==</TransactionTypeBetween>
  <TransactionTypeGreaterThan>0</TransactionTypeGreaterThan>
  <TransactionTypeGreaterThanOrEqualTo>0</TransactionTypeGreaterThanOrEqualTo>
  <TransactionTypeIn>AA==</TransactionTypeIn>
  <TransactionTypeLessThan>0</TransactionTypeLessThan>
  <TransactionTypeLessThanOrEqualTo>0</TransactionTypeLessThanOrEqualTo>
  <TransactionTypeNotEqualTo>0</TransactionTypeNotEqualTo>
</CR_ForwardCoverTransactionsQuery>

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

<QueryResponseOfCR_ForwardCoverTransactions7kRqkrSv 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_ForwardCoverTransactions>
      <d2p1:_x003C_CRTrans_RecID_x003E_k__BackingField>String</d2p1:_x003C_CRTrans_RecID_x003E_k__BackingField>
      <d2p1:_x003C_CR_ForwardCover_RecID_x003E_k__BackingField>String</d2p1:_x003C_CR_ForwardCover_RecID_x003E_k__BackingField>
      <d2p1:_x003C_FXAmount_x003E_k__BackingField>0</d2p1:_x003C_FXAmount_x003E_k__BackingField>
      <d2p1:_x003C_HomeAmount_x003E_k__BackingField>0</d2p1:_x003C_HomeAmount_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SourceID_x003E_k__BackingField>String</d2p1:_x003C_SourceID_x003E_k__BackingField>
      <d2p1:_x003C_SourceReference_x003E_k__BackingField>String</d2p1:_x003C_SourceReference_x003E_k__BackingField>
      <d2p1:_x003C_SourceType_x003E_k__BackingField>0</d2p1:_x003C_SourceType_x003E_k__BackingField>
      <d2p1:_x003C_TransactionDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransactionDate_x003E_k__BackingField>
      <d2p1:_x003C_TransactionType_x003E_k__BackingField>0</d2p1:_x003C_TransactionType_x003E_k__BackingField>
    </d2p1:CR_ForwardCoverTransactions>
  </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_ForwardCoverTransactions7kRqkrSv>