This example take json file from source folder, split it based on json array’s elements to multiple payload, renamed then saved to multiple files in target folder. See below gif animation: Input file:Orders.txt
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
{ "Orders": [{ "OrderID": 2501, "Customer": "Alex", "Country": "USA", "Items": [{ "ProductID": "P05", "UnitPrice": 50, "Quantity": 1, "Variants": [{ "Color": "Blue", "Quantity": 1 } ] } ] }, { "OrderID": 2502, "Customer": "Bob", "Country": "UK", "Items": [{ "ProductID": "P05", "UnitPrice": 50, "Quantity": 5, "Variants": [{ "Color": "Blue", "Quantity": 2 }, { "Color": "Red", "Quantity": 3 } ] }, { "ProductID": "P06", "UnitPrice": 80, "Quantity": 1, "Variants": [{ "Color": "Yellow", "Quantity": 1 } ] } ] }, { "OrderID": 2503, "Customer": "Peter", "Country": "UK", "Items": [{ "ProductID": "P07", "UnitPrice": 120, "Quantity": 10, "Variants": [{ "Color": "Green", "Quantity": 4 },{ "Color": "Yellow", "Quantity": 6 } ] } ] } ] } |
Output file: 2501.txt
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
{ "OrderID": 2501, "Customer": "Alex", "Country": "USA", "Items": [ { "ProductID": "P05", "UnitPrice": 50, "Quantity": 1, "Variants": [ { "Color": "Blue", "Quantity": 1 } ] } ] } |
Output file: