Скачать или смотреть Mastering JOLT: How to Normalize JSON Effectively

Learn how to effectively use JOLT's syntax to normalize JSON data, with a focus on handling lists and generating the desired output.
---
This video is based on the question https://stackoverflow.com/q/74055800/ asked by the user 'sjlevel' ( https://stackoverflow.com/u/12336346/ ) and on the answer https://stackoverflow.com/a/74056164/ provided by the user 'Barbaros Özhan' ( https://stackoverflow.com/u/5841306/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: JOLT: Normalize JSON

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Mastering JOLT: How to Normalize JSON Effectively

If you're new to working with JSON and need a way to transform it into a more usable format, you might have come across an interesting tool called JOLT. This powerful tool allows you to transform JSON data into a different structure through a set of predefined specifications, making it much easier to work with.

The Problem

One of the common challenges when working with JOLT is handling JSON arrays and transforming them correctly to achieve the desired output. In this instance, we have a JSON structure that lists countries along with their respective animal species. Here’s the JSON example we’re starting with:

[[See Video to Reveal this Text or Code Snippet]]

The goal is to transform this data so that each animal species is paired with its country like so:

[[See Video to Reveal this Text or Code Snippet]]

The Solution

To achieve this transformation, you can utilize JOLT's shift operation. This allows us to restructure our JSON data as needed. Below is a breakdown of the JOLT transformation specs you need to implement.

Step 1: Define the Shift Method

Here’s the first JOLT transformation spec that handles the main restructure:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Specs

country_name Mapping:

@(2,Name): This tells JOLT to get the country name by navigating two levels up in the JSON structure.

@(3,Name)[&1].country_name: This specifies how to map the country name under country_name while keeping the original structure in mind.

species Mapping:

@: Here you are grabbing the species directly from the current level and associating it with the correct country name using the pathing built into JOLT.

Final Shift:

The second shift operation (with "*": "") is used to flatten out any remaining array artifacts, cleaning up the structure.

Conclusion

By using JOLT's powerful transformation capabilities, you can successfully normalize JSON data to fit your requirements. The insight into shift operations and JSON pathing allows you to masterfully manipulate data formats, providing you with a streamlined way to work with JSON arrays and objects.

With this knowledge, you are now equipped to tackle similar JSON transformations using JOLT. Happy coding!