Webhook JSON Export - Compatibility with BQ
f
fredric.lundgren@ingka.ikea.com
The output JSON file from the publishing Webhook, while exhaustive, is not compatible with the GCP/BigQuery import for creating tables, making it harder to create custom logic which tries validating collected data against the AVO Tracking plan. Suggest one or more of the following:
- Ability to select which fields to output as part of the JSON Export (Thus making it possible to output a flattened JSON file)
- Set up a BQ-compatible version of the JSON Export using Newline Delimited JSON
Stefania
Thanks for sharing, Fredric! I've pulled this to the attention of the team to see if there's anything we can do in the short term. In the meantime, please keep us posted on any progress you make related to this.