Introducing Guides:Define machine-readable EDI requirementsLearn more
Stedi
Sign inBook a demoStart building
Try Stedi free

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

Sign Up Learn More
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…

Image of an EDI 850 purchase order displayed in JEDI (JSON EDI) format

…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 Transformation Editor 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.

In fact, the exact mapping we've been demonstrating can be deployed to your Stedi account by clicking the button below:

Button to deploy the Mapping to your Stedi account

We’ve published a number of other open-source sample mappings in our GitHub starter-kit repo, which you can deploy to your Stedi account in seconds and invoke via API (there's a generous free tier).

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.

Get started today.


Excited to learn more? Watch the video below for a deep dive into Mappings:

Featured
Mappings
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 
Share
Previous
Announcing 85%+ price decreases and expanded free tiers for EDI Core, Mappings
Subscribe

Get blog posts delivered to your inbox.

Stedi

Stedi is a developer-focused platform for building automated EDI solutions that integrate with any business system.

Sign up to get an API key and try Stedi’s pay-⁠per-⁠use products with generous free tiers.

Start building
Products
EDI CoreMappingsGuidesSFTPBucketsFunctionsStash
Follow
  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.