May 09, 2018 03:17 AM
Hi there,
Is it possible to return records through the API in a certain order and omit a specified number?
For example, I want to return 10 players sorted by the their points tally (high - low) but I don’t want the top / first 10? (I just want players ranked 10-20)
Cheers,
Thomas.
(P.S. if that’s not possible, is there a way of writing a formula field ‘if’ condition that would translate to this plain English - ‘if first name is alphabetically later (A-Z) than ‘Joe Bloggs’ then return this record’)
May 10, 2018 12:12 AM
To omit certain records you could use the filterByFormula parameter provided by the API, and set it to
AND(rank>=10, rank<=20)
Make sure the parameters are properly URL encoded.
The API also provides you with a “sort” parameter to sort the records
So you could also “sort” by rank and then “filterByFormula” to achieve your desired results
May 10, 2018 01:32 AM
Thanks Andrew - the issue I have is that I can’t create a rank field - as there’s nothing to rank records by. On reflection the P.S. part of my original post is probably closer to the problem I face.