Dear all,
I have an input file which contain 3 variables information which are :-
1- Price
2- Barcode
3- Quantity
as shown in the picture below:
I have a total of these three variables 82 rows. What I'm looking for is to create a workflow that take each row and generate it in the JSON file as below, the red colored must be duplicated 82 times and changing the variables as per the variables file :-
{
"skin": "weborder",
"establishmentId": 3,
"items": [
{
"price": 48,
"barcode": 100000005774,
"quantity": 1
},
{
"price": 60,
"barcode": 100000005859,
"quantity": 1
}
],
"orderInfo": {
"dining_option": 104,
"asap":true,
"customer": {
"address": {
"address": "XX",
"city": "XX",
"country": "XX",
"province": "",
"state": "",
"street_1": "",
"street_2": "",
"zipcode": ""
},
"phone": "0000000001",
"first_name": "XX",
"last_name": "Auto-poster",
"email": "XX"
},
"call_name": "XX",
"call_number": 909090
},
"paymentInfo": {
"amount": "0.00",
"type": 203,
"transaction_id": "909090"
}
}
Any help in that please?
I have attached the variables file.
