Refresh Lookup Table and Track Enriched Event
A 3-step recipe with Mixpanel. We can help you get access.
Recipe · 3 steps
Refresh Lookup Table and Track Enriched Event
with Mixpanel · Product Telemetry Instrumentation
List lookup tables, replace one with new CSV, then track an event using the join key.
- Retrieve all lookup tables for the project to confirm the target table exists before replacing it. Uses service account basic auth.
- Replace the contents of the lookup table with fresh CSV data. The first column is the join key.
- Send an event carrying the join-key property so enriched dimensions resolve against the refreshed lookup table. Auth uses the project token in the query parameter.
What you'll need to have ready
- projectToken: Mixpanel project token used for ingestion auth.
- lookupTableId: The ID of the lookup table to replace.
- csvData: CSV data with headers in the first row; first column is the join key.
- eventName: Event name to track after the table is refreshed.
- distinctId: Unique identifier for the user performing the event.
- joinKeyProperty: Event property name that holds the lookup join key.
- joinKeyValue: The join-key value to set on the event property.
For your developer
Arazzo workflow mixpanel:lookup-table-enrichment, 3 operations: listLookupTables → replaceLookupTable → trackEvent. Specs on APIs.io.