JiwaAPI

<back to all web services

V_STK_LineDetailsQuery

Requires Authentication
V_STK_LineDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
StockTakeDetailsIDquerystringNo
StockTakeDetailsIDStartsWithquerystringNo
StockTakeDetailsIDEndsWithquerystringNo
StockTakeDetailsIDContainsquerystringNo
StockTakeDetailsIDLikequerystringNo
StockTakeDetailsIDBetweenquerystring[]No
StockTakeDetailsIDInquerystring[]No
StockTakeLineIDquerystringNo
StockTakeLineIDStartsWithquerystringNo
StockTakeLineIDEndsWithquerystringNo
StockTakeLineIDContainsquerystringNo
StockTakeLineIDLikequerystringNo
StockTakeLineIDBetweenquerystring[]No
StockTakeLineIDInquerystring[]No
SerialNumberquerystringNo
SerialNumberStartsWithquerystringNo
SerialNumberEndsWithquerystringNo
SerialNumberContainsquerystringNo
SerialNumberLikequerystringNo
SerialNumberBetweenquerystring[]No
SerialNumberInquerystring[]No
LinkIDquerystringNo
LinkIDStartsWithquerystringNo
LinkIDEndsWithquerystringNo
LinkIDContainsquerystringNo
LinkIDLikequerystringNo
LinkIDBetweenquerystring[]No
LinkIDInquerystring[]No
QtyFoundquerydecimal?No
QtyFoundGreaterThanOrEqualToquerydecimal?No
QtyFoundGreaterThanquerydecimal?No
QtyFoundLessThanquerydecimal?No
QtyFoundLessThanOrEqualToquerydecimal?No
QtyFoundNotEqualToquerydecimal?No
QtyFoundBetweenqueryNullable<Decimal>[]No
QtyFoundInqueryNullable<Decimal>[]No
Qtyquerydecimal?No
QtyGreaterThanOrEqualToquerydecimal?No
QtyGreaterThanquerydecimal?No
QtyLessThanquerydecimal?No
QtyLessThanOrEqualToquerydecimal?No
QtyNotEqualToquerydecimal?No
QtyBetweenqueryNullable<Decimal>[]No
QtyInqueryNullable<Decimal>[]No
Inc_Decqueryint?No
Inc_DecGreaterThanOrEqualToqueryint?No
Inc_DecGreaterThanqueryint?No
Inc_DecLessThanqueryint?No
Inc_DecLessThanOrEqualToqueryint?No
Inc_DecNotEqualToqueryint?No
Inc_DecBetweenqueryint[]No
Inc_DecInqueryint[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]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
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_STK_LineDetails Parameters:
NameParameterData TypeRequiredDescription
StockTakeDetailsIDformstringNo
StockTakeLineIDformstringNo
SerialNumberformstringNo
LinkIDformstringNo
QtyFoundformdecimal?No
Qtyformdecimal?No
Inc_DecformintNo
Costformdecimal?No
ExpiryDateformDateTime?No
BinLocationformstringNo
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/V_STK_LineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<V_STK_LineDetailsQuery 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>
  <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>
  <Inc_Dec>0</Inc_Dec>
  <Inc_DecBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </Inc_DecBetween>
  <Inc_DecGreaterThan>0</Inc_DecGreaterThan>
  <Inc_DecGreaterThanOrEqualTo>0</Inc_DecGreaterThanOrEqualTo>
  <Inc_DecIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </Inc_DecIn>
  <Inc_DecLessThan>0</Inc_DecLessThan>
  <Inc_DecLessThanOrEqualTo>0</Inc_DecLessThanOrEqualTo>
  <Inc_DecNotEqualTo>0</Inc_DecNotEqualTo>
  <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>
  <Qty>0</Qty>
  <QtyBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyBetween>
  <QtyFound>0</QtyFound>
  <QtyFoundBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyFoundBetween>
  <QtyFoundGreaterThan>0</QtyFoundGreaterThan>
  <QtyFoundGreaterThanOrEqualTo>0</QtyFoundGreaterThanOrEqualTo>
  <QtyFoundIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyFoundIn>
  <QtyFoundLessThan>0</QtyFoundLessThan>
  <QtyFoundLessThanOrEqualTo>0</QtyFoundLessThanOrEqualTo>
  <QtyFoundNotEqualTo>0</QtyFoundNotEqualTo>
  <QtyGreaterThan>0</QtyGreaterThan>
  <QtyGreaterThanOrEqualTo>0</QtyGreaterThanOrEqualTo>
  <QtyIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyIn>
  <QtyLessThan>0</QtyLessThan>
  <QtyLessThanOrEqualTo>0</QtyLessThanOrEqualTo>
  <QtyNotEqualTo>0</QtyNotEqualTo>
  <SerialNumber>String</SerialNumber>
  <SerialNumberBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNumberBetween>
  <SerialNumberContains>String</SerialNumberContains>
  <SerialNumberEndsWith>String</SerialNumberEndsWith>
  <SerialNumberIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SerialNumberIn>
  <SerialNumberLike>String</SerialNumberLike>
  <SerialNumberStartsWith>String</SerialNumberStartsWith>
  <StockTakeDetailsID>String</StockTakeDetailsID>
  <StockTakeDetailsIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeDetailsIDBetween>
  <StockTakeDetailsIDContains>String</StockTakeDetailsIDContains>
  <StockTakeDetailsIDEndsWith>String</StockTakeDetailsIDEndsWith>
  <StockTakeDetailsIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeDetailsIDIn>
  <StockTakeDetailsIDLike>String</StockTakeDetailsIDLike>
  <StockTakeDetailsIDStartsWith>String</StockTakeDetailsIDStartsWith>
  <StockTakeLineID>String</StockTakeLineID>
  <StockTakeLineIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeLineIDBetween>
  <StockTakeLineIDContains>String</StockTakeLineIDContains>
  <StockTakeLineIDEndsWith>String</StockTakeLineIDEndsWith>
  <StockTakeLineIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeLineIDIn>
  <StockTakeLineIDLike>String</StockTakeLineIDLike>
  <StockTakeLineIDStartsWith>String</StockTakeLineIDStartsWith>
</V_STK_LineDetailsQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfV_STK_LineDetails7kRqkrSv 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:V_STK_LineDetails>
      <d2p1:_x003C_BinLocation_x003E_k__BackingField>String</d2p1:_x003C_BinLocation_x003E_k__BackingField>
      <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_Inc_Dec_x003E_k__BackingField>0</d2p1:_x003C_Inc_Dec_x003E_k__BackingField>
      <d2p1:_x003C_LinkID_x003E_k__BackingField>String</d2p1:_x003C_LinkID_x003E_k__BackingField>
      <d2p1:_x003C_QtyFound_x003E_k__BackingField>0</d2p1:_x003C_QtyFound_x003E_k__BackingField>
      <d2p1:_x003C_Qty_x003E_k__BackingField>0</d2p1:_x003C_Qty_x003E_k__BackingField>
      <d2p1:_x003C_SerialNumber_x003E_k__BackingField>String</d2p1:_x003C_SerialNumber_x003E_k__BackingField>
      <d2p1:_x003C_StockTakeDetailsID_x003E_k__BackingField>String</d2p1:_x003C_StockTakeDetailsID_x003E_k__BackingField>
      <d2p1:_x003C_StockTakeLineID_x003E_k__BackingField>String</d2p1:_x003C_StockTakeLineID_x003E_k__BackingField>
    </d2p1:V_STK_LineDetails>
  </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>
</QueryResponseOfV_STK_LineDetails7kRqkrSv>