Map path: Targeted transformation in JSON documents

Ivan Ng
Ivan Ng Administrator
edited December 19 in Tips and tricks

If you’re working with structured JSON data, Map path is your go-to Higher Order Function for applying transformations to specific fields.

What it does:

MapPath uses a JSONPath expression to locate fields in a JSON document and applies a function to each matched item.

Where it works:

  • JSON list
  • JSON record

Business Use Cases & Examples:

  • JSON list:Convert all status fields to uppercase in order records:
image-0624e25abe0e88-8447.png

JSON record:Mask all email fields in a customer record:

image-9c0c009d53267-b777.png

This is ideal for bulk updates, formatting, or applying business rules across nested data structures.

Coming soon: MapRecord – how to apply logic to each key/value pair in a JSON object.

Back to main post

Tagged:

Categories