Hi Team, I have one JSON object having one JSON array in it , I want to sort the contents of this array based on rank field and with best performance possible. Could you please help?
{
"distributors": [
{
"Address1": "3121 US Hwy 22 East",
"Address2": "Suite 301",
"Address3": null,
"Address4": null,
"Attributes": null,
"BusinessHours": "Mon-Tue 8:00 AM-5:00 PM|",
"CategoryIds": "",
"City": "Branchburg",
"ContactName": null,
"ContactPosition": null,
"ContactURL": null,
"CountryCode": "US",
"Coupons": null,
"DailyHoursList": null,
"Distance": 10,
"EmailAddress": rxxxxx@xxxxx.electricvine.com,
"Events": null,
"FaceBookPageId": null,
"FaxNumber": null,
"GeoCodeStatusId": 2,
"Id": 1231,
"ImageFileUrl": null,
"InternetLocation": false,
"IsLeadManager": false,
"IsStoreLocator": false,
"LMServiceID": false,
"Latitude": 40.600771,
"LocationTypeName": "Standard",
"Longitude": -74.686472,
"MobileNumber": null,
"Name": "Atlantic City Dinettes",
"ParticipatingDistributor": true,
"PhoneNumber": "444-444-6464",
"ProductTotal": 3142,
"PostCode": "08876",
"State": "NJ",
"ThirdPartyId": null,
"TimeZone": "(GMT-05:00) Eastern Time (US Canada)",
"URL": null,
"Participation": 10,
"url": www.testsite.com/prod_id/1003,
"quantityOnHand": 300,
"dip_id": "0",
"DateScore": 0,
"DistScore": 18,
"Qty": 300,
"pickShipFlag": "XXXX",
"E_Loyalty": "0",
"rank": 28.0003
},
{
"Address1": "3121 US Hwy 22 EastX",
"Address2": "Suite 301",
"Address3": null,
"Address4": null,
"Attributes": null,
"BusinessHours": "Mon-Tue 8:00 AM-5:00 PM|",
"CategoryIds": "",
"City": "Branchburg",
"ContactName": null,
"ContactPosition": null,
"ContactURL": null,
"CountryCode": "US",
"Coupons": null,
"DailyHoursList": null,
"Distance": 3,
"EmailAddress": rxxxxx@xxxxx.electricvine.com,
"Events": null,
"FaceBookPageId": null,
"FaxNumber": null,
"GeoCodeStatusId": 2,
"Id": 1232,
"ImageFileUrl": null,
"InternetLocation": false,
"IsLeadManager": false,
"IsStoreLocator": false,
"LMServiceID": false,
"Latitude": 40.600771,
"LocationTypeName": "Standard",
"Longitude": -74.686472,
"MobileNumber": null,
"Name": "Electric Distributors Inc",
"ParticipatingDistributor": true,
"PhoneNumber": "444-444-6464",
"ProductTotal": 3142,
"PostCode": "08876",
"State": "NJ",
"ThirdPartyId": null,
"TimeZone": "(GMT-05:00) Eastern Time (US Canada)",
"URL": null,
"Participation": 10,
"url": www.testsite.com/prod_id/1006,
"quantityOnHand": 600,
"dip_id": "0",
"DateScore": 0,
"DistScore": 20,
"Qty": 600,
"pickShipFlag": "XXXX",
"E_Loyalty": "0",
"rank": 30.0006
}
]
}