JiwaAPI

<back to all web services

PI_LinesDetailsQuery

Requires Authentication
PI_LinesDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
PI_LinesDetailsIDquerystringNo
PI_LinesDetailsIDStartsWithquerystringNo
PI_LinesDetailsIDEndsWithquerystringNo
PI_LinesDetailsIDContainsquerystringNo
PI_LinesDetailsIDLikequerystringNo
PI_LinesDetailsIDBetweenquerystring[]No
PI_LinesDetailsIDInquerystring[]No
PI_LinesIDquerystringNo
PI_LinesIDStartsWithquerystringNo
PI_LinesIDEndsWithquerystringNo
PI_LinesIDContainsquerystringNo
PI_LinesIDLikequerystringNo
PI_LinesIDBetweenquerystring[]No
PI_LinesIDInquerystring[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenquerydecimal[]No
QuantityInquerydecimal[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
BinLocationquerystringNo
BinLocationStartsWithquerystringNo
BinLocationEndsWithquerystringNo
BinLocationContainsquerystringNo
BinLocationLikequerystringNo
BinLocationBetweenquerystring[]No
BinLocationInquerystring[]No
RowHashquerybyte[]No
RE_LineDetails_RecIDquerystringNo
RE_LineDetails_RecIDStartsWithquerystringNo
RE_LineDetails_RecIDEndsWithquerystringNo
RE_LineDetails_RecIDContainsquerystringNo
RE_LineDetails_RecIDLikequerystringNo
RE_LineDetails_RecIDBetweenquerystring[]No
RE_LineDetails_RecIDInquerystring[]No
IN_SOH_RecIDquerystringNo
IN_SOH_RecIDStartsWithquerystringNo
IN_SOH_RecIDEndsWithquerystringNo
IN_SOH_RecIDContainsquerystringNo
IN_SOH_RecIDLikequerystringNo
IN_SOH_RecIDBetweenquerystring[]No
IN_SOH_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PI_LinesDetails Parameters:
NameParameterData TypeRequiredDescription
PI_LinesDetailsIDformstringNo
PI_LinesIDformstringNo
SerialNoformstringNo
QuantityformdecimalNo
ExpiryDateformDateTime?No
BinLocationformstringNo
RowHashformbyte[]No
RE_LineDetails_RecIDformstringNo
IN_SOH_RecIDformstringNo
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/PI_LinesDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<PI_LinesDetailsQuery 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>
  <BinLocation>String</BinLocation>
  <BinLocationBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationBetween>
  <BinLocationContains>String</BinLocationContains>
  <BinLocationEndsWith>String</BinLocationEndsWith>
  <BinLocationIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BinLocationIn>
  <BinLocationLike>String</BinLocationLike>
  <BinLocationStartsWith>String</BinLocationStartsWith>
  <ExpiryDate>0001-01-01T00:00:00</ExpiryDate>
  <ExpiryDateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateBetween>
  <ExpiryDateGreaterThan>0001-01-01T00:00:00</ExpiryDateGreaterThan>
  <ExpiryDateGreaterThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateGreaterThanOrEqualTo>
  <ExpiryDateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </ExpiryDateIn>
  <ExpiryDateLessThan>0001-01-01T00:00:00</ExpiryDateLessThan>
  <ExpiryDateLessThanOrEqualTo>0001-01-01T00:00:00</ExpiryDateLessThanOrEqualTo>
  <ExpiryDateNotEqualTo>0001-01-01T00:00:00</ExpiryDateNotEqualTo>
  <IN_SOH_RecID>String</IN_SOH_RecID>
  <IN_SOH_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_SOH_RecIDBetween>
  <IN_SOH_RecIDContains>String</IN_SOH_RecIDContains>
  <IN_SOH_RecIDEndsWith>String</IN_SOH_RecIDEndsWith>
  <IN_SOH_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </IN_SOH_RecIDIn>
  <IN_SOH_RecIDLike>String</IN_SOH_RecIDLike>
  <IN_SOH_RecIDStartsWith>String</IN_SOH_RecIDStartsWith>
  <PI_LinesDetailsID>String</PI_LinesDetailsID>
  <PI_LinesDetailsIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PI_LinesDetailsIDBetween>
  <PI_LinesDetailsIDContains>String</PI_LinesDetailsIDContains>
  <PI_LinesDetailsIDEndsWith>String</PI_LinesDetailsIDEndsWith>
  <PI_LinesDetailsIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PI_LinesDetailsIDIn>
  <PI_LinesDetailsIDLike>String</PI_LinesDetailsIDLike>
  <PI_LinesDetailsIDStartsWith>String</PI_LinesDetailsIDStartsWith>
  <PI_LinesID>String</PI_LinesID>
  <PI_LinesIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PI_LinesIDBetween>
  <PI_LinesIDContains>String</PI_LinesIDContains>
  <PI_LinesIDEndsWith>String</PI_LinesIDEndsWith>
  <PI_LinesIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PI_LinesIDIn>
  <PI_LinesIDLike>String</PI_LinesIDLike>
  <PI_LinesIDStartsWith>String</PI_LinesIDStartsWith>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <RE_LineDetails_RecID>String</RE_LineDetails_RecID>
  <RE_LineDetails_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RE_LineDetails_RecIDBetween>
  <RE_LineDetails_RecIDContains>String</RE_LineDetails_RecIDContains>
  <RE_LineDetails_RecIDEndsWith>String</RE_LineDetails_RecIDEndsWith>
  <RE_LineDetails_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RE_LineDetails_RecIDIn>
  <RE_LineDetails_RecIDLike>String</RE_LineDetails_RecIDLike>
  <RE_LineDetails_RecIDStartsWith>String</RE_LineDetails_RecIDStartsWith>
  <RowHash>AA==</RowHash>
  <SerialNo>String</SerialNo>
  <SerialNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoBetween>
  <SerialNoContains>String</SerialNoContains>
  <SerialNoEndsWith>String</SerialNoEndsWith>
  <SerialNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNoIn>
  <SerialNoLike>String</SerialNoLike>
  <SerialNoStartsWith>String</SerialNoStartsWith>
</PI_LinesDetailsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfPI_LinesDetails7kRqkrSv 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:PI_LinesDetails>
      <d2p1:_x003C_BinLocation_x003E_k__BackingField>String</d2p1:_x003C_BinLocation_x003E_k__BackingField>
      <d2p1:_x003C_ExpiryDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ExpiryDate_x003E_k__BackingField>
      <d2p1:_x003C_IN_SOH_RecID_x003E_k__BackingField>String</d2p1:_x003C_IN_SOH_RecID_x003E_k__BackingField>
      <d2p1:_x003C_PI_LinesDetailsID_x003E_k__BackingField>String</d2p1:_x003C_PI_LinesDetailsID_x003E_k__BackingField>
      <d2p1:_x003C_PI_LinesID_x003E_k__BackingField>String</d2p1:_x003C_PI_LinesID_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RE_LineDetails_RecID_x003E_k__BackingField>String</d2p1:_x003C_RE_LineDetails_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_SerialNo_x003E_k__BackingField>String</d2p1:_x003C_SerialNo_x003E_k__BackingField>
    </d2p1:PI_LinesDetails>
  </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>
</QueryResponseOfPI_LinesDetails7kRqkrSv>