Goal: Get all Account records with all fields via REST API
Approach: Send GET request with query:
/services/data/v53.0/query?q=SELECT+FIELDS(ALL)+FROM+Account+ORDER+BY+Name+ASC+LIMIT+200
Problem: I have over 1000 objects, but since I'm using FIELDS()
I need to include a LIMIT
clause. I am expecting a nextRecordsUrl
for the remaining objects, however I don't receive one in the response.
Possible workaround: Use OFFSET
to get remaining objects until response is empty. This means I would be sending an additional query to check if I've received all objects.
Would appreciate any advice. Thanks!
FIELDS(ALL)
which is stopping you from leveragingnextRecordsUrl
.