JiwaAPI

<back to all web services

PR_ClassificationPricingQuery

Requires Authentication
PR_ClassificationPricingQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
DB_Classification_RecIDquerystringNo
DB_Classification_RecIDStartsWithquerystringNo
DB_Classification_RecIDEndsWithquerystringNo
DB_Classification_RecIDContainsquerystringNo
DB_Classification_RecIDLikequerystringNo
DB_Classification_RecIDBetweenquerystring[]No
DB_Classification_RecIDInquerystring[]No
IN_Classification_RecIDquerystringNo
IN_Classification_RecIDStartsWithquerystringNo
IN_Classification_RecIDEndsWithquerystringNo
IN_Classification_RecIDContainsquerystringNo
IN_Classification_RecIDLikequerystringNo
IN_Classification_RecIDBetweenquerystring[]No
IN_Classification_RecIDInquerystring[]No
Sourcequerybyte?No
SourceGreaterThanOrEqualToquerybyte?No
SourceGreaterThanquerybyte?No
SourceLessThanquerybyte?No
SourceLessThanOrEqualToquerybyte?No
SourceNotEqualToquerybyte?No
SourceBetweenquerybyte[]No
SourceInquerybyte[]No
Modequerybyte?No
ModeGreaterThanOrEqualToquerybyte?No
ModeGreaterThanquerybyte?No
ModeLessThanquerybyte?No
ModeLessThanOrEqualToquerybyte?No
ModeNotEqualToquerybyte?No
ModeBetweenquerybyte[]No
ModeInquerybyte[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenquerydecimal[]No
AmountInquerydecimal[]No
StartDatequeryDateTime?No
StartDateGreaterThanOrEqualToqueryDateTime?No
StartDateGreaterThanqueryDateTime?No
StartDateLessThanqueryDateTime?No
StartDateLessThanOrEqualToqueryDateTime?No
StartDateNotEqualToqueryDateTime?No
StartDateBetweenqueryDateTime[]No
StartDateInqueryDateTime[]No
EndDatequeryDateTime?No
EndDateGreaterThanOrEqualToqueryDateTime?No
EndDateGreaterThanqueryDateTime?No
EndDateLessThanqueryDateTime?No
EndDateLessThanOrEqualToqueryDateTime?No
EndDateNotEqualToqueryDateTime?No
EndDateBetweenqueryDateTime[]No
EndDateInqueryDateTime[]No
UseQuantityBreakquerybool?No
QuantityBreakquerydecimal?No
QuantityBreakGreaterThanOrEqualToquerydecimal?No
QuantityBreakGreaterThanquerydecimal?No
QuantityBreakLessThanquerydecimal?No
QuantityBreakLessThanOrEqualToquerydecimal?No
QuantityBreakNotEqualToquerydecimal?No
QuantityBreakBetweenquerydecimal[]No
QuantityBreakInquerydecimal[]No
RowHashquerybyte[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PR_ClassificationPricing Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
DB_Classification_RecIDformstringNo
IN_Classification_RecIDformstringNo
SourceformbyteNo
ModeformbyteNo
AmountformdecimalNo
StartDateformDateTimeNo
EndDateformDateTimeNo
UseQuantityBreakformboolNo
QuantityBreakformdecimalNo
RowHashformbyte[]No
ItemNoformintNo
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/PR_ClassificationPricingQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<PR_ClassificationPricingQuery 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>
  <Amount>0</Amount>
  <AmountBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountBetween>
  <AmountGreaterThan>0</AmountGreaterThan>
  <AmountGreaterThanOrEqualTo>0</AmountGreaterThanOrEqualTo>
  <AmountIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountIn>
  <AmountLessThan>0</AmountLessThan>
  <AmountLessThanOrEqualTo>0</AmountLessThanOrEqualTo>
  <AmountNotEqualTo>0</AmountNotEqualTo>
  <DB_Classification_RecID>String</DB_Classification_RecID>
  <DB_Classification_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_Classification_RecIDBetween>
  <DB_Classification_RecIDContains>String</DB_Classification_RecIDContains>
  <DB_Classification_RecIDEndsWith>String</DB_Classification_RecIDEndsWith>
  <DB_Classification_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DB_Classification_RecIDIn>
  <DB_Classification_RecIDLike>String</DB_Classification_RecIDLike>
  <DB_Classification_RecIDStartsWith>String</DB_Classification_RecIDStartsWith>
  <EndDate>0001-01-01T00:00:00</EndDate>
  <EndDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndDateBetween>
  <EndDateGreaterThan>0001-01-01T00:00:00</EndDateGreaterThan>
  <EndDateGreaterThanOrEqualTo>0001-01-01T00:00:00</EndDateGreaterThanOrEqualTo>
  <EndDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EndDateIn>
  <EndDateLessThan>0001-01-01T00:00:00</EndDateLessThan>
  <EndDateLessThanOrEqualTo>0001-01-01T00:00:00</EndDateLessThanOrEqualTo>
  <EndDateNotEqualTo>0001-01-01T00:00:00</EndDateNotEqualTo>
  <IN_Classification_RecID>String</IN_Classification_RecID>
  <IN_Classification_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Classification_RecIDBetween>
  <IN_Classification_RecIDContains>String</IN_Classification_RecIDContains>
  <IN_Classification_RecIDEndsWith>String</IN_Classification_RecIDEndsWith>
  <IN_Classification_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_Classification_RecIDIn>
  <IN_Classification_RecIDLike>String</IN_Classification_RecIDLike>
  <IN_Classification_RecIDStartsWith>String</IN_Classification_RecIDStartsWith>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <Mode>0</Mode>
  <ModeBetween>AA==</ModeBetween>
  <ModeGreaterThan>0</ModeGreaterThan>
  <ModeGreaterThanOrEqualTo>0</ModeGreaterThanOrEqualTo>
  <ModeIn>AA==</ModeIn>
  <ModeLessThan>0</ModeLessThan>
  <ModeLessThanOrEqualTo>0</ModeLessThanOrEqualTo>
  <ModeNotEqualTo>0</ModeNotEqualTo>
  <QuantityBreak>0</QuantityBreak>
  <QuantityBreakBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBreakBetween>
  <QuantityBreakGreaterThan>0</QuantityBreakGreaterThan>
  <QuantityBreakGreaterThanOrEqualTo>0</QuantityBreakGreaterThanOrEqualTo>
  <QuantityBreakIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBreakIn>
  <QuantityBreakLessThan>0</QuantityBreakLessThan>
  <QuantityBreakLessThanOrEqualTo>0</QuantityBreakLessThanOrEqualTo>
  <QuantityBreakNotEqualTo>0</QuantityBreakNotEqualTo>
  <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>
  <Source>0</Source>
  <SourceBetween>AA==</SourceBetween>
  <SourceGreaterThan>0</SourceGreaterThan>
  <SourceGreaterThanOrEqualTo>0</SourceGreaterThanOrEqualTo>
  <SourceIn>AA==</SourceIn>
  <SourceLessThan>0</SourceLessThan>
  <SourceLessThanOrEqualTo>0</SourceLessThanOrEqualTo>
  <SourceNotEqualTo>0</SourceNotEqualTo>
  <StartDate>0001-01-01T00:00:00</StartDate>
  <StartDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateBetween>
  <StartDateGreaterThan>0001-01-01T00:00:00</StartDateGreaterThan>
  <StartDateGreaterThanOrEqualTo>0001-01-01T00:00:00</StartDateGreaterThanOrEqualTo>
  <StartDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </StartDateIn>
  <StartDateLessThan>0001-01-01T00:00:00</StartDateLessThan>
  <StartDateLessThanOrEqualTo>0001-01-01T00:00:00</StartDateLessThanOrEqualTo>
  <StartDateNotEqualTo>0001-01-01T00:00:00</StartDateNotEqualTo>
  <UseQuantityBreak>false</UseQuantityBreak>
</PR_ClassificationPricingQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfPR_ClassificationPricing7kRqkrSv 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:PR_ClassificationPricing>
      <d2p1:_x003C_Amount_x003E_k__BackingField>0</d2p1:_x003C_Amount_x003E_k__BackingField>
      <d2p1:_x003C_DB_Classification_RecID_x003E_k__BackingField>String</d2p1:_x003C_DB_Classification_RecID_x003E_k__BackingField>
      <d2p1:_x003C_EndDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EndDate_x003E_k__BackingField>
      <d2p1:_x003C_IN_Classification_RecID_x003E_k__BackingField>String</d2p1:_x003C_IN_Classification_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Mode_x003E_k__BackingField>0</d2p1:_x003C_Mode_x003E_k__BackingField>
      <d2p1:_x003C_QuantityBreak_x003E_k__BackingField>0</d2p1:_x003C_QuantityBreak_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_Source_x003E_k__BackingField>0</d2p1:_x003C_Source_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>false</d2p1:_x003C_UseQuantityBreak_x003E_k__BackingField>
    </d2p1:PR_ClassificationPricing>
  </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>
</QueryResponseOfPR_ClassificationPricing7kRqkrSv>