Skip to Content

Plugin Structured Data in Jitterbit App Builder

There are a variety of versions of this plugin for various third parties.

The plugin takes a configuration that looks something like this:

{
    "name": "Order",
    "key": "OrderID",
    "attributes":
    [
        "OrderID",
        "StoreID",
        "UserName",
        "OrderDate",
        "AssociateID",
        "AssociateName",
        "AssociateNumber"
    ],
    "children":
    [
        {
            "name": "Customer",
            "key": "RelateCustomer_ID",
            "attributes":
            [
                "RelateCustomer_ID",
                "FirstName",
                "LastName",
                "APARTMENT",
                "ADDRESS1",
                "CITY",
                "STATE",
                "POSTAL_CODE"
            ],
            "children":
            [
                {
                    "name": "CustomerAlterations",
                    "key": "CustomerAlterationCodeFriendly",
                    "attributes":
                    [
                        "SpecialInstruction",
                        "CustomerAlterationCodeFriendly",
                        "CustomerAlterationCode",
                        "CustomerAlterationDescription",
                        "CustomerAlterationParameter",
                        "CustomerAlterationParameterValue",
                        "CustomerAlterationAbsoluteNumber"
                    ]
                },
                {
                    "name": "CustomerMeasurements",
                    "key": "MeasurementCode",
                    "attributes":
                    [
                        "MeasurementCode",
                        "Measurement",
                        "NumericValue",
                        "Required"
                    ]
                }
            ]
        },
        {
            "name": "OrderGroups",
            "key": "OrderGroupID",
            "attributes":
            [
                "OrderGroupID",
                "FabricSwatchCode",
                "FabricSwatchDescription",
                "FabricLiningCode",
                "FabricLiningDescription",
                "ButtonCode",
                "ButtonName",
                "ParentProductName"
            ],
            "children":
            [
                {
                    "name": "OrderGroupLines",
                    "key": "LineID",
                    "attributes":
                    [
                        "LineID",
                        "ProductName",
                        "ProductCode",
                        "ProgramID",
                        "Program",
                        "ProductMakeCode",
                        "Make",
                        "Size",
                        "Quantity"
                    ],
                    "children":
                    [
                        {
                            "name": "OrderGroupLineAlterations",
                            "key": "AlterationFriendlyCode",
                            "attributes":
                            [
                                "AlterationFriendlyCode",
                                "AlterationCode",
                                "AlterationDescription",
                                "Parameter",
                                "Value",
                                "Note"
                            ]
                        }
                    ]
                }
            ]
        }
    ]
}

Name, key, attributes, children and then each child under children can have name, key, attributes, children… and so on

Screen shot 2017 11 14 at 10 11 36 am

When building the data object for the data for this report you select everything, ordering by level1, level2, level3 ...