JiwaAPI

HR_StaffQuery

The following routes are available for this service:
GET	/Queries/HR_Staff	Retrieves a list of staff members.

**HR_StaffQuery** Parameters:
Name	Parameter	Data Type	Required
StaffID	query	string	No
StaffIDStartsWith	query	string	No
StaffIDEndsWith	query	string	No
StaffIDContains	query	string	No
StaffIDLike	query	string	No
StaffIDBetween	query	string[]	No
StaffIDIn	query	string[]	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	Nullable<DateTime>[]	No
LastSavedDateTimeIn	query	Nullable<DateTime>[]	No
Title	query	string	No
TitleStartsWith	query	string	No
TitleEndsWith	query	string	No
TitleContains	query	string	No
TitleLike	query	string	No
TitleBetween	query	string[]	No
TitleIn	query	string[]	No
FName	query	string	No
FNameStartsWith	query	string	No
FNameEndsWith	query	string	No
FNameContains	query	string	No
FNameLike	query	string	No
FNameBetween	query	string[]	No
FNameIn	query	string[]	No
SName	query	string	No
SNameStartsWith	query	string	No
SNameEndsWith	query	string	No
SNameContains	query	string	No
SNameLike	query	string	No
SNameBetween	query	string[]	No
SNameIn	query	string[]	No
Position1	query	string	No
Position1StartsWith	query	string	No
Position1EndsWith	query	string	No
Position1Contains	query	string	No
Position1Like	query	string	No
Position1Between	query	string[]	No
Position1In	query	string[]	No
Position2	query	string	No
Position2StartsWith	query	string	No
Position2EndsWith	query	string	No
Position2Contains	query	string	No
Position2Like	query	string	No
Position2Between	query	string[]	No
Position2In	query	string[]	No
Password	query	string	No
PasswordStartsWith	query	string	No
PasswordEndsWith	query	string	No
PasswordContains	query	string	No
PasswordLike	query	string	No
PasswordBetween	query	string[]	No
PasswordIn	query	string[]	No
IsActive	query	bool?	No
EmailAddress	query	string	No
EmailAddressStartsWith	query	string	No
EmailAddressEndsWith	query	string	No
EmailAddressContains	query	string	No
EmailAddressLike	query	string	No
EmailAddressBetween	query	string[]	No
EmailAddressIn	query	string[]	No
EmailDisplayName	query	string	No
EmailDisplayNameStartsWith	query	string	No
EmailDisplayNameEndsWith	query	string	No
EmailDisplayNameContains	query	string	No
EmailDisplayNameLike	query	string	No
EmailDisplayNameBetween	query	string[]	No
EmailDisplayNameIn	query	string[]	No
SMTPUsername	query	string	No
SMTPUsernameStartsWith	query	string	No
SMTPUsernameEndsWith	query	string	No
SMTPUsernameContains	query	string	No
SMTPUsernameLike	query	string	No
SMTPUsernameBetween	query	string[]	No
SMTPUsernameIn	query	string[]	No
SMTPPassword	query	string	No
SMTPPasswordStartsWith	query	string	No
SMTPPasswordEndsWith	query	string	No
SMTPPasswordContains	query	string	No
SMTPPasswordLike	query	string	No
SMTPPasswordBetween	query	string[]	No
SMTPPasswordIn	query	string[]	No
Username	query	string	No
UsernameStartsWith	query	string	No
UsernameEndsWith	query	string	No
UsernameContains	query	string	No
UsernameLike	query	string	No
UsernameBetween	query	string[]	No
UsernameIn	query	string[]	No
MustChangePasswordNextLogin	query	bool?	No
PasswordLastChangedDateTime	query	DateTime?	No
PasswordLastChangedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
PasswordLastChangedDateTimeGreaterThan	query	DateTime?	No
PasswordLastChangedDateTimeLessThan	query	DateTime?	No
PasswordLastChangedDateTimeLessThanOrEqualTo	query	DateTime?	No
PasswordLastChangedDateTimeNotEqualTo	query	DateTime?	No
PasswordLastChangedDateTimeBetween	query	Nullable<DateTime>[]	No
PasswordLastChangedDateTimeIn	query	Nullable<DateTime>[]	No
SQLLogin	query	string	No
SQLLoginStartsWith	query	string	No
SQLLoginEndsWith	query	string	No
SQLLoginContains	query	string	No
SQLLoginLike	query	string	No
SQLLoginBetween	query	string[]	No
SQLLoginIn	query	string[]	No
SQLPassword	query	string	No
SQLPasswordStartsWith	query	string	No
SQLPasswordEndsWith	query	string	No
SQLPasswordContains	query	string	No
SQLPasswordLike	query	string	No
SQLPasswordBetween	query	string[]	No
SQLPasswordIn	query	string[]	No
ReportSQLLogin	query	string	No
ReportSQLLoginStartsWith	query	string	No
ReportSQLLoginEndsWith	query	string	No
ReportSQLLoginContains	query	string	No
ReportSQLLoginLike	query	string	No
ReportSQLLoginBetween	query	string[]	No
ReportSQLLoginIn	query	string[]	No
ReportSQLPassword	query	string	No
ReportSQLPasswordStartsWith	query	string	No
ReportSQLPasswordEndsWith	query	string	No
ReportSQLPasswordContains	query	string	No
ReportSQLPasswordLike	query	string	No
ReportSQLPasswordBetween	query	string[]	No
ReportSQLPasswordIn	query	string[]	No
Picture	query	byte[]	No
HR_Departments_RecID	query	string	No
HR_Departments_RecIDStartsWith	query	string	No
HR_Departments_RecIDEndsWith	query	string	No
HR_Departments_RecIDContains	query	string	No
HR_Departments_RecIDLike	query	string	No
HR_Departments_RecIDBetween	query	string[]	No
HR_Departments_RecIDIn	query	string[]	No
Extension	query	string	No
ExtensionStartsWith	query	string	No
ExtensionEndsWith	query	string	No
ExtensionContains	query	string	No
ExtensionLike	query	string	No
ExtensionBetween	query	string[]	No
ExtensionIn	query	string[]	No
Mobile	query	string	No
MobileStartsWith	query	string	No
MobileEndsWith	query	string	No
MobileContains	query	string	No
MobileLike	query	string	No
MobileBetween	query	string[]	No
MobileIn	query	string[]	No
UsePrepaidLabourPacks	query	bool?	No
AuthenticationModes	query	byte?	No
AuthenticationModesGreaterThanOrEqualTo	query	byte?	No
AuthenticationModesGreaterThan	query	byte?	No
AuthenticationModesLessThan	query	byte?	No
AuthenticationModesLessThanOrEqualTo	query	byte?	No
AuthenticationModesNotEqualTo	query	byte?	No
AuthenticationModesBetween	query	byte[]	No
AuthenticationModesIn	query	byte[]	No
WindowsDomainAccount	query	string	No
WindowsDomainAccountStartsWith	query	string	No
WindowsDomainAccountEndsWith	query	string	No
WindowsDomainAccountContains	query	string	No
WindowsDomainAccountLike	query	string	No
WindowsDomainAccountBetween	query	string[]	No
WindowsDomainAccountIn	query	string[]	No
SMTPPasswordLastChangedDateTime	query	DateTime?	No
SMTPPasswordLastChangedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
SMTPPasswordLastChangedDateTimeGreaterThan	query	DateTime?	No
SMTPPasswordLastChangedDateTimeLessThan	query	DateTime?	No
SMTPPasswordLastChangedDateTimeLessThanOrEqualTo	query	DateTime?	No
SMTPPasswordLastChangedDateTimeNotEqualTo	query	DateTime?	No
SMTPPasswordLastChangedDateTimeBetween	query	Nullable<DateTime>[]	No
SMTPPasswordLastChangedDateTimeIn	query	Nullable<DateTime>[]	No
SY_Menu_RecID	query	string	No
SY_Menu_RecIDStartsWith	query	string	No
SY_Menu_RecIDEndsWith	query	string	No
SY_Menu_RecIDContains	query	string	No
SY_Menu_RecIDLike	query	string	No
SY_Menu_RecIDBetween	query	string[]	No
SY_Menu_RecIDIn	query	string[]	No
SY_PrintGroup_RecID	query	string	No
SY_PrintGroup_RecIDStartsWith	query	string	No
SY_PrintGroup_RecIDEndsWith	query	string	No
SY_PrintGroup_RecIDContains	query	string	No
SY_PrintGroup_RecIDLike	query	string	No
SY_PrintGroup_RecIDBetween	query	string[]	No
SY_PrintGroup_RecIDIn	query	string[]	No
SQLLoginLastSavedDateTime	query	DateTime?	No
SQLLoginLastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
SQLLoginLastSavedDateTimeGreaterThan	query	DateTime?	No
SQLLoginLastSavedDateTimeLessThan	query	DateTime?	No
SQLLoginLastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
SQLLoginLastSavedDateTimeNotEqualTo	query	DateTime?	No
SQLLoginLastSavedDateTimeBetween	query	DateTime[]	No
SQLLoginLastSavedDateTimeIn	query	DateTime[]	No
ReportsLoginLastSavedDateTime	query	DateTime?	No
ReportsLoginLastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
ReportsLoginLastSavedDateTimeGreaterThan	query	DateTime?	No
ReportsLoginLastSavedDateTimeLessThan	query	DateTime?	No
ReportsLoginLastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
ReportsLoginLastSavedDateTimeNotEqualTo	query	DateTime?	No
ReportsLoginLastSavedDateTimeBetween	query	DateTime[]	No
ReportsLoginLastSavedDateTimeIn	query	DateTime[]	No
IsEnabled	query	bool?	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

**HR_Staff** Parameters:
Name	Parameter	Data Type	Required
StaffID	form	string	No
LastSavedDateTime	form	DateTime?	No
Title	form	string	No
FName	form	string	No
SName	form	string	No
Position1	form	string	No
Position2	form	string	No
Password	form	string	No
IsActive	form	bool?	No
EmailAddress	form	string	No
EmailDisplayName	form	string	No
SMTPUsername	form	string	No
SMTPPassword	form	string	No
Username	form	string	No
MustChangePasswordNextLogin	form	bool?	No
PasswordLastChangedDateTime	form	DateTime?	No
SQLLogin	form	string	No
SQLPassword	form	string	No
ReportSQLLogin	form	string	No
ReportSQLPassword	form	string	No
Picture	form	byte[]	No
HR_Departments_RecID	form	string	No
Extension	form	string	No
Mobile	form	string	No
UsePrepaidLabourPacks	form	bool?	No
AuthenticationModes	form	byte	No
WindowsDomainAccount	form	string	No
SMTPPasswordLastChangedDateTime	form	DateTime?	No
SY_Menu_RecID	form	string	No
SY_PrintGroup_RecID	form	string	No
SQLLoginLastSavedDateTime	form	DateTime	No
ReportsLoginLastSavedDateTime	form	DateTime	No
IsEnabled	form	bool	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/HR_Staff HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv

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

{"Results":[{"StaffID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","Title":"String","FName":"String","SName":"String","Position1":"String","Position2":"String","Password":"String","IsActive":false,"EmailAddress":"String","EmailDisplayName":"String","SMTPUsername":"String","SMTPPassword":"String","Username":"String","MustChangePasswordNextLogin":false,"PasswordLastChangedDateTime":"0001-01-01T00:00:00.0000000","SQLLogin":"String","SQLPassword":"String","ReportSQLLogin":"String","ReportSQLPassword":"String","Picture":"AA==","HR_Departments_RecID":"String","Extension":"String","Mobile":"String","UsePrepaidLabourPacks":false,"WindowsDomainAccount":"String","SMTPPasswordLastChangedDateTime":"0001-01-01T00:00:00.0000000","SY_Menu_RecID":"String","SY_PrintGroup_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"}}}