JiwaAPI

<back to all web services

BM_WorkOrderStagesQuery

Requires Authentication
BM_WorkOrderStagesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
BM_WorkOrder_RecIDquerystringNo
BM_WorkOrder_RecIDStartsWithquerystringNo
BM_WorkOrder_RecIDEndsWithquerystringNo
BM_WorkOrder_RecIDContainsquerystringNo
BM_WorkOrder_RecIDLikequerystringNo
BM_WorkOrder_RecIDBetweenquerystring[]No
BM_WorkOrder_RecIDInquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
BM_WarehouseProductionLineWorkCentre_RecIDquerystringNo
BM_WarehouseProductionLineWorkCentre_RecIDStartsWithquerystringNo
BM_WarehouseProductionLineWorkCentre_RecIDEndsWithquerystringNo
BM_WarehouseProductionLineWorkCentre_RecIDContainsquerystringNo
BM_WarehouseProductionLineWorkCentre_RecIDLikequerystringNo
BM_WarehouseProductionLineWorkCentre_RecIDBetweenquerystring[]No
BM_WarehouseProductionLineWorkCentre_RecIDInquerystring[]No
RequiredCapacityquerydecimal?No
RequiredCapacityGreaterThanOrEqualToquerydecimal?No
RequiredCapacityGreaterThanquerydecimal?No
RequiredCapacityLessThanquerydecimal?No
RequiredCapacityLessThanOrEqualToquerydecimal?No
RequiredCapacityNotEqualToquerydecimal?No
RequiredCapacityBetweenqueryNullable<Decimal>[]No
RequiredCapacityInqueryNullable<Decimal>[]No
Statusquerybyte?No
StatusGreaterThanOrEqualToquerybyte?No
StatusGreaterThanquerybyte?No
StatusLessThanquerybyte?No
StatusLessThanOrEqualToquerybyte?No
StatusNotEqualToquerybyte?No
StatusBetweenquerybyte[]No
StatusInquerybyte[]No
RowHashquerybyte[]No
StartDatequeryDateTime?No
StartDateGreaterThanOrEqualToqueryDateTime?No
StartDateGreaterThanqueryDateTime?No
StartDateLessThanqueryDateTime?No
StartDateLessThanOrEqualToqueryDateTime?No
StartDateNotEqualToqueryDateTime?No
StartDateBetweenqueryDateTime[]No
StartDateInqueryDateTime[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
BM_WorkOrderStages Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
BM_WorkOrder_RecIDformstringNo
ItemNoformintNo
NameformstringNo
BM_WarehouseProductionLineWorkCentre_RecIDformstringNo
RequiredCapacityformdecimal?No
StatusformbyteNo
RowHashformbyte[]No
StartDateformDateTimeNo
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/BM_WorkOrderStagesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<BM_WorkOrderStagesQuery 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>
  <BM_WarehouseProductionLineWorkCentre_RecID>String</BM_WarehouseProductionLineWorkCentre_RecID>
  <BM_WarehouseProductionLineWorkCentre_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WarehouseProductionLineWorkCentre_RecIDBetween>
  <BM_WarehouseProductionLineWorkCentre_RecIDContains>String</BM_WarehouseProductionLineWorkCentre_RecIDContains>
  <BM_WarehouseProductionLineWorkCentre_RecIDEndsWith>String</BM_WarehouseProductionLineWorkCentre_RecIDEndsWith>
  <BM_WarehouseProductionLineWorkCentre_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WarehouseProductionLineWorkCentre_RecIDIn>
  <BM_WarehouseProductionLineWorkCentre_RecIDLike>String</BM_WarehouseProductionLineWorkCentre_RecIDLike>
  <BM_WarehouseProductionLineWorkCentre_RecIDStartsWith>String</BM_WarehouseProductionLineWorkCentre_RecIDStartsWith>
  <BM_WorkOrder_RecID>String</BM_WorkOrder_RecID>
  <BM_WorkOrder_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrder_RecIDBetween>
  <BM_WorkOrder_RecIDContains>String</BM_WorkOrder_RecIDContains>
  <BM_WorkOrder_RecIDEndsWith>String</BM_WorkOrder_RecIDEndsWith>
  <BM_WorkOrder_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrder_RecIDIn>
  <BM_WorkOrder_RecIDLike>String</BM_WorkOrder_RecIDLike>
  <BM_WorkOrder_RecIDStartsWith>String</BM_WorkOrder_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>
  <Name>String</Name>
  <NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameBetween>
  <NameContains>String</NameContains>
  <NameEndsWith>String</NameEndsWith>
  <NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NameIn>
  <NameLike>String</NameLike>
  <NameStartsWith>String</NameStartsWith>
  <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>
  <RequiredCapacity>0</RequiredCapacity>
  <RequiredCapacityBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RequiredCapacityBetween>
  <RequiredCapacityGreaterThan>0</RequiredCapacityGreaterThan>
  <RequiredCapacityGreaterThanOrEqualTo>0</RequiredCapacityGreaterThanOrEqualTo>
  <RequiredCapacityIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </RequiredCapacityIn>
  <RequiredCapacityLessThan>0</RequiredCapacityLessThan>
  <RequiredCapacityLessThanOrEqualTo>0</RequiredCapacityLessThanOrEqualTo>
  <RequiredCapacityNotEqualTo>0</RequiredCapacityNotEqualTo>
  <RowHash>AA==</RowHash>
  <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>
  <Status>0</Status>
  <StatusBetween>AA==</StatusBetween>
  <StatusGreaterThan>0</StatusGreaterThan>
  <StatusGreaterThanOrEqualTo>0</StatusGreaterThanOrEqualTo>
  <StatusIn>AA==</StatusIn>
  <StatusLessThan>0</StatusLessThan>
  <StatusLessThanOrEqualTo>0</StatusLessThanOrEqualTo>
  <StatusNotEqualTo>0</StatusNotEqualTo>
</BM_WorkOrderStagesQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfBM_WorkOrderStages7kRqkrSv 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:BM_WorkOrderStages>
      <d2p1:_x003C_BM_WarehouseProductionLineWorkCentre_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WarehouseProductionLineWorkCentre_RecID_x003E_k__BackingField>
      <d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_Name_x003E_k__BackingField>String</d2p1:_x003C_Name_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RequiredCapacity_x003E_k__BackingField>0</d2p1:_x003C_RequiredCapacity_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_StartDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_StartDate_x003E_k__BackingField>
      <d2p1:_x003C_Status_x003E_k__BackingField>0</d2p1:_x003C_Status_x003E_k__BackingField>
    </d2p1:BM_WorkOrderStages>
  </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>
</QueryResponseOfBM_WorkOrderStages7kRqkrSv>