Issue
Some poll responses are synced as an alphanumeric ID value instead of the actual response in the Pendo schema.
Environment
Connector: Pendo
Answer
To resolve this issue, please open a support ticket with Pendo or reach out to your Pendo admin to understand what IDs match the correlating response value.
Cause
Fivetran uses the endpoint, https://app.pendo.io/api/v1/aggregation
, to get pollEvent
data. The Pendo API returns the value of the poll response as a text or ID value. Fivetran will sync the data as passed from Pendo's API.