JiwaAPI

BM_WorkOrderInputsQuery

**BM_WorkOrderInputsQuery** 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_WorkOrderStages_RecID	query	string	No
BM_WorkOrderStages_RecIDStartsWith	query	string	No
BM_WorkOrderStages_RecIDEndsWith	query	string	No
BM_WorkOrderStages_RecIDContains	query	string	No
BM_WorkOrderStages_RecIDLike	query	string	No
BM_WorkOrderStages_RecIDBetween	query	string[]	No
BM_WorkOrderStages_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
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
QuantityOnBackOrder	query	decimal?	No
QuantityOnBackOrderGreaterThanOrEqualTo	query	decimal?	No
QuantityOnBackOrderGreaterThan	query	decimal?	No
QuantityOnBackOrderLessThan	query	decimal?	No
QuantityOnBackOrderLessThanOrEqualTo	query	decimal?	No
QuantityOnBackOrderNotEqualTo	query	decimal?	No
QuantityOnBackOrderBetween	query	decimal[]	No
QuantityOnBackOrderIn	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
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
SubAssembly	query	string	No
SubAssemblyStartsWith	query	string	No
SubAssemblyEndsWith	query	string	No
SubAssemblyContains	query	string	No
SubAssemblyLike	query	string	No
SubAssemblyBetween	query	string[]	No
SubAssemblyIn	query	string[]	No
SubAssemblyExplodePolicy	query	byte?	No
SubAssemblyExplodePolicyGreaterThanOrEqualTo	query	byte?	No
SubAssemblyExplodePolicyGreaterThan	query	byte?	No
SubAssemblyExplodePolicyLessThan	query	byte?	No
SubAssemblyExplodePolicyLessThanOrEqualTo	query	byte?	No
SubAssemblyExplodePolicyNotEqualTo	query	byte?	No
SubAssemblyExplodePolicyBetween	query	byte[]	No
SubAssemblyExplodePolicyIn	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_WorkOrderInputs** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
BM_WorkOrderStages_RecID	form	string	No
ItemNo	form	int	No
InventoryID	form	string	No
IsRatio	form	bool	No
Quantity	form	decimal	No
QuantityOnBackOrder	form	decimal	No
Note	form	string	No
LastSavedDateTime	form	DateTime	No
RowHash	form	byte[]	No
SubAssembly	form	string	No
SubAssemblyExplodePolicy	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_WorkOrderInputsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<BM_WorkOrderInputsQuery 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_WorkOrderStages_RecID>String</BM_WorkOrderStages_RecID>
  <BM_WorkOrderStages_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrderStages_RecIDBetween>
  <BM_WorkOrderStages_RecIDContains>String</BM_WorkOrderStages_RecIDContains>
  <BM_WorkOrderStages_RecIDEndsWith>String</BM_WorkOrderStages_RecIDEndsWith>
  <BM_WorkOrderStages_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BM_WorkOrderStages_RecIDIn>
  <BM_WorkOrderStages_RecIDLike>String</BM_WorkOrderStages_RecIDLike>
  <BM_WorkOrderStages_RecIDStartsWith>String</BM_WorkOrderStages_RecIDStartsWith>
  <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>
  <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>
  <QuantityOnBackOrder>0</QuantityOnBackOrder>
  <QuantityOnBackOrderBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityOnBackOrderBetween>
  <QuantityOnBackOrderGreaterThan>0</QuantityOnBackOrderGreaterThan>
  <QuantityOnBackOrderGreaterThanOrEqualTo>0</QuantityOnBackOrderGreaterThanOrEqualTo>
  <QuantityOnBackOrderIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityOnBackOrderIn>
  <QuantityOnBackOrderLessThan>0</QuantityOnBackOrderLessThan>
  <QuantityOnBackOrderLessThanOrEqualTo>0</QuantityOnBackOrderLessThanOrEqualTo>
  <QuantityOnBackOrderNotEqualTo>0</QuantityOnBackOrderNotEqualTo>
  <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>
  <SubAssembly>String</SubAssembly>
  <SubAssemblyBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubAssemblyBetween>
  <SubAssemblyContains>String</SubAssemblyContains>
  <SubAssemblyEndsWith>String</SubAssemblyEndsWith>
  <SubAssemblyExplodePolicy>0</SubAssemblyExplodePolicy>
  <SubAssemblyExplodePolicyBetween>AA==</SubAssemblyExplodePolicyBetween>
  <SubAssemblyExplodePolicyGreaterThan>0</SubAssemblyExplodePolicyGreaterThan>
  <SubAssemblyExplodePolicyGreaterThanOrEqualTo>0</SubAssemblyExplodePolicyGreaterThanOrEqualTo>
  <SubAssemblyExplodePolicyIn>AA==</SubAssemblyExplodePolicyIn>
  <SubAssemblyExplodePolicyLessThan>0</SubAssemblyExplodePolicyLessThan>
  <SubAssemblyExplodePolicyLessThanOrEqualTo>0</SubAssemblyExplodePolicyLessThanOrEqualTo>
  <SubAssemblyExplodePolicyNotEqualTo>0</SubAssemblyExplodePolicyNotEqualTo>
  <SubAssemblyIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubAssemblyIn>
  <SubAssemblyLike>String</SubAssemblyLike>
  <SubAssemblyStartsWith>String</SubAssemblyStartsWith>
</BM_WorkOrderInputsQuery>

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

<QueryResponseOfBM_WorkOrderInputs7kRqkrSv 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_WorkOrderInputs>
      <d2p1:_x003C_BM_WorkOrderStages_RecID_x003E_k__BackingField>String</d2p1:_x003C_BM_WorkOrderStages_RecID_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_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_QuantityOnBackOrder_x003E_k__BackingField>0</d2p1:_x003C_QuantityOnBackOrder_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:_x003C_SubAssemblyExplodePolicy_x003E_k__BackingField>0</d2p1:_x003C_SubAssemblyExplodePolicy_x003E_k__BackingField>
      <d2p1:_x003C_SubAssembly_x003E_k__BackingField>String</d2p1:_x003C_SubAssembly_x003E_k__BackingField>
    </d2p1:BM_WorkOrderInputs>
  </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_WorkOrderInputs7kRqkrSv>