JiwaAPI

<back to all web services

SM_LabourQuery

Requires Authentication
SM_LabourQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
IN_Main_RecIDquerystringNo
IN_Main_RecIDStartsWithquerystringNo
IN_Main_RecIDEndsWithquerystringNo
IN_Main_RecIDContainsquerystringNo
IN_Main_RecIDLikequerystringNo
IN_Main_RecIDBetweenquerystring[]No
IN_Main_RecIDInquerystring[]No
SM_Tasks_RecIDquerystringNo
SM_Tasks_RecIDStartsWithquerystringNo
SM_Tasks_RecIDEndsWithquerystringNo
SM_Tasks_RecIDContainsquerystringNo
SM_Tasks_RecIDLikequerystringNo
SM_Tasks_RecIDBetweenquerystring[]No
SM_Tasks_RecIDInquerystring[]No
StaffIDquerystringNo
StaffIDStartsWithquerystringNo
StaffIDEndsWithquerystringNo
StaffIDContainsquerystringNo
StaffIDLikequerystringNo
StaffIDBetweenquerystring[]No
StaffIDInquerystring[]No
StartTimequeryDateTime?No
StartTimeGreaterThanOrEqualToqueryDateTime?No
StartTimeGreaterThanqueryDateTime?No
StartTimeLessThanqueryDateTime?No
StartTimeLessThanOrEqualToqueryDateTime?No
StartTimeNotEqualToqueryDateTime?No
StartTimeBetweenqueryDateTime[]No
StartTimeInqueryDateTime[]No
EndTimequeryDateTime?No
EndTimeGreaterThanOrEqualToqueryDateTime?No
EndTimeGreaterThanqueryDateTime?No
EndTimeLessThanqueryDateTime?No
EndTimeLessThanOrEqualToqueryDateTime?No
EndTimeNotEqualToqueryDateTime?No
EndTimeBetweenqueryDateTime[]No
EndTimeInqueryDateTime[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
BillingTimequerydecimal?No
BillingTimeGreaterThanOrEqualToquerydecimal?No
BillingTimeGreaterThanquerydecimal?No
BillingTimeLessThanquerydecimal?No
BillingTimeLessThanOrEqualToquerydecimal?No
BillingTimeNotEqualToquerydecimal?No
BillingTimeBetweenquerydecimal[]No
BillingTimeInquerydecimal[]No
Ratequerydecimal?No
RateGreaterThanOrEqualToquerydecimal?No
RateGreaterThanquerydecimal?No
RateLessThanquerydecimal?No
RateLessThanOrEqualToquerydecimal?No
RateNotEqualToquerydecimal?No
RateBetweenquerydecimal[]No
RateInquerydecimal[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
LastSavedStaffIDquerystringNo
LastSavedStaffIDStartsWithquerystringNo
LastSavedStaffIDEndsWithquerystringNo
LastSavedStaffIDContainsquerystringNo
LastSavedStaffIDLikequerystringNo
LastSavedStaffIDBetweenquerystring[]No
LastSavedStaffIDInquerystring[]No
IsPrepaidquerybool?No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
SitesheetReceivedquerybool?No
TX_Main_RecIDquerystringNo
TX_Main_RecIDStartsWithquerystringNo
TX_Main_RecIDEndsWithquerystringNo
TX_Main_RecIDContainsquerystringNo
TX_Main_RecIDLikequerystringNo
TX_Main_RecIDBetweenquerystring[]No
TX_Main_RecIDInquerystring[]No
Taxquerydecimal?No
TaxGreaterThanOrEqualToquerydecimal?No
TaxGreaterThanquerydecimal?No
TaxLessThanquerydecimal?No
TaxLessThanOrEqualToquerydecimal?No
TaxNotEqualToquerydecimal?No
TaxBetweenquerydecimal[]No
TaxInquerydecimal[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenquerydecimal[]No
TaxRateInquerydecimal[]No
LCostInquerydecimal?No
LCostInGreaterThanOrEqualToquerydecimal?No
LCostInGreaterThanquerydecimal?No
LCostInLessThanquerydecimal?No
LCostInLessThanOrEqualToquerydecimal?No
LCostInNotEqualToquerydecimal?No
LCostInBetweenquerydecimal[]No
LCostInInquerydecimal[]No
SM_Activities_RecIDquerystringNo
SM_Activities_RecIDStartsWithquerystringNo
SM_Activities_RecIDEndsWithquerystringNo
SM_Activities_RecIDContainsquerystringNo
SM_Activities_RecIDLikequerystringNo
SM_Activities_RecIDBetweenquerystring[]No
SM_Activities_RecIDInquerystring[]No
SO_Lines_RecIDquerystringNo
SO_Lines_RecIDStartsWithquerystringNo
SO_Lines_RecIDEndsWithquerystringNo
SO_Lines_RecIDContainsquerystringNo
SO_Lines_RecIDLikequerystringNo
SO_Lines_RecIDBetweenquerystring[]No
SO_Lines_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_Labour Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
IN_Main_RecIDformstringNo
SM_Tasks_RecIDformstringNo
StaffIDformstringNo
StartTimeformDateTimeNo
EndTimeformDateTimeNo
DescriptionformstringNo
BillingTimeformdecimalNo
RateformdecimalNo
LastSavedDateTimeformDateTimeNo
LastSavedStaffIDformstringNo
IsPrepaidformboolNo
ItemNoformintNo
SitesheetReceivedformboolNo
TX_Main_RecIDformstringNo
TaxformdecimalNo
TaxRateformdecimalNo
LCostInformdecimalNo
SM_Activities_RecIDformstringNo
SO_Lines_RecIDformstringNo
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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /json/reply/SM_LabourQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"IN_Main_RecID":"String","IN_Main_RecIDStartsWith":"String","IN_Main_RecIDEndsWith":"String","IN_Main_RecIDContains":"String","IN_Main_RecIDLike":"String","IN_Main_RecIDBetween":["String"],"IN_Main_RecIDIn":["String"],"SM_Tasks_RecID":"String","SM_Tasks_RecIDStartsWith":"String","SM_Tasks_RecIDEndsWith":"String","SM_Tasks_RecIDContains":"String","SM_Tasks_RecIDLike":"String","SM_Tasks_RecIDBetween":["String"],"SM_Tasks_RecIDIn":["String"],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"StartTime":"0001-01-01T00:00:00.0000000","StartTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","StartTimeGreaterThan":"0001-01-01T00:00:00.0000000","StartTimeLessThan":"0001-01-01T00:00:00.0000000","StartTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","StartTimeNotEqualTo":"0001-01-01T00:00:00.0000000","StartTimeBetween":["0001-01-01T00:00:00.0000000"],"StartTimeIn":["0001-01-01T00:00:00.0000000"],"EndTime":"0001-01-01T00:00:00.0000000","EndTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","EndTimeGreaterThan":"0001-01-01T00:00:00.0000000","EndTimeLessThan":"0001-01-01T00:00:00.0000000","EndTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","EndTimeNotEqualTo":"0001-01-01T00:00:00.0000000","EndTimeBetween":["0001-01-01T00:00:00.0000000"],"EndTimeIn":["0001-01-01T00:00:00.0000000"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"BillingTime":0,"BillingTimeGreaterThanOrEqualTo":0,"BillingTimeGreaterThan":0,"BillingTimeLessThan":0,"BillingTimeLessThanOrEqualTo":0,"BillingTimeNotEqualTo":0,"BillingTimeBetween":[0],"BillingTimeIn":[0],"Rate":0,"RateGreaterThanOrEqualTo":0,"RateGreaterThan":0,"RateLessThan":0,"RateLessThanOrEqualTo":0,"RateNotEqualTo":0,"RateBetween":[0],"RateIn":[0],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"LastSavedStaffID":"String","LastSavedStaffIDStartsWith":"String","LastSavedStaffIDEndsWith":"String","LastSavedStaffIDContains":"String","LastSavedStaffIDLike":"String","LastSavedStaffIDBetween":["String"],"LastSavedStaffIDIn":["String"],"IsPrepaid":false,"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"SitesheetReceived":false,"TX_Main_RecID":"String","TX_Main_RecIDStartsWith":"String","TX_Main_RecIDEndsWith":"String","TX_Main_RecIDContains":"String","TX_Main_RecIDLike":"String","TX_Main_RecIDBetween":["String"],"TX_Main_RecIDIn":["String"],"Tax":0,"TaxGreaterThanOrEqualTo":0,"TaxGreaterThan":0,"TaxLessThan":0,"TaxLessThanOrEqualTo":0,"TaxNotEqualTo":0,"TaxBetween":[0],"TaxIn":[0],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"LCostIn":0,"LCostInGreaterThanOrEqualTo":0,"LCostInGreaterThan":0,"LCostInLessThan":0,"LCostInLessThanOrEqualTo":0,"LCostInNotEqualTo":0,"LCostInBetween":[0],"LCostInIn":[0],"SM_Activities_RecID":"String","SM_Activities_RecIDStartsWith":"String","SM_Activities_RecIDEndsWith":"String","SM_Activities_RecIDContains":"String","SM_Activities_RecIDLike":"String","SM_Activities_RecIDBetween":["String"],"SM_Activities_RecIDIn":["String"],"SO_Lines_RecID":"String","SO_Lines_RecIDStartsWith":"String","SO_Lines_RecIDEndsWith":"String","SO_Lines_RecIDContains":"String","SO_Lines_RecIDLike":"String","SO_Lines_RecIDBetween":["String"],"SO_Lines_RecIDIn":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"RecID":"String","IN_Main_RecID":"String","SM_Tasks_RecID":"String","StaffID":"String","Description":"String","LastSavedStaffID":"String","TX_Main_RecID":"String","SM_Activities_RecID":"String","SO_Lines_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}