Provides a way to map a document into a desired form by providing visual hierarchical mapping and rich function-based field manipulation. Both JSON and XML document types are supported.


For the legacy version of QuickMap (up to version 3.0.0.1), see the QuickMap (Legacy) article.

Revision History

4.0.0.5 Initial Release of new QuickMap
4.0.0.6 Added STRINGVALUE function, simplified error messages

Properties

Source

Type: Multiline Text Input
Provides a source document that will be transformed in JSON or XML form.

Mapping

Type: Multiline Text
Describes the mapping,. Clicking this property opens the visual mapper.

Emit

Type: List Input
Specifies the type of document that should be returned.
Json - Specifies a JSON document
Xml - Specifies an XML document


Result

Type: Multiline Text Output
Returns the rendered document.

Custom Inputs

Add Custom Inputs to this Node to provide lookup tables for use with the LOOKUP function

Remarks

Use this Node to easily convert data from one shape to another.

Key Features

  • Visual hierarchical mapping including upstream and downstream mappings
  • Support for JSON, XML and XML schemas
  • Automatic preview from within the Visual Mapper
  • Manipulate field and container mappings using Excel-like functions
  • Apply filters at the container level using Excel-like functions

Getting Started

To begin using QuickMap, you'll need to provide sample data or a schema for the Source and Result properties. You can do this in several ways:

  • Add an XML schema to the property (click the Schema tab in the popup editor)
  • Add an XML schema to a property that the Source  or Result  property is connected to
  • Provide an XML or JSON document on the Property
  • Provide an XML or JSON document on a Property that the Source  or Result  property is connected to
  • For the Source  property, it's often easiest to run the Node that QuickMap sources its data from, then open the output Property in the Activity logs, copy that value and paste it into Node property on the Design view. Note that clicking the Airplane button in the popup Pane will perform the copy/paste operation for you

Visually Mapping Elements

Create a Flow Connector by either dragging from the Flow Socket of the source schema tree (left-hand side) to a Flow Socket of the target schema (right-hand side).

You can also create a Flow Connector by clicking the source Flow Socket, then clicking the target Flow Socket. 

Tree elements that have child elements are considered containers, those that don't are considered fields.

Mapping Expressions

Provide an expression in the Mapping Expressions textbox next to the target schema tree to perform more complex manipulation of data.

When a Map Expression textbox is focused, a palette of mapped fields and containers as well as a list of in-scope functions are displayed.

See QuickMap Functions for a list of supported functions.

Filter Expressions

Toggle the expressions view to filter mode by clicking Switch to Filter Expressions . This mode will allow you to apply a filtering expression to any container element in the target tree

See QuickMap Functions for a list of supported functions.

Examples


See https://flowgear.me/s/BIo4BHD for an example.

See Also


LINQ
XSL Transform
Script

Did this answer your question?