JiwaAPI

BM_WorkOrderOutputsQuery

**BM_WorkOrderOutputsQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
BM_WorkOrder_RecID	query	string	No
BM_WorkOrder_RecIDStartsWith	query	string	No
BM_WorkOrder_RecIDEndsWith	query	string	No
BM_WorkOrder_RecIDContains	query	string	No
BM_WorkOrder_RecIDLike	query	string	No
BM_WorkOrder_RecIDBetween	query	string[]	No
BM_WorkOrder_RecIDIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
IsRatio	query	bool?	No
IsPrimary	query	bool?	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	decimal[]	No
QuantityIn	query	decimal[]	No
QuantityOutput	query	decimal?	No
QuantityOutputGreaterThanOrEqualTo	query	decimal?	No
QuantityOutputGreaterThan	query	decimal?	No
QuantityOutputLessThan	query	decimal?	No
QuantityOutputLessThanOrEqualTo	query	decimal?	No
QuantityOutputNotEqualTo	query	decimal?	No
QuantityOutputBetween	query	decimal[]	No
QuantityOutputIn	query	decimal[]	No
QuantityWrittenoff	query	decimal?	No
QuantityWrittenoffGreaterThanOrEqualTo	query	decimal?	No
QuantityWrittenoffGreaterThan	query	decimal?	No
QuantityWrittenoffLessThan	query	decimal?	No
QuantityWrittenoffLessThanOrEqualTo	query	decimal?	No
QuantityWrittenoffNotEqualTo	query	decimal?	No
QuantityWrittenoffBetween	query	decimal[]	No
QuantityWrittenoffIn	query	decimal[]	No
Note	query	string	No
NoteStartsWith	query	string	No
NoteEndsWith	query	string	No
NoteContains	query	string	No
NoteLike	query	string	No
NoteBetween	query	string[]	No
NoteIn	query	string[]	No
CostPercentage	query	decimal?	No
CostPercentageGreaterThanOrEqualTo	query	decimal?	No
CostPercentageGreaterThan	query	decimal?	No
CostPercentageLessThan	query	decimal?	No
CostPercentageLessThanOrEqualTo	query	decimal?	No
CostPercentageNotEqualTo	query	decimal?	No
CostPercentageBetween	query	decimal[]	No
CostPercentageIn	query	decimal[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	No
RowHash	query	byte[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**BM_WorkOrderOutputs** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
BM_WorkOrder_RecID	form	string	No
ItemNo	form	int	No
InventoryID	form	string	No
IsRatio	form	bool	No
IsPrimary	form	bool	No
Quantity	form	decimal	No
QuantityOutput	form	decimal	No
QuantityWrittenoff	form	decimal	No
Note	form	string	No
CostPercentage	form	decimal	No
LastSavedDateTime	form	DateTime	No
RowHash	form	byte[]	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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_WorkOrderOutputsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<BM_WorkOrderOutputsQuery 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_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>
  <CostPercentage>0</CostPercentage>
  <CostPercentageBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </CostPercentageBetween>
  <CostPercentageGreaterThan>0</CostPercentageGreaterThan>
  <CostPercentageGreaterThanOrEqualTo>0</CostPercentageGreaterThanOrEqualTo>
  <CostPercentageIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </CostPercentageIn>
  <CostPercentageLessThan>0</CostPercentageLessThan>
  <CostPercentageLessThanOrEqualTo>0</CostPercentageLessThanOrEqualTo>
  <CostPercentageNotEqualTo>0</CostPercentageNotEqualTo>
  <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>
  <IsPrimary>false</IsPrimary>
  <IsRatio>false</IsRatio>
  <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>
  <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>
  <Note>String</Note>
  <NoteBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NoteBetween>
  <NoteContains>String</NoteContains>
  <NoteEndsWith>String</NoteEndsWith>
  <NoteIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </NoteIn>
  <NoteLike>String</NoteLike>
  <NoteStartsWith>String</NoteStartsWith>
  <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>
  <QuantityOutput>0</QuantityOutput>
  <QuantityOutputBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityOutputBetween>
  <QuantityOutputGreaterThan>0</QuantityOutputGreaterThan>
  <QuantityOutputGreaterThanOrEqualTo>0</QuantityOutputGreaterThanOrEqualTo>
  <QuantityOutputIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityOutputIn>
  <QuantityOutputLessThan>0</QuantityOutputLessThan>
  <QuantityOutputLessThanOrEqualTo>0</QuantityOutputLessThanOrEqualTo>
  <QuantityOutputNotEqualTo>0</QuantityOutputNotEqualTo>
  <QuantityWrittenoff>0</QuantityWrittenoff>
  <QuantityWrittenoffBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityWrittenoffBetween>
  <QuantityWrittenoffGreaterThan>0</QuantityWrittenoffGreaterThan>
  <QuantityWrittenoffGreaterThanOrEqualTo>0</QuantityWrittenoffGreaterThanOrEqualTo>
  <QuantityWrittenoffIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityWrittenoffIn>
  <QuantityWrittenoffLessThan>0</QuantityWrittenoffLessThan>
  <QuantityWrittenoffLessThanOrEqualTo>0</QuantityWrittenoffLessThanOrEqualTo>
  <QuantityWrittenoffNotEqualTo>0</QuantityWrittenoffNotEqualTo>
  <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>
  <RowHash>AA==</RowHash>
</BM_WorkOrderOutputsQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfBM_WorkOrderOutputs7kRqkrSv 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_WorkOrderOutputs>
      <d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WorkOrder_RecID_x003E_k__BackingField>
      <d2p1:_x003C_CostPercentage_x003E_k__BackingField>0</d2p1:_x003C_CostPercentage_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_IsPrimary_x003E_k__BackingField>false</d2p1:_x003C_IsPrimary_x003E_k__BackingField>
      <d2p1:_x003C_IsRatio_x003E_k__BackingField>false</d2p1:_x003C_IsRatio_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Note_x003E_k__BackingField>String</d2p1:_x003C_Note_x003E_k__BackingField>
      <d2p1:_x003C_QuantityOutput_x003E_k__BackingField>0</d2p1:_x003C_QuantityOutput_x003E_k__BackingField>
      <d2p1:_x003C_QuantityWrittenoff_x003E_k__BackingField>0</d2p1:_x003C_QuantityWrittenoff_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_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
    </d2p1:BM_WorkOrderOutputs>
  </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_WorkOrderOutputs7kRqkrSv>