JiwaAPI

<back to all web services

V_JB_JobCodeSearchQuery

Requires Authentication
V_JB_JobCodeSearchQuery Parameters:
NameParameterData TypeRequiredDescription
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
JobNoquerystringNo
JobNoStartsWithquerystringNo
JobNoEndsWithquerystringNo
JobNoContainsquerystringNo
JobNoLikequerystringNo
JobNoBetweenquerystring[]No
JobNoInquerystring[]No
JobDescriptionquerystringNo
JobDescriptionStartsWithquerystringNo
JobDescriptionEndsWithquerystringNo
JobDescriptionContainsquerystringNo
JobDescriptionLikequerystringNo
JobDescriptionBetweenquerystring[]No
JobDescriptionInquerystring[]No
CostCentreIDquerystringNo
CostCentreIDStartsWithquerystringNo
CostCentreIDEndsWithquerystringNo
CostCentreIDContainsquerystringNo
CostCentreIDLikequerystringNo
CostCentreIDBetweenquerystring[]No
CostCentreIDInquerystring[]No
CostCentreNoquerystringNo
CostCentreNoStartsWithquerystringNo
CostCentreNoEndsWithquerystringNo
CostCentreNoContainsquerystringNo
CostCentreNoLikequerystringNo
CostCentreNoBetweenquerystring[]No
CostCentreNoInquerystring[]No
CostCentreDescquerystringNo
CostCentreDescStartsWithquerystringNo
CostCentreDescEndsWithquerystringNo
CostCentreDescContainsquerystringNo
CostCentreDescLikequerystringNo
CostCentreDescBetweenquerystring[]No
CostCentreDescInquerystring[]No
StageIDquerystringNo
StageIDStartsWithquerystringNo
StageIDEndsWithquerystringNo
StageIDContainsquerystringNo
StageIDLikequerystringNo
StageIDBetweenquerystring[]No
StageIDInquerystring[]No
StageNoquerystringNo
StageNoStartsWithquerystringNo
StageNoEndsWithquerystringNo
StageNoContainsquerystringNo
StageNoLikequerystringNo
StageNoBetweenquerystring[]No
StageNoInquerystring[]No
StageDescquerystringNo
StageDescStartsWithquerystringNo
StageDescEndsWithquerystringNo
StageDescContainsquerystringNo
StageDescLikequerystringNo
StageDescBetweenquerystring[]No
StageDescInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_JB_JobCodeSearch Parameters:
NameParameterData TypeRequiredDescription
JobIDformstringNo
JobNoformstringNo
JobDescriptionformstringNo
CostCentreIDformstringNo
CostCentreNoformstringNo
CostCentreDescformstringNo
StageIDformstringNo
StageNoformstringNo
StageDescformstringNo
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 .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.

POST /csv/reply/V_JB_JobCodeSearchQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
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"],"JobDescription":"String","JobDescriptionStartsWith":"String","JobDescriptionEndsWith":"String","JobDescriptionContains":"String","JobDescriptionLike":"String","JobDescriptionBetween":["String"],"JobDescriptionIn":["String"],"CostCentreID":"String","CostCentreIDStartsWith":"String","CostCentreIDEndsWith":"String","CostCentreIDContains":"String","CostCentreIDLike":"String","CostCentreIDBetween":["String"],"CostCentreIDIn":["String"],"CostCentreNo":"String","CostCentreNoStartsWith":"String","CostCentreNoEndsWith":"String","CostCentreNoContains":"String","CostCentreNoLike":"String","CostCentreNoBetween":["String"],"CostCentreNoIn":["String"],"CostCentreDesc":"String","CostCentreDescStartsWith":"String","CostCentreDescEndsWith":"String","CostCentreDescContains":"String","CostCentreDescLike":"String","CostCentreDescBetween":["String"],"CostCentreDescIn":["String"],"StageID":"String","StageIDStartsWith":"String","StageIDEndsWith":"String","StageIDContains":"String","StageIDLike":"String","StageIDBetween":["String"],"StageIDIn":["String"],"StageNo":"String","StageNoStartsWith":"String","StageNoEndsWith":"String","StageNoContains":"String","StageNoLike":"String","StageNoBetween":["String"],"StageNoIn":["String"],"StageDesc":"String","StageDescStartsWith":"String","StageDescEndsWith":"String","StageDescContains":"String","StageDescLike":"String","StageDescBetween":["String"],"StageDescIn":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

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

{"Results":[{"JobID":"String","JobNo":"String","JobDescription":"String","CostCentreID":"String","CostCentreNo":"String","CostCentreDesc":"String","StageID":"String","StageNo":"String","StageDesc":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}