📦 Help transforming grouped order line items into JSON payloads for HTTP POST

How To
4

Module Export - quick import into your scenario

You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.

  1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:

  2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.

  3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.

JSON module export — paste this directly in your scenario

{"subflows":[{"flow":[{"id":66,"module":"json:ParseJSON","version":1,"parameters":{"type":""},"mapper":{"json":"[{\"id\":101001,\"upc\":\"123456789012\",\"quantity\":48,\"order_type\":\"R\",\"item_number\":10001,\"customer_type\":\"L\",\"customer_number\":11111,\"transaction_type\":\"BO\",\"delivery_datetime\":\"2025-06-18T05:00:00Z\",\"transaction_number\":\"TX100001\",\"transaction_datetime\":\"2025-06-16T17:46:12Z\",\"delivery_instructions\":\"Back entrance\"},{\"id\":101002,\"upc\":\"123456789013\",\"quantity\":24,\"order_type\":\"R\",\"item_number\":10002,\"customer_type\":\"L\",\"customer_number\":22222,\"transaction_type\":\"BO\",\"delivery_datetime\":\"2025-06-18T05:00:00Z\",\"transaction_number\":\"TX100002\",\"transaction_datetime\":\"2025-06-16T16:24:57Z\",\"delivery_instructions\":\"Leave at reception\"},{\"id\":101003,\"upc\":\"123456789014\",\"quantity\":24,\"order_type\":\"R\",\"item_number\":10003,\"customer_type\":\"L\",\"customer_number\":11111,\"transaction_type\":\"BO\",\"delivery_datetime\":\"2025-06-18T05:00:00Z\",\"transaction_number\":\"TX100001\",\"transaction_datetime\":\"2025-06-16T17:46:12Z\",\"delivery_instructions\":\"Back entrance\"}]"},"metadata":{"designer":{"x":869,"y":-1523,"name":"Example Input"},"parameters":[{"name":"type","type":"udt","label":"Data structure"}]}},{"id":67,"module":"builtin:BasicAggregator","version":1,"parameters":{"feeder":66},"mapper":{"id":"{{66.id}}","upc":"{{66.upc}}","quantity":"{{66.quantity}}","order_type":"{{66.order_type}}","item_number":"{{66.item_number}}","customer_type":"{{66.customer_type}}","customer_number":"{{66.customer_number}}","transaction_type":"{{66.transaction_type}}","delivery_datetime":"{{66.delivery_datetime}}","transaction_number":"{{66.transaction_number}}","transaction_datetime":"{{66.transaction_datetime}}","delivery_instructions":"{{66.delivery_instructions}}"},"metadata":{"designer":{"x":1118,"y":-1524,"name":"Aggregate by Order"},"advanced":true},"flags":{"groupBy":"{{66.transaction_number}}","stopIfEmpty":true}},{"id":69,"module":"builtin:BasicFeeder","version":1,"parameters":{},"mapper":{"array":"{{67.array}}"},"metadata":{"designer":{"x":1363,"y":-1524,"name":"Iterate Items"}}},{"id":70,"module":"util:TextAggregator","version":1,"parameters":{"rowSeparator":"other","otherRowSeparator":",","feeder":69},"mapper":{"value":"{\r\n  \"order_item_id\": {{69.id}},\r\n  \"quantity_requested\": {{69.quantity}},\r\n  \"product_number\": \"{{69.item_number}}\",\r\n  \"upc\": \"{{69.upc}}\"\r\n}"},"metadata":{"designer":{"x":1606,"y":-1525,"name":"Aggregate Items"},"parameters":[{"name":"rowSeparator","type":"select","label":"Row separator","validate":{"enum":["\n","\t","other"]}},{"name":"otherRowSeparator","type":"text","label":"Separator"}],"advanced":true},"flags":{"stopIfEmpty":true}},{"id":73,"module":"util:ComposeTransformer","version":1,"parameters":{},"mapper":{"value":"{\r\n  \"topic\": \"order_create\",\r\n  \"order\": {\r\n    \"id\": null,\r\n    \"transaction_number\": \"{{67.array[].transaction_number}}\",\r\n    \"order_type\": \"{{67.array[].order_type}}\",\r\n    \"customer_type\": \"{{67.array[].customer_type}}\",\r\n    \"customer_name\": null,\r\n    \"customer_number\": \"{{67.array[].customer_number}}\",\r\n    \"transaction_date\": \"{{67.array[].transaction_datetime}}\",\r\n    \"delivery_date_requested\": \"{{67.array[].delivery_datetime}}\",\r\n    \"delivery_instructions\": \"{{67.array[].delivery_instructions}}\",\r\n    \"time_stamp\": {{now}},\r\n    \"order_items\": [{{70.text}}]\r\n  }\r\n}"},"metadata":{"designer":{"x":1853,"y":-1526,"name":"JSON for order","messages":[{"category":"last","severity":"warning","message":"A transformer should not be the last module in the route."}]}}}]}],"metadata":{"version":1}}

Note: Did you know you can reduce the size of blueprints and module export code like the above, using the Make Blueprint Scrubber?