# NotificationSetsByProviderId__embeddedNotifications List of notification sets __Activity name :__ GetNotificationSetsByProviderId List the available notification sets. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `NotificationSets` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `providerId` | `guid` | ☑ | | The unique identifier of a provider | ## Columns The columns of the table `NotificationSetsByProviderId__embeddedNotifications` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `createNumberOfDaysBeforeEvent` | `int32` | | ☐ | The number of days that the notification is created befor the event takes place. | | `description` | `string(50)` | Description | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `isEnabled` | `boolean` | | ☐ | Enable or disable a notification for a user | | `notificationType_key` | `int32` | Notification Type Key | ☐ | | | `notificationType_value` | `string(70)` | Notification Type Value | ☐ | | | `numberOfLinkedEmployerUsers` | `int32` | | ☐ | The number of employer users that are linked to this notification set | | `receiveDepartmentSignalsOnly` | `boolean` | | ☐ | Only receive notification for your departments. Not relevant if the user is not a department manager. | | `sendMailWhenNotificationIsCreated` | `boolean` | | ☐ | send an email when on creation of the notification |