Customer Management

Searching, Paging, and Sorting

4min
for large datasets, amberflo supports paging and sorting endpoint https //app amberflo io/customers/paging https //app amberflo io/customers/paging query string parameters the following query string parameters are passed to the paging endpoint response following is a sample response when customers are sorted by customername in ascending for the search keyword inc and page size of 5 /customers/paging?limit=5\&sort=customername\&search=inc https //docs amberflo io/docs/paging and sorting in customer api { "items" \[ { "enabled" true, "customername" "avengers, inc ", "customeremail" "captain\@avengers com", "updatetime" 1620412138198, "createtime" 1620407940012, "id" "00e99cc3 8d07 4946 87fb fd2fbdc3ada7", "customerid" "00e99cc3 8d07 4946 87fb fd2fbdc3ada7" }, { "enabled" true, "customername" "monsters, inc ", "customeremail" "info\@monsters com", "updatetime" 1620407897347, "createtime" 1620407897347, "id" "0208c479 f72a 456e 9334 5affabc11530", "customerid" "0208c479 f72a 456e 9334 5affabc11530" }, { "enabled" true, "customername" "oceanic airlines, inc ", "customeremail" "info\@oceanic io", "updatetime" 1620407902792, "createtime" 1620407902792, "id" "04df2aa5 6455 4fd9 b7aa 08d53689379e", "customerid" "04df2aa5 6455 4fd9 b7aa 08d53689379e" }, { "enabled" true, "customername" "omni consumer products, inc ", "customeremail" "info\@omni com", "updatetime" 1620407892070, "createtime" 1620407892070, "id" "073ce3e1 544b 47c2 83a8 dc29c9bd89e2", "customerid" "073ce3e1 544b 47c2 83a8 dc29c9bd89e2" }, { "enabled" true, "customername" "stark industries, inc ", "customeremail" "tony stark\@starkindustries org", "updatetime" 1620407934342, "createtime" 1620407934342, "id" "07908636 7509 4ee0 87c8 5a0273822f74", "customerid" "07908636 7509 4ee0 87c8 5a0273822f74" } ], "metadata" { "totalrowcount" 1668, "filteredrowcount" 20, "limit" 5, "page" 1, "totalfilteredpages" 4, "isascending" true, "sort" "customername", "search" "inc" } } items include the actual list of customers on the page, and metadata includes the paging information as explained in the next section paging metadata the paging metadata is returned by the api call it helps the api to keep track of the current paging state "metadata" { "totalrowcount" 1668, "filteredrowcount" 20, "limit" 5, "page" 1, "totalfilteredpages" 4, "isascending" true, "sort" "customername", "search" "inc" } useful queries