JiwaAPI

<back to all web services

IN_StockTakeLinesQuery

Requires Authentication
IN_StockTakeLinesQuery Parameters:
NameParameterData TypeRequiredDescription
StockTakeLineIDquerystringNo
StockTakeLineIDStartsWithquerystringNo
StockTakeLineIDEndsWithquerystringNo
StockTakeLineIDContainsquerystringNo
StockTakeLineIDLikequerystringNo
StockTakeLineIDBetweenquerystring[]No
StockTakeLineIDInquerystring[]No
StockTakeIDquerystringNo
StockTakeIDStartsWithquerystringNo
StockTakeIDEndsWithquerystringNo
StockTakeIDContainsquerystringNo
StockTakeIDLikequerystringNo
StockTakeIDBetweenquerystring[]No
StockTakeIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
QtyOnHandquerydecimal?No
QtyOnHandGreaterThanOrEqualToquerydecimal?No
QtyOnHandGreaterThanquerydecimal?No
QtyOnHandLessThanquerydecimal?No
QtyOnHandLessThanOrEqualToquerydecimal?No
QtyOnHandNotEqualToquerydecimal?No
QtyOnHandBetweenqueryNullable<Decimal>[]No
QtyOnHandInqueryNullable<Decimal>[]No
QtyFoundquerydecimal?No
QtyFoundGreaterThanOrEqualToquerydecimal?No
QtyFoundGreaterThanquerydecimal?No
QtyFoundLessThanquerydecimal?No
QtyFoundLessThanOrEqualToquerydecimal?No
QtyFoundNotEqualToquerydecimal?No
QtyFoundBetweenqueryNullable<Decimal>[]No
QtyFoundInqueryNullable<Decimal>[]No
AmountVarquerydecimal?No
AmountVarGreaterThanOrEqualToquerydecimal?No
AmountVarGreaterThanquerydecimal?No
AmountVarLessThanquerydecimal?No
AmountVarLessThanOrEqualToquerydecimal?No
AmountVarNotEqualToquerydecimal?No
AmountVarBetweenqueryNullable<Decimal>[]No
AmountVarInqueryNullable<Decimal>[]No
BinLocationquerystringNo
BinLocationStartsWithquerystringNo
BinLocationEndsWithquerystringNo
BinLocationContainsquerystringNo
BinLocationLikequerystringNo
BinLocationBetweenquerystring[]No
BinLocationInquerystring[]No
LineNumqueryint?No
LineNumGreaterThanOrEqualToqueryint?No
LineNumGreaterThanqueryint?No
LineNumLessThanqueryint?No
LineNumLessThanOrEqualToqueryint?No
LineNumNotEqualToqueryint?No
LineNumBetweenqueryNullable<Int32>[]No
LineNumInqueryNullable<Int32>[]No
DefaultBinquerystringNo
DefaultBinStartsWithquerystringNo
DefaultBinEndsWithquerystringNo
DefaultBinContainsquerystringNo
DefaultBinLikequerystringNo
DefaultBinBetweenquerystring[]No
DefaultBinInquerystring[]No
CommentquerystringNo
CommentStartsWithquerystringNo
CommentEndsWithquerystringNo
CommentContainsquerystringNo
CommentLikequerystringNo
CommentBetweenquerystring[]No
CommentInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_StockTakeLines Parameters:
NameParameterData TypeRequiredDescription
StockTakeLineIDformstringNo
StockTakeIDformstringNo
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
QtyOnHandformdecimal?No
QtyFoundformdecimal?No
AmountVarformdecimal?No
BinLocationformstringNo
LineNumformint?No
DefaultBinformstringNo
CommentformstringNo
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/IN_StockTakeLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<IN_StockTakeLinesQuery 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>
  <AmountVar>0</AmountVar>
  <AmountVarBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountVarBetween>
  <AmountVarGreaterThan>0</AmountVarGreaterThan>
  <AmountVarGreaterThanOrEqualTo>0</AmountVarGreaterThanOrEqualTo>
  <AmountVarIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </AmountVarIn>
  <AmountVarLessThan>0</AmountVarLessThan>
  <AmountVarLessThanOrEqualTo>0</AmountVarLessThanOrEqualTo>
  <AmountVarNotEqualTo>0</AmountVarNotEqualTo>
  <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>
  <Comment>String</Comment>
  <CommentBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CommentBetween>
  <CommentContains>String</CommentContains>
  <CommentEndsWith>String</CommentEndsWith>
  <CommentIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CommentIn>
  <CommentLike>String</CommentLike>
  <CommentStartsWith>String</CommentStartsWith>
  <DefaultBin>String</DefaultBin>
  <DefaultBinBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DefaultBinBetween>
  <DefaultBinContains>String</DefaultBinContains>
  <DefaultBinEndsWith>String</DefaultBinEndsWith>
  <DefaultBinIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DefaultBinIn>
  <DefaultBinLike>String</DefaultBinLike>
  <DefaultBinStartsWith>String</DefaultBinStartsWith>
  <Description>String</Description>
  <DescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionBetween>
  <DescriptionContains>String</DescriptionContains>
  <DescriptionEndsWith>String</DescriptionEndsWith>
  <DescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </DescriptionIn>
  <DescriptionLike>String</DescriptionLike>
  <DescriptionStartsWith>String</DescriptionStartsWith>
  <InventoryID>String</InventoryID>
  <InventoryIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InventoryIDBetween>
  <InventoryIDContains>String</InventoryIDContains>
  <InventoryIDEndsWith>String</InventoryIDEndsWith>
  <InventoryIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </InventoryIDIn>
  <InventoryIDLike>String</InventoryIDLike>
  <InventoryIDStartsWith>String</InventoryIDStartsWith>
  <LineNum>0</LineNum>
  <LineNumBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </LineNumBetween>
  <LineNumGreaterThan>0</LineNumGreaterThan>
  <LineNumGreaterThanOrEqualTo>0</LineNumGreaterThanOrEqualTo>
  <LineNumIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:int>0</d2p1:int>
  </LineNumIn>
  <LineNumLessThan>0</LineNumLessThan>
  <LineNumLessThanOrEqualTo>0</LineNumLessThanOrEqualTo>
  <LineNumNotEqualTo>0</LineNumNotEqualTo>
  <PartNo>String</PartNo>
  <PartNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartNoBetween>
  <PartNoContains>String</PartNoContains>
  <PartNoEndsWith>String</PartNoEndsWith>
  <PartNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </PartNoIn>
  <PartNoLike>String</PartNoLike>
  <PartNoStartsWith>String</PartNoStartsWith>
  <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>
  <QtyOnHand>0</QtyOnHand>
  <QtyOnHandBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyOnHandBetween>
  <QtyOnHandGreaterThan>0</QtyOnHandGreaterThan>
  <QtyOnHandGreaterThanOrEqualTo>0</QtyOnHandGreaterThanOrEqualTo>
  <QtyOnHandIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </QtyOnHandIn>
  <QtyOnHandLessThan>0</QtyOnHandLessThan>
  <QtyOnHandLessThanOrEqualTo>0</QtyOnHandLessThanOrEqualTo>
  <QtyOnHandNotEqualTo>0</QtyOnHandNotEqualTo>
  <StockTakeID>String</StockTakeID>
  <StockTakeIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeIDBetween>
  <StockTakeIDContains>String</StockTakeIDContains>
  <StockTakeIDEndsWith>String</StockTakeIDEndsWith>
  <StockTakeIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </StockTakeIDIn>
  <StockTakeIDLike>String</StockTakeIDLike>
  <StockTakeIDStartsWith>String</StockTakeIDStartsWith>
  <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>
</IN_StockTakeLinesQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfIN_StockTakeLines7kRqkrSv 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:IN_StockTakeLines>
      <d2p1:_x003C_AmountVar_x003E_k__BackingField>0</d2p1:_x003C_AmountVar_x003E_k__BackingField>
      <d2p1:_x003C_BinLocation_x003E_k__BackingField>String</d2p1:_x003C_BinLocation_x003E_k__BackingField>
      <d2p1:_x003C_Comment_x003E_k__BackingField>String</d2p1:_x003C_Comment_x003E_k__BackingField>
      <d2p1:_x003C_DefaultBin_x003E_k__BackingField>String</d2p1:_x003C_DefaultBin_x003E_k__BackingField>
      <d2p1:_x003C_Description_x003E_k__BackingField>String</d2p1:_x003C_Description_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_LineNum_x003E_k__BackingField>0</d2p1:_x003C_LineNum_x003E_k__BackingField>
      <d2p1:_x003C_PartNo_x003E_k__BackingField>String</d2p1:_x003C_PartNo_x003E_k__BackingField>
      <d2p1:_x003C_QtyFound_x003E_k__BackingField>0</d2p1:_x003C_QtyFound_x003E_k__BackingField>
      <d2p1:_x003C_QtyOnHand_x003E_k__BackingField>0</d2p1:_x003C_QtyOnHand_x003E_k__BackingField>
      <d2p1:_x003C_StockTakeID_x003E_k__BackingField>String</d2p1:_x003C_StockTakeID_x003E_k__BackingField>
      <d2p1:_x003C_StockTakeLineID_x003E_k__BackingField>String</d2p1:_x003C_StockTakeLineID_x003E_k__BackingField>
    </d2p1:IN_StockTakeLines>
  </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>
</QueryResponseOfIN_StockTakeLines7kRqkrSv>