There is a way to return ordered rows from a Data Extension when making a retrieve request using WSProxy?
Something like a LookupOrderedRows, but with SSJS WSProxy.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityThere is a way to return ordered rows from a Data Extension when making a retrieve request using WSProxy?
Something like a LookupOrderedRows, but with SSJS WSProxy.
Since the response being returned from your call will be an array of JS objects, you could just sort the response yourself with a simple function like (sorts alphabetically):
response.sort(function(a, b) {
return a.someKey.localeCompare(b.someKey);
});
The above would require that you had aggregated all of that data that you wished to sort but, with a sufficient filter applied to your WS Proxy retrieve call, that shouldn't be a huge issue.