GET | /Queries/HR_Staff | Retrieves a list of staff members. |
---|
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 |
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 .xml suffix or ?format=xml
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: application/xml
HTTP/1.1 200 OK Content-Type: application/xml Content-Length: length <QueryResponseOfHR_Staff7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types"> <Offset>0</Offset> <Total>0</Total> <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables"> <d2p1:HR_Staff> <d2p1:_x003C_AuthenticationModes_x003E_k__BackingField>0</d2p1:_x003C_AuthenticationModes_x003E_k__BackingField> <d2p1:_x003C_EmailAddress_x003E_k__BackingField>String</d2p1:_x003C_EmailAddress_x003E_k__BackingField> <d2p1:_x003C_EmailDisplayName_x003E_k__BackingField>String</d2p1:_x003C_EmailDisplayName_x003E_k__BackingField> <d2p1:_x003C_Extension_x003E_k__BackingField>String</d2p1:_x003C_Extension_x003E_k__BackingField> <d2p1:_x003C_FName_x003E_k__BackingField>String</d2p1:_x003C_FName_x003E_k__BackingField> <d2p1:_x003C_HR_Departments_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Departments_RecID_x003E_k__BackingField> <d2p1:_x003C_IsActive_x003E_k__BackingField>false</d2p1:_x003C_IsActive_x003E_k__BackingField> <d2p1:_x003C_IsEnabled_x003E_k__BackingField>false</d2p1:_x003C_IsEnabled_x003E_k__BackingField> <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField> <d2p1:_x003C_Mobile_x003E_k__BackingField>String</d2p1:_x003C_Mobile_x003E_k__BackingField> <d2p1:_x003C_MustChangePasswordNextLogin_x003E_k__BackingField>false</d2p1:_x003C_MustChangePasswordNextLogin_x003E_k__BackingField> <d2p1:_x003C_PasswordLastChangedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_PasswordLastChangedDateTime_x003E_k__BackingField> <d2p1:_x003C_Password_x003E_k__BackingField>String</d2p1:_x003C_Password_x003E_k__BackingField> <d2p1:_x003C_Picture_x003E_k__BackingField>AA==</d2p1:_x003C_Picture_x003E_k__BackingField> <d2p1:_x003C_Position1_x003E_k__BackingField>String</d2p1:_x003C_Position1_x003E_k__BackingField> <d2p1:_x003C_Position2_x003E_k__BackingField>String</d2p1:_x003C_Position2_x003E_k__BackingField> <d2p1:_x003C_ReportSQLLogin_x003E_k__BackingField>String</d2p1:_x003C_ReportSQLLogin_x003E_k__BackingField> <d2p1:_x003C_ReportSQLPassword_x003E_k__BackingField>String</d2p1:_x003C_ReportSQLPassword_x003E_k__BackingField> <d2p1:_x003C_ReportsLoginLastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ReportsLoginLastSavedDateTime_x003E_k__BackingField> <d2p1:_x003C_SMTPPasswordLastChangedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_SMTPPasswordLastChangedDateTime_x003E_k__BackingField> <d2p1:_x003C_SMTPPassword_x003E_k__BackingField>String</d2p1:_x003C_SMTPPassword_x003E_k__BackingField> <d2p1:_x003C_SMTPUsername_x003E_k__BackingField>String</d2p1:_x003C_SMTPUsername_x003E_k__BackingField> <d2p1:_x003C_SName_x003E_k__BackingField>String</d2p1:_x003C_SName_x003E_k__BackingField> <d2p1:_x003C_SQLLoginLastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_SQLLoginLastSavedDateTime_x003E_k__BackingField> <d2p1:_x003C_SQLLogin_x003E_k__BackingField>String</d2p1:_x003C_SQLLogin_x003E_k__BackingField> <d2p1:_x003C_SQLPassword_x003E_k__BackingField>String</d2p1:_x003C_SQLPassword_x003E_k__BackingField> <d2p1:_x003C_SY_Menu_RecID_x003E_k__BackingField>String</d2p1:_x003C_SY_Menu_RecID_x003E_k__BackingField> <d2p1:_x003C_SY_PrintGroup_RecID_x003E_k__BackingField>String</d2p1:_x003C_SY_PrintGroup_RecID_x003E_k__BackingField> <d2p1:_x003C_StaffID_x003E_k__BackingField>String</d2p1:_x003C_StaffID_x003E_k__BackingField> <d2p1:_x003C_Title_x003E_k__BackingField>String</d2p1:_x003C_Title_x003E_k__BackingField> <d2p1:_x003C_UsePrepaidLabourPacks_x003E_k__BackingField>false</d2p1:_x003C_UsePrepaidLabourPacks_x003E_k__BackingField> <d2p1:_x003C_Username_x003E_k__BackingField>String</d2p1:_x003C_Username_x003E_k__BackingField> <d2p1:_x003C_WindowsDomainAccount_x003E_k__BackingField>String</d2p1:_x003C_WindowsDomainAccount_x003E_k__BackingField> </d2p1:HR_Staff> </Results> <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d2p1:KeyValueOfstringstring> <d2p1:Key>String</d2p1:Key> <d2p1:Value>String</d2p1:Value> </d2p1:KeyValueOfstringstring> </Meta> <ResponseStatus> <ErrorCode>String</ErrorCode> <Message>String</Message> <StackTrace>String</StackTrace> <Errors> <ResponseError> <ErrorCode>String</ErrorCode> <FieldName>String</FieldName> <Message>String</Message> <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d5p1:KeyValueOfstringstring> <d5p1:Key>String</d5p1:Key> <d5p1:Value>String</d5p1:Value> </d5p1:KeyValueOfstringstring> </Meta> </ResponseError> </Errors> <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d3p1:KeyValueOfstringstring> <d3p1:Key>String</d3p1:Key> <d3p1:Value>String</d3p1:Value> </d3p1:KeyValueOfstringstring> </Meta> </ResponseStatus> </QueryResponseOfHR_Staff7kRqkrSv>