# EmailTemplateByEmployerIdAndEmailTemplateId
Details of an email template
__Activity name :__ GetEmailTemplateByEmployerIdAndEmailTemplateId
Get the details of an email template. The available email template placeholders can be aquired by adding /metadata to the url.
Select loket.nl (REST) API URL: /providers/employers/{employerId}/emailtemplates/{emailTemplateId}
Insert loket.nl (REST) API URL: /providers/employers/{employerId}/emailtemplates/{emailTemplateId}
Update loket.nl (REST) API URL: /providers/employers/{employerId}/emailtemplates/{emailTemplateId}
Delete loket.nl (REST) API URL: /providers/employers/{employerId}/emailtemplates/{emailTemplateId}
Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/emailtemplates/{emailTemplateId}
- Catalog: `LoketNlRest`
- Schema: `EmailTemplates`
- Field Selection Method: NotRequired
- Base Path: `_embedded[*]`
This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API.
## Parameters of Table Function
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `emailtemplateId` | `guid` | ☑ | | The unique identifier of the record |
| `employerId` | `guid` | ☑ | | The unique identifier of the employer |
## Columns of Table Function
The columns of the table function `EmailTemplateByEmployerIdAndEmailTemplateId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `category_key` | `int64` | | ☐ | The id of the categorie to which the email template belongs. |
| `category_value` | `string` | | ☐ | The name of the categorie to which the email template belongs. |
| `definedAtLevel` | `string` | | ☐ | The level at which the email template is defined. |
| `dependsOnModule_description` | `string` | | ☐ | The name of the module to which the email template belongs. |
| `dependsOnModule_id` | `guid` | | ☐ | The id of the module to which the email template belongs. |
| `email_body` | `string(6000)` | | ☐ | The body text of the email. |
| `email_senderEmail` | `string(255)` | | ☐ | The email address of the sender. |
| `email_subject` | `string(255)` | | ☐ | The subjectline of the email. |
| `isEmailTemplateEditable` | `boolean` | | ☐ | Indicates whether the email template can be editted. |
| `type_description` | `string` | | ☐ | The description of the type of the email template. |
| `type_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `type_sortOrder` | `int64` | | ☐ | A number used to sort the list. |