Concepts

The Query Data section lists and explains of the "getRecords..." actions in the JSON DB API, which query data in FairCom database tables. Each action is a specific technique optimized to find and retrieve records quickly and efficiently. These actions work for all FairCom products that include the FairCom database engine.

Tip When you want to paginate through the query results, return a cursor from a "getRecords..." action and call the "getRecordsFromCursor" action repeatedly until the "moreRecords" property is false.

Note You may be surprised a query response contains "moreRecords": true when the next fetch returns no records. This occurs when the server hasn’t yet detected that it has run out of records. An application should always handle the case when the "getRecordsFromCursor" action returns no records, such as "data": [].