JiwaAPI

<back to all web services

SM_TasksQuery

Requires Authentication
SM_TasksQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
TaskNoqueryint?No
TaskNoGreaterThanOrEqualToqueryint?No
TaskNoGreaterThanqueryint?No
TaskNoLessThanqueryint?No
TaskNoLessThanOrEqualToqueryint?No
TaskNoNotEqualToqueryint?No
TaskNoBetweenqueryint[]No
TaskNoInqueryint[]No
SM_Jobs_RecIDquerystringNo
SM_Jobs_RecIDStartsWithquerystringNo
SM_Jobs_RecIDEndsWithquerystringNo
SM_Jobs_RecIDContainsquerystringNo
SM_Jobs_RecIDLikequerystringNo
SM_Jobs_RecIDBetweenquerystring[]No
SM_Jobs_RecIDInquerystring[]No
HR_Departments_RecIDquerystringNo
HR_Departments_RecIDStartsWithquerystringNo
HR_Departments_RecIDEndsWithquerystringNo
HR_Departments_RecIDContainsquerystringNo
HR_Departments_RecIDLikequerystringNo
HR_Departments_RecIDBetweenquerystring[]No
HR_Departments_RecIDInquerystring[]No
HR_DepartmentCategories_RecIDquerystringNo
HR_DepartmentCategories_RecIDStartsWithquerystringNo
HR_DepartmentCategories_RecIDEndsWithquerystringNo
HR_DepartmentCategories_RecIDContainsquerystringNo
HR_DepartmentCategories_RecIDLikequerystringNo
HR_DepartmentCategories_RecIDBetweenquerystring[]No
HR_DepartmentCategories_RecIDInquerystring[]No
SM_Priorities_RecIDquerystringNo
SM_Priorities_RecIDStartsWithquerystringNo
SM_Priorities_RecIDEndsWithquerystringNo
SM_Priorities_RecIDContainsquerystringNo
SM_Priorities_RecIDLikequerystringNo
SM_Priorities_RecIDBetweenquerystring[]No
SM_Priorities_RecIDInquerystring[]No
SM_Statuses_RecIDquerystringNo
SM_Statuses_RecIDStartsWithquerystringNo
SM_Statuses_RecIDEndsWithquerystringNo
SM_Statuses_RecIDContainsquerystringNo
SM_Statuses_RecIDLikequerystringNo
SM_Statuses_RecIDBetweenquerystring[]No
SM_Statuses_RecIDInquerystring[]No
AssignedTo_HR_Staff_RecIDquerystringNo
AssignedTo_HR_Staff_RecIDStartsWithquerystringNo
AssignedTo_HR_Staff_RecIDEndsWithquerystringNo
AssignedTo_HR_Staff_RecIDContainsquerystringNo
AssignedTo_HR_Staff_RecIDLikequerystringNo
AssignedTo_HR_Staff_RecIDBetweenquerystring[]No
AssignedTo_HR_Staff_RecIDInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
NotequerystringNo
NoteStartsWithquerystringNo
NoteEndsWithquerystringNo
NoteContainsquerystringNo
NoteLikequerystringNo
NoteBetweenquerystring[]No
NoteInquerystring[]No
DateLoggedqueryDateTime?No
DateLoggedGreaterThanOrEqualToqueryDateTime?No
DateLoggedGreaterThanqueryDateTime?No
DateLoggedLessThanqueryDateTime?No
DateLoggedLessThanOrEqualToqueryDateTime?No
DateLoggedNotEqualToqueryDateTime?No
DateLoggedBetweenqueryDateTime[]No
DateLoggedInqueryDateTime[]No
LoggedBy_HR_Staff_RecIDquerystringNo
LoggedBy_HR_Staff_RecIDStartsWithquerystringNo
LoggedBy_HR_Staff_RecIDEndsWithquerystringNo
LoggedBy_HR_Staff_RecIDContainsquerystringNo
LoggedBy_HR_Staff_RecIDLikequerystringNo
LoggedBy_HR_Staff_RecIDBetweenquerystring[]No
LoggedBy_HR_Staff_RecIDInquerystring[]No
HasDeadlinequerybool?No
DeadlinequeryDateTime?No
DeadlineGreaterThanOrEqualToqueryDateTime?No
DeadlineGreaterThanqueryDateTime?No
DeadlineLessThanqueryDateTime?No
DeadlineLessThanOrEqualToqueryDateTime?No
DeadlineNotEqualToqueryDateTime?No
DeadlineBetweenqueryNullable<DateTime>[]No
DeadlineInqueryNullable<DateTime>[]No
CompletionDatequeryDateTime?No
CompletionDateGreaterThanOrEqualToqueryDateTime?No
CompletionDateGreaterThanqueryDateTime?No
CompletionDateLessThanqueryDateTime?No
CompletionDateLessThanOrEqualToqueryDateTime?No
CompletionDateNotEqualToqueryDateTime?No
CompletionDateBetweenqueryNullable<DateTime>[]No
CompletionDateInqueryNullable<DateTime>[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
LastSaved_HR_Staff_RecIDquerystringNo
LastSaved_HR_Staff_RecIDStartsWithquerystringNo
LastSaved_HR_Staff_RecIDEndsWithquerystringNo
LastSaved_HR_Staff_RecIDContainsquerystringNo
LastSaved_HR_Staff_RecIDLikequerystringNo
LastSaved_HR_Staff_RecIDBetweenquerystring[]No
LastSaved_HR_Staff_RecIDInquerystring[]No
SM_PrepaidLabourPacks_RecIDquerystringNo
SM_PrepaidLabourPacks_RecIDStartsWithquerystringNo
SM_PrepaidLabourPacks_RecIDEndsWithquerystringNo
SM_PrepaidLabourPacks_RecIDContainsquerystringNo
SM_PrepaidLabourPacks_RecIDLikequerystringNo
SM_PrepaidLabourPacks_RecIDBetweenquerystring[]No
SM_PrepaidLabourPacks_RecIDInquerystring[]No
DB_DeliveryAddress_RecIDquerystringNo
DB_DeliveryAddress_RecIDStartsWithquerystringNo
DB_DeliveryAddress_RecIDEndsWithquerystringNo
DB_DeliveryAddress_RecIDContainsquerystringNo
DB_DeliveryAddress_RecIDLikequerystringNo
DB_DeliveryAddress_RecIDBetweenquerystring[]No
DB_DeliveryAddress_RecIDInquerystring[]No
DB_DebtorSystems_RecIDquerystringNo
DB_DebtorSystems_RecIDStartsWithquerystringNo
DB_DebtorSystems_RecIDEndsWithquerystringNo
DB_DebtorSystems_RecIDContainsquerystringNo
DB_DebtorSystems_RecIDLikequerystringNo
DB_DebtorSystems_RecIDBetweenquerystring[]No
DB_DebtorSystems_RecIDInquerystring[]No
IsRetiredquerybool?No
RowHashquerybyte[]No
BillingDebtor_DB_Main_RecIDquerystringNo
BillingDebtor_DB_Main_RecIDStartsWithquerystringNo
BillingDebtor_DB_Main_RecIDEndsWithquerystringNo
BillingDebtor_DB_Main_RecIDContainsquerystringNo
BillingDebtor_DB_Main_RecIDLikequerystringNo
BillingDebtor_DB_Main_RecIDBetweenquerystring[]No
BillingDebtor_DB_Main_RecIDInquerystring[]No
BillingDebtor_DB_DeliveryAddress_RecIDquerystringNo
BillingDebtor_DB_DeliveryAddress_RecIDStartsWithquerystringNo
BillingDebtor_DB_DeliveryAddress_RecIDEndsWithquerystringNo
BillingDebtor_DB_DeliveryAddress_RecIDContainsquerystringNo
BillingDebtor_DB_DeliveryAddress_RecIDLikequerystringNo
BillingDebtor_DB_DeliveryAddress_RecIDBetweenquerystring[]No
BillingDebtor_DB_DeliveryAddress_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_Tasks Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
TaskNoformintNo
SM_Jobs_RecIDformstringNo
HR_Departments_RecIDformstringNo
HR_DepartmentCategories_RecIDformstringNo
SM_Priorities_RecIDformstringNo
SM_Statuses_RecIDformstringNo
AssignedTo_HR_Staff_RecIDformstringNo
DescriptionformstringNo
NoteformstringNo
DateLoggedformDateTimeNo
LoggedBy_HR_Staff_RecIDformstringNo
HasDeadlineformbool?No
DeadlineformDateTime?No
CompletionDateformDateTime?No
LastSavedDateTimeformDateTimeNo
LastSaved_HR_Staff_RecIDformstringNo
SM_PrepaidLabourPacks_RecIDformstringNo
DB_DeliveryAddress_RecIDformstringNo
DB_DebtorSystems_RecIDformstringNo
IsRetiredformbool?No
RowHashformbyte[]No
BillingDebtor_DB_Main_RecIDformstringNo
BillingDebtor_DB_DeliveryAddress_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 .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/SM_TasksQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"TaskNo":0,"TaskNoGreaterThanOrEqualTo":0,"TaskNoGreaterThan":0,"TaskNoLessThan":0,"TaskNoLessThanOrEqualTo":0,"TaskNoNotEqualTo":0,"TaskNoBetween":[0],"TaskNoIn":[0],"SM_Jobs_RecID":"String","SM_Jobs_RecIDStartsWith":"String","SM_Jobs_RecIDEndsWith":"String","SM_Jobs_RecIDContains":"String","SM_Jobs_RecIDLike":"String","SM_Jobs_RecIDBetween":["String"],"SM_Jobs_RecIDIn":["String"],"HR_Departments_RecID":"String","HR_Departments_RecIDStartsWith":"String","HR_Departments_RecIDEndsWith":"String","HR_Departments_RecIDContains":"String","HR_Departments_RecIDLike":"String","HR_Departments_RecIDBetween":["String"],"HR_Departments_RecIDIn":["String"],"HR_DepartmentCategories_RecID":"String","HR_DepartmentCategories_RecIDStartsWith":"String","HR_DepartmentCategories_RecIDEndsWith":"String","HR_DepartmentCategories_RecIDContains":"String","HR_DepartmentCategories_RecIDLike":"String","HR_DepartmentCategories_RecIDBetween":["String"],"HR_DepartmentCategories_RecIDIn":["String"],"SM_Priorities_RecID":"String","SM_Priorities_RecIDStartsWith":"String","SM_Priorities_RecIDEndsWith":"String","SM_Priorities_RecIDContains":"String","SM_Priorities_RecIDLike":"String","SM_Priorities_RecIDBetween":["String"],"SM_Priorities_RecIDIn":["String"],"SM_Statuses_RecID":"String","SM_Statuses_RecIDStartsWith":"String","SM_Statuses_RecIDEndsWith":"String","SM_Statuses_RecIDContains":"String","SM_Statuses_RecIDLike":"String","SM_Statuses_RecIDBetween":["String"],"SM_Statuses_RecIDIn":["String"],"AssignedTo_HR_Staff_RecID":"String","AssignedTo_HR_Staff_RecIDStartsWith":"String","AssignedTo_HR_Staff_RecIDEndsWith":"String","AssignedTo_HR_Staff_RecIDContains":"String","AssignedTo_HR_Staff_RecIDLike":"String","AssignedTo_HR_Staff_RecIDBetween":["String"],"AssignedTo_HR_Staff_RecIDIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"Note":"String","NoteStartsWith":"String","NoteEndsWith":"String","NoteContains":"String","NoteLike":"String","NoteBetween":["String"],"NoteIn":["String"],"DateLogged":"0001-01-01T00:00:00.0000000","DateLoggedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateLoggedGreaterThan":"0001-01-01T00:00:00.0000000","DateLoggedLessThan":"0001-01-01T00:00:00.0000000","DateLoggedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DateLoggedNotEqualTo":"0001-01-01T00:00:00.0000000","DateLoggedBetween":["0001-01-01T00:00:00.0000000"],"DateLoggedIn":["0001-01-01T00:00:00.0000000"],"LoggedBy_HR_Staff_RecID":"String","LoggedBy_HR_Staff_RecIDStartsWith":"String","LoggedBy_HR_Staff_RecIDEndsWith":"String","LoggedBy_HR_Staff_RecIDContains":"String","LoggedBy_HR_Staff_RecIDLike":"String","LoggedBy_HR_Staff_RecIDBetween":["String"],"LoggedBy_HR_Staff_RecIDIn":["String"],"HasDeadline":false,"Deadline":"0001-01-01T00:00:00.0000000","DeadlineGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeadlineGreaterThan":"0001-01-01T00:00:00.0000000","DeadlineLessThan":"0001-01-01T00:00:00.0000000","DeadlineLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DeadlineNotEqualTo":"0001-01-01T00:00:00.0000000","DeadlineBetween":["0001-01-01T00:00:00.0000000"],"DeadlineIn":["0001-01-01T00:00:00.0000000"],"CompletionDate":"0001-01-01T00:00:00.0000000","CompletionDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","CompletionDateGreaterThan":"0001-01-01T00:00:00.0000000","CompletionDateLessThan":"0001-01-01T00:00:00.0000000","CompletionDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","CompletionDateNotEqualTo":"0001-01-01T00:00:00.0000000","CompletionDateBetween":["0001-01-01T00:00:00.0000000"],"CompletionDateIn":["0001-01-01T00:00:00.0000000"],"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"],"LastSaved_HR_Staff_RecID":"String","LastSaved_HR_Staff_RecIDStartsWith":"String","LastSaved_HR_Staff_RecIDEndsWith":"String","LastSaved_HR_Staff_RecIDContains":"String","LastSaved_HR_Staff_RecIDLike":"String","LastSaved_HR_Staff_RecIDBetween":["String"],"LastSaved_HR_Staff_RecIDIn":["String"],"SM_PrepaidLabourPacks_RecID":"String","SM_PrepaidLabourPacks_RecIDStartsWith":"String","SM_PrepaidLabourPacks_RecIDEndsWith":"String","SM_PrepaidLabourPacks_RecIDContains":"String","SM_PrepaidLabourPacks_RecIDLike":"String","SM_PrepaidLabourPacks_RecIDBetween":["String"],"SM_PrepaidLabourPacks_RecIDIn":["String"],"DB_DeliveryAddress_RecID":"String","DB_DeliveryAddress_RecIDStartsWith":"String","DB_DeliveryAddress_RecIDEndsWith":"String","DB_DeliveryAddress_RecIDContains":"String","DB_DeliveryAddress_RecIDLike":"String","DB_DeliveryAddress_RecIDBetween":["String"],"DB_DeliveryAddress_RecIDIn":["String"],"DB_DebtorSystems_RecID":"String","DB_DebtorSystems_RecIDStartsWith":"String","DB_DebtorSystems_RecIDEndsWith":"String","DB_DebtorSystems_RecIDContains":"String","DB_DebtorSystems_RecIDLike":"String","DB_DebtorSystems_RecIDBetween":["String"],"DB_DebtorSystems_RecIDIn":["String"],"IsRetired":false,"RowHash":"AA==","BillingDebtor_DB_Main_RecID":"String","BillingDebtor_DB_Main_RecIDStartsWith":"String","BillingDebtor_DB_Main_RecIDEndsWith":"String","BillingDebtor_DB_Main_RecIDContains":"String","BillingDebtor_DB_Main_RecIDLike":"String","BillingDebtor_DB_Main_RecIDBetween":["String"],"BillingDebtor_DB_Main_RecIDIn":["String"],"BillingDebtor_DB_DeliveryAddress_RecID":"String","BillingDebtor_DB_DeliveryAddress_RecIDStartsWith":"String","BillingDebtor_DB_DeliveryAddress_RecIDEndsWith":"String","BillingDebtor_DB_DeliveryAddress_RecIDContains":"String","BillingDebtor_DB_DeliveryAddress_RecIDLike":"String","BillingDebtor_DB_DeliveryAddress_RecIDBetween":["String"],"BillingDebtor_DB_DeliveryAddress_RecIDIn":["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":[{"RecID":"String","SM_Jobs_RecID":"String","HR_Departments_RecID":"String","HR_DepartmentCategories_RecID":"String","SM_Priorities_RecID":"String","SM_Statuses_RecID":"String","AssignedTo_HR_Staff_RecID":"String","Description":"String","Note":"String","LoggedBy_HR_Staff_RecID":"String","HasDeadline":false,"Deadline":"0001-01-01T00:00:00.0000000","CompletionDate":"0001-01-01T00:00:00.0000000","LastSaved_HR_Staff_RecID":"String","SM_PrepaidLabourPacks_RecID":"String","DB_DeliveryAddress_RecID":"String","DB_DebtorSystems_RecID":"String","IsRetired":false,"RowHash":"AA==","BillingDebtor_DB_Main_RecID":"String","BillingDebtor_DB_DeliveryAddress_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"}}}