Skip to main content

Merge JSON data using JQ based on a common Key/Value - Workflow Template

Simple example using JQ to merge two JSON files using JQ using the key Email_Address as the match between the two datasets.

Updated over 2 weeks ago

This workflow template demonstrates how to efficiently merge two JSON datasets using JQ, focusing on the key "Email_Address" to match entries. Ideal for businesses needing to consolidate user and device information, it simplifies data integration by combining user details with associated computer records. This example serves as a foundational tool for data management tasks, enhancing operational efficiency and data accuracy.

Take Me to the Template

Use Cases

Example

Workflow Breakdown

  1. Define the two JSON datasets using the variable steps

  2. Apply the JQ command to merge the JSON so that computers are an array based on the email address.

Vendors

Utils

Tips

  • Modify the JQ command to provide the desired output.

  • In this case the selection is filtered on 4 elements found in the computers JSON data where the email address matches..

Related Articles
Workflow Template: Append data to an Array (Torq)
Create Attachment in Jira with JSON Data (Jira) - Workflow Template
Workflow Template: JSON Filtering with JQ
Workflow Template: Simple Loops with Torq
Transform Data Operator: Manipulate Data Seamlessly with Torq
Did this answer your question?