Export a Collection To A JSON

Input collection: myOrders36

OrderID	Item	UnitsOrdered	CostPerUnit
1001	Notebook	25	2.5
1002	Crayons	15	8.62
1003	Binders	10	13.34
1004	Pencils	21	1.5
1005	Erasers	30	0.89

Output to datasource: mySolution36

[{“CostPerUnit”:2.5,”Item”:”Notebook”,”OrderID”:1001,”UnitsOrdered”:25},{“CostPerUnit”:8.62,”Item”:”Crayons”,”OrderID”:1002,”UnitsOrdered”:15},{“CostPerUnit”:13.34,”Item”:”Binders”,”OrderID”:1003,”UnitsOrdered”:10},{“CostPerUnit”:1.5,”Item”:”Pencils”,”OrderID”:1004,”UnitsOrdered”:21},{“CostPerUnit”:0.89,”Item”:”Erasers”,”OrderID”:1005,”UnitsOrdered”:30}]

Solution code:

//Create a collection
ClearCollect(myOrders36,
{OrderID: 1001, Item: "Notebook", UnitsOrdered: 25, CostPerUnit: 2.5},
{OrderID: 1002, Item: "Crayons", UnitsOrdered: 15, CostPerUnit: 8.62},
{OrderID: 1003, Item: "Binders", UnitsOrdered: 10, CostPerUnit: 13.34},
{OrderID: 1004, Item: "Pencils", UnitsOrdered: 21, CostPerUnit: 1.5},
{OrderID: 1005, Item: "Erasers", UnitsOrdered: 30, CostPerUnit: 0.89}
);

//Collection to JSON code
Set(mySolution36, JSON(myOrders36));