CREATE EXPORT MAPPING

Synopsis

CREATE [ OR MODIFY ] EXPORT MAPPING module.Name
    [ WITH JSON STRUCTURE module.JsonStructure ]
    [ WITH XML SCHEMA module.XmlSchema ]
    [ NULL VALUES { LeaveOutElement | SendAsNil } ]
{
    module.Entity {
        jsonField = Attribute,
        ...
        [ Assoc/module.ChildEntity AS alias {
            childField = ChildAttr,
            ...
        } ]
    }
};

Description

Creates an export mapping that serialises Mendix entity objects to JSON or XML.

An export mapping is invoked in a microflow using EXPORT TO MAPPING module.Mapping($Object). The result is a JSON or XML string.

NULL VALUES

Controls how empty attribute values are serialised:

Value	Behaviour
`LeaveOutElement`	Omit the JSON key entirely (default)
`SendAsNil`	Include the key with a `null` JSON value

Nested Objects and Arrays

Child entities are nested using the association path followed by AS alias:

Assoc/module.ChildEntity AS alias { ... }

For arrays, Studio Pro’s domain model convention is to use an intermediate container entity (no attributes) between the root and the item entity. See the example below.

OR MODIFY

If OR MODIFY is specified and the mapping already exists, it is updated in place. The document UUID is preserved, which protects runtime microflow references that call EXPORT TO MAPPING.

Parameters

module.Name: The qualified name of the export mapping.
WITH JSON STRUCTURE module.JsonStructure: Associates the mapping with the named JSON structure.
WITH XML SCHEMA module.XmlSchema: Associates the mapping with the named XML schema.
NULL VALUES LeaveOutElement | SendAsNil: Controls null serialisation. Defaults to LeaveOutElement.
jsonField = Attribute: Maps entity attribute Attribute to the JSON key jsonField.
Assoc/module.ChildEntity AS alias: Maps associated objects to a nested JSON object or array using the named alias.

Examples

Simple flat mapping

CREATE EXPORT MAPPING MyModule.EMM_Pet
    WITH JSON STRUCTURE MyModule.JSON_Pet
{
    MyModule.PetResponse {
        id     = PetId,
        name   = Name,
        status = Status
    }
};

With null values option

CREATE EXPORT MAPPING MyModule.EMM_PetNullable
    WITH JSON STRUCTURE MyModule.JSON_Pet
    NULL VALUES SendAsNil
{
    MyModule.PetResponse {
        id     = PetId,
        name   = Name,
        status = Status
    }
};

Nested object with array (container + item pattern)

-- Domain model for export:
--   ExRoot → ExCustomer (object), ExRoot → ExItems (container) → ExItemsItem (array item)

CREATE EXPORT MAPPING MyModule.EMM_Order
    WITH JSON STRUCTURE MyModule.JSON_Order
{
    MyModule.ExRoot {
        orderId = OrderId,
        MyModule.ExCustomer_ExRoot/MyModule.ExCustomer AS customer {
            name  = Name,
            email = Email
        },
        MyModule.ExItems_ExRoot/MyModule.ExItems AS items {
            MyModule.ExItemsItem_ExItems/MyModule.ExItemsItem AS ItemsItem {
                sku      = Sku,
                quantity = Quantity,
                price    = Price
            }
        }
    }
};

Idempotent update

CREATE OR MODIFY EXPORT MAPPING MyModule.EMM_Pet
    WITH JSON STRUCTURE MyModule.JSON_Pet
{
    MyModule.PetResponse {
        id     = PetId,
        name   = Name,
        status = Status
    }
};

Notes

Export mappings use a different entity structure than import mappings for the same JSON. Arrays in export require an intermediate container entity (no attributes) between the root entity and the array item entity.
Import and export mappings cannot share the same domain model for nested JSON because the FK direction and entity structure differ.

mxcli Documentation