Validate JSON Array Element Data

Last updated Tue May 24 2022

Simplify the transformation of a Customer JSON document with validated address and contact data:

  • Includes an easy to follow example process with sample customer JSON data
  • Parses JSON data via splitting, business rule validation and document caching
  • Leverages join conditions in a map to generate a Customer JSON document with validated array data

Overview:

There are data transformation use cases where invalid JSON array items should be removed from a document before assembling the final version.

This example demonstrates how simple business rule validations per array item can ensure optimal data quality.

JSON splitting, document caching and join conditions within a map remove the need for any custom scripting to transform the customer data.

This example process can be customized and plugged into JSON transformation scenarios that require individual array item parsing and reassembly.

The recipe qualifies for Boomi’s Recipe Program.

Qualifying customers get access to Boomi’s Recipe Program* with the purchase of a Boomi subscription. As part of the Recipe Program you have direct access to a Boomi specialist to get you up and running with Boomi at no additional cost. Learn more

*Offer applies only to new customers and requires purchase of a qualifying Boomi subscription.

Related Solutions

Recipe

Get Started with Structuring Complex Objects and Lists in Flow

Learn the importance of Types, Object Values, and List Values in flow and how to structure data in your flow build.
Learn more

Accelerator

Simply Vision: Boomi Monitoring Solution

Monitor your deployed assets and accurately forecast support requirements with Boomi!

Accelerator

Oracle Cloud ERP Integration Accelerator – HCM/HR: Employee by Apps Associates

Automatically load employee data into Oracle Cloud ERP and connect to HCM/HR systems with Boomi.