Searching, Paging, and Sorting

amberflo supports efficient searching, paging, and sorting for large datasets 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 a sample response for a search using the keyword inc, sorted by customername in ascending order with a page size of 5, includes items the list of customer records returned on the current page metadata contains paging metadata to track the state of the current view /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 metadata section in the response provides important information for managing paging it typically includes "metadata" { "totalrowcount" 1668, "filteredrowcount" 20, "limit" 5, "page" 1, "totalfilteredpages" 4, "isascending" true, "sort" "customername", "search" "inc" } useful queries