JiwaAPI

BM_WorkOrderQuery

The following routes are available for this service:
GET	/Queries/BM_WorkOrder	Retrieves a list of work orders.

**BM_WorkOrderQuery** 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
WorkOrderNo	query	string	No
WorkOrderNoStartsWith	query	string	No
WorkOrderNoEndsWith	query	string	No
WorkOrderNoContains	query	string	No
WorkOrderNoLike	query	string	No
WorkOrderNoBetween	query	string[]	No
WorkOrderNoIn	query	string[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	query	string[]	No
BM_Main_RecID	query	string	No
BM_Main_RecIDStartsWith	query	string	No
BM_Main_RecIDEndsWith	query	string	No
BM_Main_RecIDContains	query	string	No
BM_Main_RecIDLike	query	string	No
BM_Main_RecIDBetween	query	string[]	No
BM_Main_RecIDIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
DateCreated	query	DateTime?	No
DateCreatedGreaterThanOrEqualTo	query	DateTime?	No
DateCreatedGreaterThan	query	DateTime?	No
DateCreatedLessThan	query	DateTime?	No
DateCreatedLessThanOrEqualTo	query	DateTime?	No
DateCreatedNotEqualTo	query	DateTime?	No
DateCreatedBetween	query	DateTime[]	No
DateCreatedIn	query	DateTime[]	No
DateRequired	query	DateTime?	No
DateRequiredGreaterThanOrEqualTo	query	DateTime?	No
DateRequiredGreaterThan	query	DateTime?	No
DateRequiredLessThan	query	DateTime?	No
DateRequiredLessThanOrEqualTo	query	DateTime?	No
DateRequiredNotEqualTo	query	DateTime?	No
DateRequiredBetween	query	DateTime[]	No
DateRequiredIn	query	DateTime[]	No
PlannedStartDate	query	DateTime?	No
PlannedStartDateGreaterThanOrEqualTo	query	DateTime?	No
PlannedStartDateGreaterThan	query	DateTime?	No
PlannedStartDateLessThan	query	DateTime?	No
PlannedStartDateLessThanOrEqualTo	query	DateTime?	No
PlannedStartDateNotEqualTo	query	DateTime?	No
PlannedStartDateBetween	query	DateTime[]	No
PlannedStartDateIn	query	DateTime[]	No
ActualStartDate	query	DateTime?	No
ActualStartDateGreaterThanOrEqualTo	query	DateTime?	No
ActualStartDateGreaterThan	query	DateTime?	No
ActualStartDateLessThan	query	DateTime?	No
ActualStartDateLessThanOrEqualTo	query	DateTime?	No
ActualStartDateNotEqualTo	query	DateTime?	No
ActualStartDateBetween	query	DateTime[]	No
ActualStartDateIn	query	DateTime[]	No
DateCompleted	query	DateTime?	No
DateCompletedGreaterThanOrEqualTo	query	DateTime?	No
DateCompletedGreaterThan	query	DateTime?	No
DateCompletedLessThan	query	DateTime?	No
DateCompletedLessThanOrEqualTo	query	DateTime?	No
DateCompletedNotEqualTo	query	DateTime?	No
DateCompletedBetween	query	DateTime[]	No
DateCompletedIn	query	DateTime[]	No
ProductionQuantity	query	decimal?	No
ProductionQuantityGreaterThanOrEqualTo	query	decimal?	No
ProductionQuantityGreaterThan	query	decimal?	No
ProductionQuantityLessThan	query	decimal?	No
ProductionQuantityLessThanOrEqualTo	query	decimal?	No
ProductionQuantityNotEqualTo	query	decimal?	No
ProductionQuantityBetween	query	decimal[]	No
ProductionQuantityIn	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
BM_WarehouseProductionLine_RecID	query	string	No
BM_WarehouseProductionLine_RecIDStartsWith	query	string	No
BM_WarehouseProductionLine_RecIDEndsWith	query	string	No
BM_WarehouseProductionLine_RecIDContains	query	string	No
BM_WarehouseProductionLine_RecIDLike	query	string	No
BM_WarehouseProductionLine_RecIDBetween	query	string[]	No
BM_WarehouseProductionLine_RecIDIn	query	string[]	No
Status	query	int?	No
StatusGreaterThanOrEqualTo	query	int?	No
StatusGreaterThan	query	int?	No
StatusLessThan	query	int?	No
StatusLessThanOrEqualTo	query	int?	No
StatusNotEqualTo	query	int?	No
StatusBetween	query	int[]	No
StatusIn	query	int[]	No
Parent_BM_WorkOrder_RecID	query	string	No
Parent_BM_WorkOrder_RecIDStartsWith	query	string	No
Parent_BM_WorkOrder_RecIDEndsWith	query	string	No
Parent_BM_WorkOrder_RecIDContains	query	string	No
Parent_BM_WorkOrder_RecIDLike	query	string	No
Parent_BM_WorkOrder_RecIDBetween	query	string[]	No
Parent_BM_WorkOrder_RecIDIn	query	string[]	No
Parent_BM_WorkOrderInputs_RecID	query	string	No
Parent_BM_WorkOrderInputs_RecIDStartsWith	query	string	No
Parent_BM_WorkOrderInputs_RecIDEndsWith	query	string	No
Parent_BM_WorkOrderInputs_RecIDContains	query	string	No
Parent_BM_WorkOrderInputs_RecIDLike	query	string	No
Parent_BM_WorkOrderInputs_RecIDBetween	query	string[]	No
Parent_BM_WorkOrderInputs_RecIDIn	query	string[]	No
WorkOrderType	query	byte?	No
WorkOrderTypeGreaterThanOrEqualTo	query	byte?	No
WorkOrderTypeGreaterThan	query	byte?	No
WorkOrderTypeLessThan	query	byte?	No
WorkOrderTypeLessThanOrEqualTo	query	byte?	No
WorkOrderTypeNotEqualTo	query	byte?	No
WorkOrderTypeBetween	query	byte[]	No
WorkOrderTypeIn	query	byte[]	No
Reversal_BM_WorkOrder_RecID	query	string	No
Reversal_BM_WorkOrder_RecIDStartsWith	query	string	No
Reversal_BM_WorkOrder_RecIDEndsWith	query	string	No
Reversal_BM_WorkOrder_RecIDContains	query	string	No
Reversal_BM_WorkOrder_RecIDLike	query	string	No
Reversal_BM_WorkOrder_RecIDBetween	query	string[]	No
Reversal_BM_WorkOrder_RecIDIn	query	string[]	No
Migrated	query	bool?	No
SO_Lines_InvoiceLineID	query	string	No
SO_Lines_InvoiceLineIDStartsWith	query	string	No
SO_Lines_InvoiceLineIDEndsWith	query	string	No
SO_Lines_InvoiceLineIDContains	query	string	No
SO_Lines_InvoiceLineIDLike	query	string	No
SO_Lines_InvoiceLineIDBetween	query	string[]	No
SO_Lines_InvoiceLineIDIn	query	string[]	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_WorkOrder** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
WorkOrderNo	form	string	No
Reference	form	string	No
BM_Main_RecID	form	string	No
IN_LogicalID	form	string	No
DateCreated	form	DateTime	No
DateRequired	form	DateTime	No
PlannedStartDate	form	DateTime	No
ActualStartDate	form	DateTime	No
DateCompleted	form	DateTime	No
ProductionQuantity	form	decimal	No
LastSavedDateTime	form	DateTime	No
RowHash	form	byte[]	No
BM_WarehouseProductionLine_RecID	form	string	No
Status	form	int	No
Parent_BM_WorkOrder_RecID	form	string	No
Parent_BM_WorkOrderInputs_RecID	form	string	No
WorkOrderType	form	byte	No
Reversal_BM_WorkOrder_RecID	form	string	No
Migrated	form	bool?	No
SO_Lines_InvoiceLineID	form	string	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 .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /Queries/BM_WorkOrder HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"RecID":"String","WorkOrderNo":"String","Reference":"String","BM_Main_RecID":"String","IN_LogicalID":"String","RowHash":"AA==","BM_WarehouseProductionLine_RecID":"String","Parent_BM_WorkOrder_RecID":"String","Parent_BM_WorkOrderInputs_RecID":"String","Reversal_BM_WorkOrder_RecID":"String","Migrated":false,"SO_Lines_InvoiceLineID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}