API
FairCom DB
FairCom Edge
FairCom MQ
FairCom RTG
FairCom ISAM
All products
  • FairCom DB

    • DB Install

      • JSON DB concepts

        • Tutorials

          • Low Level Development Concepts

            • DB Upgrade

              • Overview

              • Concepts

              • FairCom DB APIs

              • SDKs

              • ACE APIs

              • SQL APIs

              • Administration

              • Breaking changes

            • FairCom Edge

              • Tutorials

                • APIs

                  • Connectors

                    • Transform Methods

                      • Administration

                      • FairCom Edge Overview

                      • FairCom Edge Concepts

                      • Releases & upgrades

                    • FairCom MQ

                      • Concepts

                        • Tutorials

                          • FairCom MQ overview

                          • Administration

                          • FairCom MQ APIs

                        • FairCom RTG

                          • RTG overview

                            • RTG setup and installation

                              • Modern data management with RTG

                                • RTG utilities

                                  • RTG logging, error codes, and troubleshooting

                                    • RTG configuration

                                      • RTG data conversion

                                      • RTG transaction support

                                      • RTG SQL access

                                      • RTG XDD schema structure

                                      • RTG tutorials

                                      • Upgrade files to RTG 5 attribute resource format (Unified Data Types)

                                    • FairCom ISAM

                                      • ISAM configuration file elements

                                        • ISAM utilities

                                          • FairCom ISAM overview

                                          • ISAM quick start

                                          • ISAM setup

                                          • ISAM server setup

                                          • ISAM driver installation

                                          • ISAM configuration

                                          • ISAM data conversion

                                          • ISAM SQL access

                                          • Advanced ISAM techniques

                                          • ISAM logging, error codes, and troubleshooting

                                          • ISAM XDD schema structure

                                          • Btrieve compatibility

                                        • All products

                                          • JSON Action REST API

                                            • Errors

                                              • Security

                                                • FairCom DB Notify

                                                  • Replication

                                                    • User interfaces

                                                      • FairCom Terms Glossary

                                                    1. All products
                                                    2. JSON Action REST API
                                                    3. DB Query Data
                                                    4. API actions

                                                    API actions Articles

                                                    1. closeCursor: JSON DB "closeCursor" action closes a previously opened cursor
                                                    2. getRecordsByIds: JSON DB "getRecordsByIds" action retrieves records from a database table using their IDs
                                                    3. getRecordsByIndex: JSON DB "getRecordsByIndex" action can return a cursor to retrieve a large number of records efficiently or to navigate and retrieve records in any desired way
                                                    4. getRecordsByPartialKeyRange: JSON DB "getRecordsByPartialKeyRange" action retrieves zero or more records from a database table using the specified key range
                                                    5. getRecordsByTable: JSON DB "getRecordsByTable" action retrieves records from a database table in table order and performs a full scan of all records in a table
                                                    6. getRecordsFromCursor: JSON DB "getRecordsFromCursor" action retrieves records from a cursor created by a "getRecords..." action
                                                    7. getRecordsInKeyRange: JSON DB "getRecordsInKeyRange" action returns records within a range of values
                                                    8. getRecordsStartingAtKey: JSON DB "getRecordsStartingAtKey" action positions the current record in the index at the key that most closely matches the comparison criteria
                                                    9. getRecordsUsingSQL: JSON DB "getRecordsUsingSQL" action runs a SQL query and returns the resulting records
                                                    Sorry, we didn't find any relevant articles for you.

                                                    Please fill out the contact form below and we will reply as soon as possible.

                                                    • Privacy
                                                    • Terms

                                                    FairCom Corporation © Copyright 2026