Zip JSON Array
Infoveave Data Automation — Pivot & Transpose
Two parallel JSON array columns — each describing a different dimension at the same index — merge into one structured array of combined objects in a single step.
Some APIs return related multi-dimensional data as separate parallel arrays in the same response — one array for project mix percentages, another for sales mix percentages, each with elements at the same index representing the same time period or category. Working with these arrays separately makes cross-dimension analysis difficult. Zip JSON Array solves this by merging multiple parallel JSON array columns into one combined array where each element is an object that holds the corresponding values from all input arrays at that index. The result is a single consolidated array column that can be flattened, analyzed, or passed on as a structured output.
What Zip JSON Array does
Zip two or more JSON array columns into a single combined array column in Infoveave. Merge parallel array columns returned from APIs or event systems by index into structured objects without code.
When to use Zip JSON Array
- You have two or more JSON array columns where the array elements at the same index position represent the same category, time period, or entity and need to be combined into a single structured record per index
- An API returns related dimensions as separate arrays — such as a revenue array and a cost array with the same length — and you want to merge them into one array of objects for combined analysis
- You want to produce a single structured output column from multiple parallel arrays before feeding the result into Flatten JSON Array to produce properly joined rows
- You are aggregating and restructuring data from different time series or breakdown dimensions stored as separate array columns into one combined exportable structure
When to avoid it
- The arrays in your columns have different lengths or are not parallel by index — zipping misaligned arrays will produce incorrect combined results or truncate to the shorter array length
- You want to expand a single array column into individual rows — use Flatten JSON Array for that case
- You want to merge arrays sequentially or concatenate them into a longer single array rather than combining elements by index — use a different array manipulation approach for concatenation
Where it fits in your Infoveave automation
Zip JSON Array is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Zip JSON Array
Real scenarios where this transformation saves hours of manual work.
Combine Project Mix and Sales Mix Arrays for Portfolio Reporting
A financial analytics team receives API responses where each portfolio record includes a projectmix column with a JSON array of allocation percentages by category and a salesmix column with a corresponding JSON array of sales percentages for the same categories by index. Zip JSON Array merges both arrays into a single zipped_mix column where each element is an object combining the project and sales values for that category index. The team then passes the zipped array to Flatten JSON Array to expand into individual rows for full portfolio reporting.
Merge Planned and Actual Production Arrays for OEE Analysis
A manufacturing team extracts shift records where planned production targets and actual production volumes are stored as parallel JSON arrays with one element per hour. Zip JSON Array combines the planned and actual arrays into a single combined array with one object per hour holding both planned and actual values. The merged array can then be flattened into rows for hourly deviation analysis and OEE metric calculation.
Zip Price and Quantity Arrays from Pricing Engine Export
A retail pricing team exports pricing engine results where each product record includes a price_history array and a quantity_history array, each with one element per week. Zip JSON Array combines both arrays into a single weekly_data array where each element holds that week's price and quantity values together. The team then flattens the zipped array into rows for weekly revenue calculation and trend visualization.
See Zip JSON Array in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
projectmix, salesmixzipped_mixInput Data
| ID | projectmix | salesmix |
|---|---|---|
| 1 | projectvalue:10 projectvalue:20 | salesvalue:100 salesvalue:200 |
| 2 | projectvalue:15 projectvalue:30 | salesvalue:150 salesvalue:300 |
Output Data
| ID | projectmix | salesmix | zipped_mix |
|---|---|---|---|
| 1 | projectvalue:10 projectvalue:20 | salesvalue:100 salesvalue:200 | index0: projectvalue=10 salesvalue=100 | index1: projectvalue=20 salesvalue=200 |
| 2 | projectvalue:15 projectvalue:30 | salesvalue:150 salesvalue:300 | index0: projectvalue=15 salesvalue=150 | index1: projectvalue=30 salesvalue=300 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Name
Select two or more columns to zip. Each selected column must contain a JSON array. The arrays are combined by index position — element at index 0 from all selected columns is merged into the first element of the output array, element at index 1 produces the second output element, and so on. All selected columns must have JSON arrays of the same length for the combining to work correctly.
Output Column
Specify the name for the new column that will contain the resulting zipped JSON array. The zipped array contains one object per index position, with that object holding the combined properties from all input arrays at that index. This output column is typically then passed into Flatten JSON Array to expand the merged array objects into individual rows.
Frequently asked questions
Everything you need to know about Zip JSON Array in Infoveave.
Also in Pivot & Transpose — and what runs before & after
Transformations in the same family as Zip JSON Array, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Zip JSON Array is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
