2024-07 Pendo upgrade

We are making updates on Tuesday, July 9th, 2024, to improve your Pendo connector experience, with a focus on enhancing Pendo custom reports in the following areas:

1. Custom Fields: We now allow column mapping that includes all Pendo custom fields. This change provides greater flexibility and adaptability. 

2. Metadata Fields: We previously flattened metadata fields. Going forward, the platform will keep the column structure unflattened and represent metadata fields as records with nested fields.

3. Field Naming Conventions: Alphanumeric characters in field names will now be converted to underscores.   For columns starting with numbers, an underscore will be added to the field name (e.g., _4345).

4. Conflicting Data-Types: We’ve improved error handling for conflicting types during mapping. Instead of discarding data, conflicting columns will now be cast to strings, preserving the structure.

5. Predefined Reports: All specified changes to custom fields have also been applied to the predefined reports. The predefined reports now use the JSON datatype at the second level for nested fields, and "metadata_ids" have been included in dedicated reports.

What actions should you take?

• Update Data Integration’s mapping for Pendo Rivers using custom reports. Navigate to your River schema tab, select Clear All, and then apply Auto Mapping.
• We are working on further improvements in the Pendo Predefined reports, stay tuned for more updates.