FINS Databricks Engagements System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| web-engagements-post-payload | Databricks FINS WebEngagement to WEB_ENGAGEMENT table mapping response |
| web-engagements-get-response | Databricks WEB_ENGAGEMENT table to FINS WebEngagement mapping response |
web-engagements-post-payload
Databricks FINS WebEngagement to WEB_ENGAGEMENT table mapping response
Source:
./src/main/resources/dwl/web-engagements-post-payload.dwl
Mapping Tables
Maps FINS WebEngagement to Databricks WEB_ENGAGEMENT table This payload is used to insert value into the Databricks WEB_ENGAGEMENT table
| WEB_ENGAGEMENT | FINS WebEngagement | Description |
|---|---|---|
| INDIVIDUAL_ID | individualId | Global identifier of the individual party |
| EMAIL_ADDRESS | emailAddress | Email Address of the individual party |
| SESSION_ID | sessionId | The unique number assigned to the user's session for the duration of the visit |
| CHANNEL_TYPE | channelType | The type of channel visited by the individual |
| TIME_IN_CHANNEL | timeInChannel | The number of seconds the individual was in the channel |
| TIME_BETWEEN_CHANNELS | timeBetweenChannels | The number of seconds between channel visits |
| PAGES_PER_SESSION | pagesPerSession | The number total page views divided by the total number of sessions that have taken place |
| CREATED_BY | auditInfo.createdBy | Identifies the system or user which created the entity |
| CREATED_DATE | auditInfo.createdDate | Timestamp of when the entity was created - default as current timestamp |
| UPDATED_BY | auditInfo.updatedBy | Identifies the system or user which last updated the entity |
| UPDATED_DATE | auditInfo.updatedDate | Timestamp of when the entity was last updated |
| IS_DELETED | auditInfo.isDeleted | Indicates whether or not the entity has been soft-deleted - default as false |
web-engagements-get-response
Databricks WEB_ENGAGEMENT table to FINS WebEngagement mapping response
Source:
./src/main/resources/dwl/web-engagements-get-response.dwl
Mapping Tables
Maps Databricks WEB_ENGAGEMENT table to FINS WebEngagement
| FINS WebEngagement | WEB_ENGAGEMENT | Description |
|---|---|---|
| individualId | INDIVIDUAL_ID | Global identifier of the individual party |
| emailAddress | EMAIL_ADDRESS | Email Address of the individual party |
| sessionId | SESSION_ID | The unique number assigned to the user's session for the duration of the visit |
| channelType | CHANNEL_TYPE | The type of channel visited by the individual |
| timeInChannel | TIME_IN_CHANNEL | The number of seconds the individual was in the channel |
| timeBetweenChannels | TIME_BETWEEN_CHANNELS | The number of seconds between channel visits |
| pagesPerSession | PAGES_PER_SESSION | The number total page views divided by the total number of sessions that have taken place |
| auditInfo.createdBy | CREATED_BY | Identifies the system or user which created the entity |
| auditInfo.createdDate | CREATED_DATETimestamp of when the entity was created - default as current timestamp | |
| auditInfo.updatedBy | UPDATED_BY | Identifies the system or user which last updated the entity |
| auditInfo.updatedDate | UPDATED_DATE | Timestamp of when the entity was last updated |
| auditInfo.isDeleted | IS_DELETED | Indicates whether or not the entity has been soft-deleted - default as false |