Query data API
List and explanation of JSON DB API actions for querying data
List and explanation 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
For various reasons, the "moreRecords" property may be true when no more records exist. An application should handle the case when the "getRecordsFromCursor" action returns no records.