JiwaAPI

<back to all web services

SM_PartLineDetailsQuery

Requires Authentication
SM_PartLineDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SM_Parts_RecIDquerystringNo
SM_Parts_RecIDStartsWithquerystringNo
SM_Parts_RecIDEndsWithquerystringNo
SM_Parts_RecIDContainsquerystringNo
SM_Parts_RecIDLikequerystringNo
SM_Parts_RecIDBetweenquerystring[]No
SM_Parts_RecIDInquerystring[]No
LinkIDquerystringNo
LinkIDStartsWithquerystringNo
LinkIDEndsWithquerystringNo
LinkIDContainsquerystringNo
LinkIDLikequerystringNo
LinkIDBetweenquerystring[]No
LinkIDInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenqueryNullable<Decimal>[]No
QuantityInqueryNullable<Decimal>[]No
Modequerybyte?No
ModeGreaterThanOrEqualToquerybyte?No
ModeGreaterThanquerybyte?No
ModeLessThanquerybyte?No
ModeLessThanOrEqualToquerybyte?No
ModeNotEqualToquerybyte?No
ModeBetweenqueryNullable<Byte>[]No
ModeInqueryNullable<Byte>[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]No
TaxPaidquerydecimal?No
TaxPaidGreaterThanOrEqualToquerydecimal?No
TaxPaidGreaterThanquerydecimal?No
TaxPaidLessThanquerydecimal?No
TaxPaidLessThanOrEqualToquerydecimal?No
TaxPaidNotEqualToquerydecimal?No
TaxPaidBetweenqueryNullable<Decimal>[]No
TaxPaidInqueryNullable<Decimal>[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_PartLineDetails Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SM_Parts_RecIDformstringNo
LinkIDformstringNo
Quantityformdecimal?No
Modeformbyte?No
Costformdecimal?No
TaxPaidformdecimal?No
SerialNoformstringNo
ExpiryDateformDateTime?No
LastSavedDateTimeformDateTimeNo
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_PartLineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_PartLineDetailsQuery 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>
  <Cost>0</Cost>
  <CostBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostBetween>
  <CostGreaterThan>0</CostGreaterThan>
  <CostGreaterThanOrEqualTo>0</CostGreaterThanOrEqualTo>
  <CostIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </CostIn>
  <CostLessThan>0</CostLessThan>
  <CostLessThanOrEqualTo>0</CostLessThanOrEqualTo>
  <CostNotEqualTo>0</CostNotEqualTo>
  <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>
  <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>
  <LinkID>String</LinkID>
  <LinkIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LinkIDBetween>
  <LinkIDContains>String</LinkIDContains>
  <LinkIDEndsWith>String</LinkIDEndsWith>
  <LinkIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </LinkIDIn>
  <LinkIDLike>String</LinkIDLike>
  <LinkIDStartsWith>String</LinkIDStartsWith>
  <Mode>0</Mode>
  <ModeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:unsignedByte>0</d2p1:unsignedByte>
  </ModeBetween>
  <ModeGreaterThan>0</ModeGreaterThan>
  <ModeGreaterThanOrEqualTo>0</ModeGreaterThanOrEqualTo>
  <ModeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:unsignedByte>0</d2p1:unsignedByte>
  </ModeIn>
  <ModeLessThan>0</ModeLessThan>
  <ModeLessThanOrEqualTo>0</ModeLessThanOrEqualTo>
  <ModeNotEqualTo>0</ModeNotEqualTo>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <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>
  <SM_Parts_RecID>String</SM_Parts_RecID>
  <SM_Parts_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Parts_RecIDBetween>
  <SM_Parts_RecIDContains>String</SM_Parts_RecIDContains>
  <SM_Parts_RecIDEndsWith>String</SM_Parts_RecIDEndsWith>
  <SM_Parts_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Parts_RecIDIn>
  <SM_Parts_RecIDLike>String</SM_Parts_RecIDLike>
  <SM_Parts_RecIDStartsWith>String</SM_Parts_RecIDStartsWith>
  <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>
  <TaxPaid>0</TaxPaid>
  <TaxPaidBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </TaxPaidBetween>
  <TaxPaidGreaterThan>0</TaxPaidGreaterThan>
  <TaxPaidGreaterThanOrEqualTo>0</TaxPaidGreaterThanOrEqualTo>
  <TaxPaidIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </TaxPaidIn>
  <TaxPaidLessThan>0</TaxPaidLessThan>
  <TaxPaidLessThanOrEqualTo>0</TaxPaidLessThanOrEqualTo>
  <TaxPaidNotEqualTo>0</TaxPaidNotEqualTo>
</SM_PartLineDetailsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSM_PartLineDetails7kRqkrSv 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_PartLineDetails>
      <d2p1:_x003C_Cost_x003E_k__BackingField>0</d2p1:_x003C_Cost_x003E_k__BackingField>
      <d2p1:_x003C_ExpiryDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ExpiryDate_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_LinkID_x003E_k__BackingField>String</d2p1:_x003C_LinkID_x003E_k__BackingField>
      <d2p1:_x003C_Mode_x003E_k__BackingField>0</d2p1:_x003C_Mode_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SM_Parts_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Parts_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SerialNo_x003E_k__BackingField>String</d2p1:_x003C_SerialNo_x003E_k__BackingField>
      <d2p1:_x003C_TaxPaid_x003E_k__BackingField>0</d2p1:_x003C_TaxPaid_x003E_k__BackingField>
    </d2p1:SM_PartLineDetails>
  </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_PartLineDetails7kRqkrSv>