JiwaAPI

PR_ClassificationPricingQuery

**PR_ClassificationPricingQuery** 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
DB_Classification_RecID	query	string	No
DB_Classification_RecIDStartsWith	query	string	No
DB_Classification_RecIDEndsWith	query	string	No
DB_Classification_RecIDContains	query	string	No
DB_Classification_RecIDLike	query	string	No
DB_Classification_RecIDBetween	query	string[]	No
DB_Classification_RecIDIn	query	string[]	No
IN_Classification_RecID	query	string	No
IN_Classification_RecIDStartsWith	query	string	No
IN_Classification_RecIDEndsWith	query	string	No
IN_Classification_RecIDContains	query	string	No
IN_Classification_RecIDLike	query	string	No
IN_Classification_RecIDBetween	query	string[]	No
IN_Classification_RecIDIn	query	string[]	No
Source	query	byte?	No
SourceGreaterThanOrEqualTo	query	byte?	No
SourceGreaterThan	query	byte?	No
SourceLessThan	query	byte?	No
SourceLessThanOrEqualTo	query	byte?	No
SourceNotEqualTo	query	byte?	No
SourceBetween	query	byte[]	No
SourceIn	query	byte[]	No
Mode	query	byte?	No
ModeGreaterThanOrEqualTo	query	byte?	No
ModeGreaterThan	query	byte?	No
ModeLessThan	query	byte?	No
ModeLessThanOrEqualTo	query	byte?	No
ModeNotEqualTo	query	byte?	No
ModeBetween	query	byte[]	No
ModeIn	query	byte[]	No
Amount	query	decimal?	No
AmountGreaterThanOrEqualTo	query	decimal?	No
AmountGreaterThan	query	decimal?	No
AmountLessThan	query	decimal?	No
AmountLessThanOrEqualTo	query	decimal?	No
AmountNotEqualTo	query	decimal?	No
AmountBetween	query	decimal[]	No
AmountIn	query	decimal[]	No
StartDate	query	DateTime?	No
StartDateGreaterThanOrEqualTo	query	DateTime?	No
StartDateGreaterThan	query	DateTime?	No
StartDateLessThan	query	DateTime?	No
StartDateLessThanOrEqualTo	query	DateTime?	No
StartDateNotEqualTo	query	DateTime?	No
StartDateBetween	query	DateTime[]	No
StartDateIn	query	DateTime[]	No
EndDate	query	DateTime?	No
EndDateGreaterThanOrEqualTo	query	DateTime?	No
EndDateGreaterThan	query	DateTime?	No
EndDateLessThan	query	DateTime?	No
EndDateLessThanOrEqualTo	query	DateTime?	No
EndDateNotEqualTo	query	DateTime?	No
EndDateBetween	query	DateTime[]	No
EndDateIn	query	DateTime[]	No
UseQuantityBreak	query	bool?	No
QuantityBreak	query	decimal?	No
QuantityBreakGreaterThanOrEqualTo	query	decimal?	No
QuantityBreakGreaterThan	query	decimal?	No
QuantityBreakLessThan	query	decimal?	No
QuantityBreakLessThanOrEqualTo	query	decimal?	No
QuantityBreakNotEqualTo	query	decimal?	No
QuantityBreakBetween	query	decimal[]	No
QuantityBreakIn	query	decimal[]	No
RowHash	query	byte[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	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

**PR_ClassificationPricing** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
DB_Classification_RecID	form	string	No
IN_Classification_RecID	form	string	No
Source	form	byte	No
Mode	form	byte	No
Amount	form	decimal	No
StartDate	form	DateTime	No
EndDate	form	DateTime	No
UseQuantityBreak	form	bool	No
QuantityBreak	form	decimal	No
RowHash	form	byte[]	No
ItemNo	form	int	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/PR_ClassificationPricingQuery HTTP/1.1 
Host: localhost 
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>