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 |