JiwaAPI

<back to all web services

SM_CashSaleQuery

Requires Authentication
SM_CashSaleQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SM_Tasks_RecIDquerystringNo
SM_Tasks_RecIDStartsWithquerystringNo
SM_Tasks_RecIDEndsWithquerystringNo
SM_Tasks_RecIDContainsquerystringNo
SM_Tasks_RecIDLikequerystringNo
SM_Tasks_RecIDBetweenquerystring[]No
SM_Tasks_RecIDInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
CompanyquerystringNo
CompanyStartsWithquerystringNo
CompanyEndsWithquerystringNo
CompanyContainsquerystringNo
CompanyLikequerystringNo
CompanyBetweenquerystring[]No
CompanyInquerystring[]No
Address1querystringNo
Address1StartsWithquerystringNo
Address1EndsWithquerystringNo
Address1ContainsquerystringNo
Address1LikequerystringNo
Address1Betweenquerystring[]No
Address1Inquerystring[]No
Address2querystringNo
Address2StartsWithquerystringNo
Address2EndsWithquerystringNo
Address2ContainsquerystringNo
Address2LikequerystringNo
Address2Betweenquerystring[]No
Address2Inquerystring[]No
Address3querystringNo
Address3StartsWithquerystringNo
Address3EndsWithquerystringNo
Address3ContainsquerystringNo
Address3LikequerystringNo
Address3Betweenquerystring[]No
Address3Inquerystring[]No
Address4querystringNo
Address4StartsWithquerystringNo
Address4EndsWithquerystringNo
Address4ContainsquerystringNo
Address4LikequerystringNo
Address4Betweenquerystring[]No
Address4Inquerystring[]No
PostCodequerystringNo
PostCodeStartsWithquerystringNo
PostCodeEndsWithquerystringNo
PostCodeContainsquerystringNo
PostCodeLikequerystringNo
PostCodeBetweenquerystring[]No
PostCodeInquerystring[]No
PhonequerystringNo
PhoneStartsWithquerystringNo
PhoneEndsWithquerystringNo
PhoneContainsquerystringNo
PhoneLikequerystringNo
PhoneBetweenquerystring[]No
PhoneInquerystring[]No
FaxquerystringNo
FaxStartsWithquerystringNo
FaxEndsWithquerystringNo
FaxContainsquerystringNo
FaxLikequerystringNo
FaxBetweenquerystring[]No
FaxInquerystring[]No
ContactNamequerystringNo
ContactNameStartsWithquerystringNo
ContactNameEndsWithquerystringNo
ContactNameContainsquerystringNo
ContactNameLikequerystringNo
ContactNameBetweenquerystring[]No
ContactNameInquerystring[]No
RowHashquerybyte[]No
CountryquerystringNo
CountryStartsWithquerystringNo
CountryEndsWithquerystringNo
CountryContainsquerystringNo
CountryLikequerystringNo
CountryBetweenquerystring[]No
CountryInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_CashSale Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SM_Tasks_RecIDformstringNo
NameformstringNo
CompanyformstringNo
Address1formstringNo
Address2formstringNo
Address3formstringNo
Address4formstringNo
PostCodeformstringNo
PhoneformstringNo
FaxformstringNo
ContactNameformstringNo
RowHashformbyte[]No
CountryformstringNo
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/SM_CashSaleQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_CashSaleQuery 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>
  <Address1>String</Address1>
  <Address1Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address1Between>
  <Address1Contains>String</Address1Contains>
  <Address1EndsWith>String</Address1EndsWith>
  <Address1In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address1In>
  <Address1Like>String</Address1Like>
  <Address1StartsWith>String</Address1StartsWith>
  <Address2>String</Address2>
  <Address2Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address2Between>
  <Address2Contains>String</Address2Contains>
  <Address2EndsWith>String</Address2EndsWith>
  <Address2In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address2In>
  <Address2Like>String</Address2Like>
  <Address2StartsWith>String</Address2StartsWith>
  <Address3>String</Address3>
  <Address3Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address3Between>
  <Address3Contains>String</Address3Contains>
  <Address3EndsWith>String</Address3EndsWith>
  <Address3In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address3In>
  <Address3Like>String</Address3Like>
  <Address3StartsWith>String</Address3StartsWith>
  <Address4>String</Address4>
  <Address4Between xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address4Between>
  <Address4Contains>String</Address4Contains>
  <Address4EndsWith>String</Address4EndsWith>
  <Address4In xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Address4In>
  <Address4Like>String</Address4Like>
  <Address4StartsWith>String</Address4StartsWith>
  <Company>String</Company>
  <CompanyBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CompanyBetween>
  <CompanyContains>String</CompanyContains>
  <CompanyEndsWith>String</CompanyEndsWith>
  <CompanyIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CompanyIn>
  <CompanyLike>String</CompanyLike>
  <CompanyStartsWith>String</CompanyStartsWith>
  <ContactName>String</ContactName>
  <ContactNameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ContactNameBetween>
  <ContactNameContains>String</ContactNameContains>
  <ContactNameEndsWith>String</ContactNameEndsWith>
  <ContactNameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ContactNameIn>
  <ContactNameLike>String</ContactNameLike>
  <ContactNameStartsWith>String</ContactNameStartsWith>
  <Country>String</Country>
  <CountryBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CountryBetween>
  <CountryContains>String</CountryContains>
  <CountryEndsWith>String</CountryEndsWith>
  <CountryIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CountryIn>
  <CountryLike>String</CountryLike>
  <CountryStartsWith>String</CountryStartsWith>
  <Fax>String</Fax>
  <FaxBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FaxBetween>
  <FaxContains>String</FaxContains>
  <FaxEndsWith>String</FaxEndsWith>
  <FaxIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FaxIn>
  <FaxLike>String</FaxLike>
  <FaxStartsWith>String</FaxStartsWith>
  <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>
  <Phone>String</Phone>
  <PhoneBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PhoneBetween>
  <PhoneContains>String</PhoneContains>
  <PhoneEndsWith>String</PhoneEndsWith>
  <PhoneIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PhoneIn>
  <PhoneLike>String</PhoneLike>
  <PhoneStartsWith>String</PhoneStartsWith>
  <PostCode>String</PostCode>
  <PostCodeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PostCodeBetween>
  <PostCodeContains>String</PostCodeContains>
  <PostCodeEndsWith>String</PostCodeEndsWith>
  <PostCodeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PostCodeIn>
  <PostCodeLike>String</PostCodeLike>
  <PostCodeStartsWith>String</PostCodeStartsWith>
  <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>
  <SM_Tasks_RecID>String</SM_Tasks_RecID>
  <SM_Tasks_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDBetween>
  <SM_Tasks_RecIDContains>String</SM_Tasks_RecIDContains>
  <SM_Tasks_RecIDEndsWith>String</SM_Tasks_RecIDEndsWith>
  <SM_Tasks_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDIn>
  <SM_Tasks_RecIDLike>String</SM_Tasks_RecIDLike>
  <SM_Tasks_RecIDStartsWith>String</SM_Tasks_RecIDStartsWith>
</SM_CashSaleQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSM_CashSale7kRqkrSv 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:SM_CashSale>
      <d2p1:_x003C_Address1_x003E_k__BackingField>String</d2p1:_x003C_Address1_x003E_k__BackingField>
      <d2p1:_x003C_Address2_x003E_k__BackingField>String</d2p1:_x003C_Address2_x003E_k__BackingField>
      <d2p1:_x003C_Address3_x003E_k__BackingField>String</d2p1:_x003C_Address3_x003E_k__BackingField>
      <d2p1:_x003C_Address4_x003E_k__BackingField>String</d2p1:_x003C_Address4_x003E_k__BackingField>
      <d2p1:_x003C_Company_x003E_k__BackingField>String</d2p1:_x003C_Company_x003E_k__BackingField>
      <d2p1:_x003C_ContactName_x003E_k__BackingField>String</d2p1:_x003C_ContactName_x003E_k__BackingField>
      <d2p1:_x003C_Country_x003E_k__BackingField>String</d2p1:_x003C_Country_x003E_k__BackingField>
      <d2p1:_x003C_Fax_x003E_k__BackingField>String</d2p1:_x003C_Fax_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_Phone_x003E_k__BackingField>String</d2p1:_x003C_Phone_x003E_k__BackingField>
      <d2p1:_x003C_PostCode_x003E_k__BackingField>String</d2p1:_x003C_PostCode_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:_x003C_SM_Tasks_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>
    </d2p1:SM_CashSale>
  </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>
</QueryResponseOfSM_CashSale7kRqkrSv>