# EmployerUsersByEmployerId List of users for an employer __Activity name :__ GetEmployerUsersByEmployerId Get the list of users of the employer Select loket.nl (REST) API URL: /providers/employers/{employerId}/users Insert loket.nl (REST) API URL: /providers/employers/{employerId}/users Update loket.nl (REST) API URL: /providers/employers/{employerId}/users Delete loket.nl (REST) API URL: /providers/employers/{employerId}/users Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/users Insert loket.nl (REST) API Operation: post /providers/employers/{employerId}/users - Catalog: `LoketNlRest` - Schema: `EmployerUser` - Retrieve: true - Insert: true - Update: false - Delete: false - Field Selection Method: NotRequired - Base Path: `_embedded[*]` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns of Table Function The columns of the table function `EmployerUsersByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accessStatus_key` | `int32` | | ☐ | | | `accessStatus_value` | `string(255)` | | ☐ | | | `azureActiveDirectory_tenant_description` | `string(100)` | | ☐ | | | `azureActiveDirectory_tenant_id` | `guid` | | ☐ | Id for the tennant | | `azureActiveDirectory_tenant_tenantRegistrationLevel` | `string` | | ☐ | | | `azureActiveDirectory_userId` | `string` | | ☐ | The userId as known in the Azure AD of the selected tennant | | `contactInformation_emailAddress` | `string(255)` | | ☐ | The e-mail address of the user. | | `contactInformation_phoneNumber` | `string(15)` | | ☐ | The phone number of the user. | | `contactInformation_placeOfEmployment` | `string(24)` | | ☐ | The place of employment (standplaats) for the user. | | `dateTimeCreation` | `datetime` | | ☐ | The date on which the user was created | | `dateTimeLastLogin` | `datetime` | | ☐ | The date on which the user loged in for the last time | | `hasAccessToPayrollingTestData` | `boolean` | | ☐ | Indicates if the user has access to data for payrolling test years | | `hasIntegrations` | `boolean` | | ☐ | Indicates if the user has integrations with clients other that Loket | | `hasMultiFactorAuthentication` | `boolean` | | ☐ | Indicates if the user has multi factor authentication enabled | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `isDepartmentManager` | `boolean` | | ☐ | Indicates if the user is a department manager | | `isLinkedToMultipleEmployers` | `boolean` | | ☐ | Indicates if the user has access to multiple employer. | | `loginMethod_key` | `int32` | | ☐ | | | `loginMethod_value` | `string(50)` | | ☐ | | | `personalDetails_firstName` | `string(28)` | | ☐ | The first name of the user | | `personalDetails_initials` | `string(6)` | | ☐ | The initials of the user | | `personalDetails_lastName` | `string(25)` | | ☐ | The last name of the user | | `personalDetails_prefix` | `string(10)` | | ☐ | The prefix of the user | | `twoFactorAuthenticationRequired` | `boolean` | | ☐ | Indicates whether two factor authentication is required for the user. This setting is only available for login method: Via website en SSO | | `userCustomSpecifiedRole` | `string(50)` | | ☐ | Further specification of the user role. | | `userName` | `string(50)` | | ☐ | The username | | `userSpecifiedRole_key` | `int32` | | ☐ | | | `userSpecifiedRole_value` | `string(50)` | | ☐ | |