JiwaAPI

<back to all web services

v_JobsWithActiveTaskQuery

Requires Authentication
v_JobsWithActiveTaskQuery Parameters:
NameParameterData TypeRequiredDescription
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
JobNoquerystringNo
JobNoStartsWithquerystringNo
JobNoEndsWithquerystringNo
JobNoContainsquerystringNo
JobNoLikequerystringNo
JobNoBetweenquerystring[]No
JobNoInquerystring[]No
DB_Main_RecIDquerystringNo
DB_Main_RecIDStartsWithquerystringNo
DB_Main_RecIDEndsWithquerystringNo
DB_Main_RecIDContainsquerystringNo
DB_Main_RecIDLikequerystringNo
DB_Main_RecIDBetweenquerystring[]No
DB_Main_RecIDInquerystring[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
JobDescriptionquerystringNo
JobDescriptionStartsWithquerystringNo
JobDescriptionEndsWithquerystringNo
JobDescriptionContainsquerystringNo
JobDescriptionLikequerystringNo
JobDescriptionBetweenquerystring[]No
JobDescriptionInquerystring[]No
CoordinatorNamequerystringNo
CoordinatorNameStartsWithquerystringNo
CoordinatorNameEndsWithquerystringNo
CoordinatorNameContainsquerystringNo
CoordinatorNameLikequerystringNo
CoordinatorNameBetweenquerystring[]No
CoordinatorNameInquerystring[]No
JobDateLoggedqueryDateTime?No
JobDateLoggedGreaterThanOrEqualToqueryDateTime?No
JobDateLoggedGreaterThanqueryDateTime?No
JobDateLoggedLessThanqueryDateTime?No
JobDateLoggedLessThanOrEqualToqueryDateTime?No
JobDateLoggedNotEqualToqueryDateTime?No
JobDateLoggedBetweenqueryNullable<DateTime>[]No
JobDateLoggedInqueryNullable<DateTime>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_JobsWithActiveTask Parameters:
NameParameterData TypeRequiredDescription
JobIDformstringNo
JobNoformstringNo
DB_Main_RecIDformstringNo
AccountNoformstringNo
NameformstringNo
JobDescriptionformstringNo
CoordinatorNameformstringNo
JobDateLoggedformDateTime?No
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/v_JobsWithActiveTaskQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"JobNo":"String","JobNoStartsWith":"String","JobNoEndsWith":"String","JobNoContains":"String","JobNoLike":"String","JobNoBetween":["String"],"JobNoIn":["String"],"DB_Main_RecID":"String","DB_Main_RecIDStartsWith":"String","DB_Main_RecIDEndsWith":"String","DB_Main_RecIDContains":"String","DB_Main_RecIDLike":"String","DB_Main_RecIDBetween":["String"],"DB_Main_RecIDIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"JobDescription":"String","JobDescriptionStartsWith":"String","JobDescriptionEndsWith":"String","JobDescriptionContains":"String","JobDescriptionLike":"String","JobDescriptionBetween":["String"],"JobDescriptionIn":["String"],"CoordinatorName":"String","CoordinatorNameStartsWith":"String","CoordinatorNameEndsWith":"String","CoordinatorNameContains":"String","CoordinatorNameLike":"String","CoordinatorNameBetween":["String"],"CoordinatorNameIn":["String"],"JobDateLogged":"0001-01-01T00:00:00.0000000","JobDateLoggedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedGreaterThan":"0001-01-01T00:00:00.0000000","JobDateLoggedLessThan":"0001-01-01T00:00:00.0000000","JobDateLoggedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedNotEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedBetween":["0001-01-01T00:00:00.0000000"],"JobDateLoggedIn":["0001-01-01T00:00:00.0000000"],"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":[{"JobID":"String","JobNo":"String","DB_Main_RecID":"String","AccountNo":"String","Name":"String","JobDescription":"String","CoordinatorName":"String","JobDateLogged":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}