# EmailTemplateByProviderIdAndEmailTemplateId Details of an email template __Activity name :__ GetEmailTemplateByProviderIdAndEmailTemplateId Get the details of an email template. The available email template placeholders can be aquired by adding /metadata to the url. 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: `Emailtemplates` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `emailTemplateId` | `guid` | ☑ | | The unique identifier of the email template record | | `providerId` | `guid` | ☑ | | The unique identifier of a provider | ## Columns The columns of the table `EmailTemplateByProviderIdAndEmailTemplateId` 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(512)` | | ☐ | 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. |