Try Stedi for free

Start building an EDI system of your own.
No credit card required!

Sign UpBook a demo
Blog January 26, 2022

Complex data transformations made simple with Mappings

Headshot of Tomasz Łakomy
Tomasz Łakomy

Business integrations are anything but straightforward – they are typically composed of many steps that need to be executed sequentially to process a single business transaction.

At a high level, each step can be divided into one of two categories: transporting data and transforming data. In order to enable developers to implement all manner of data transformations with ease, we've built Mappings.

Introducing Mappings

Mappings is a robust JSON-to-JSON data transformation engine that enables developers to define field mappings in an intuitive UI – and then invoke those mappings programmatically via an API.

Mappings is composed of two parts:

  • a browser-based tool that allows users to create and test JSON-to-JSON data transformations
  • an API that can be used to programmatically invoke defined mappings at web scale.

Here's a look at the UI...

Image an overview of the Mappings UI with a partially created mapping

...and the corresponding API call:

Image of the Launch Mapping modal, showing a node.js code snippet
Using Mappings, developers can transform JSON payloads without the need to write, provision, maintain, or monitor any infrastructure. Mappings is powered by an open-source query and transformation language called JSONata, which comes with a large number of built-in functions and expressions.
Mappings allows developers to solve common tasks like retrieving data from nested structures, manipulating strings, writing conditional expressions, parsing/converting dates, transforming data (with filter, map, reduce functions) and much more.

Using Mappings

As an example, let's build a mapping between an '850' - Purchase Order and a QuickBooks Online Estimate. The Purchase Order is in the X12 EDI format; since Mappings works with JSON as its input and output formats, we need to translate it to JSON first. You can read how to do that here.
Now that we have a JSON source document to start with, we can create a new mapping by navigating to Mappings in Stedi. We'll input the JSON as the source in the first step of the Mapping wizard…
…and we'll input the target JSON in the next step:
Image of a QuickBooks Online Estimate API shape displayed in JSON
With our source and target selected, we can start building a transformation between them by writing simple functions and expressions:
Image of the Mappings fullscreen view showing a complex JSONata transformation

The Mappings UI has autocomplete functionality and built-in documentation. Together, these facilitate a seamless experience for building complex data transformations:

Image of the Mappings Editor with several mapping transformations

Each mapping can be tested in the UI…

Image of the Test Mapping modal
…and executed at web scale using the API.

Mappings is now Generally Available

Mappings allows you to create your own data transformation API - without the need to write, provision, maintain or monitor any code; you focus on building your business logic and we’ll do the rest for you. Mappings has a straightforward pay-per-use pricing model - there are no minimum fees, monthly commitments, or upfront costs to use this product.

Map data into any shape

Mappings is a tool that maps JSON documents from one structure to another to integrate with any pipeline.

Try Mappings Learn more 
Announcing 85%+ price decreases and expanded free tiers for EDI Core, Mappings

Get blog posts delivered to your inbox.


Build EDI integrations fast, without being an EDI expert

Start building
How Stedi worksCustomersPricingDocumentationChangelog
  1. Twitter
  2. GitHub
Backed by
AdditionBloomberg BetaFirst RoundStripeUSV
Customer AgreementService TermsPrivacy Notice

Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on our site are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Our use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.