- Introduction
- Get Started with Quixy!
- Sandbox
- Pre-Requisites
- Solution View
- App Creation
- Manage Apps
- In-app conversations (Comments)
- App Settings
- App Events
- Label Printing
- App Data Functions
- Task Reminders
- App Notifications
- Task Escalations
- How to integrate two apps within Quixy using triggers
- User Functions
- Quick Flows
- How to create a report from app data (App Reports)
- How to Integrate Quixy Platform to a third - party platform (Integrations)
- Integration Access
- Low Code System Functions
- Secret Key
- Zapier Integrations
- External Integrations (App Integrations)
- Digital Signature
- Quixy Chatbot
- Database
- Build Reports
- Dashboard
- User Activities
- Admin Activities
- SMS template approval procedures
- System Requirements
- Platform Governance Limitation
- Security Limitations
- Release Notes
- Upcoming Release
- Recent Releases
- Archives
- Release Notes v3.5, Dated: 16-Sep-2023
- Release Notes v3.3, Dated: 04-Mar-2023
- Release Notes v3.2, Dated: 25-Nov-2022
- Release Notes v3.1, Dated: 30-Sep-2022
- Release Notes v3.0, Dated: 30-July-2022
- Release Notes v2.11, Dated:10-Mar-2022
- Release Notes v2.10, Dated:02-Dec-2021
- Release Notes v2.9, Dated:19-Oct-2021
- Release Notes v2.8, Dated:15-Sep-2021
- Release Notes v2.7, Dated: 31-July-2021
- Release Notes v2.6, Dated: 12-June-2021
- Release Notes v2.5, Dated: 04-May-2021
- Release Notes v2.4, Dated: 02-April-2021
- Release Notes v2.3, Dated: 02-Mar-2021
- Release Notes v2.2, Dated: 20-Jan-2021
- Release Notes v2.1, Dated: 23-Dec-2020
- Release Notes v2.0, Dated: 27-Nov-2020
- Release Notes v1.0.31, Dated: 12-Nov-2020
- Release Notes v1.0.30, Dated: 07-Oct-2020
- Release Notes v1.0.29, Dated: 23-Sep-2020
- Release Notes v1.0.28, Dated: 4-Sep-2020
- Release Notes v1.0.27, Dated: 19-Aug-2020
- Release Notes v1.0.26, Dated: 13-Aug-2020
- Release Notes v1.0.25, Dated: 6-Aug-2020
- Release Notes v1.0.24, Dated: 22-July-2020
- Release Notes v1.0.23, Dated: 15-July-2020
- Release Notes v1.0.22, Dated: 10-July-2020
- Release Notes v1.0.21, Dated: 16-Jun-2020
- Release Notes v1.0.20, Dated: 27-May-2020
- Release Notes v1.0.19, Dated: 21-May-2020
- Release Notes v1.0.18, Dated: 18-May-2020
- Release Notes v1.0.17, Dated: 12-May-2020
- Release Notes v1.0.16, Dated: 01-May-2020
- Release Notes v3.4, Dated: 01-Jul-2023
- Best Practices
- FAQs
- FAQs on Form elements basic
- FAQs on the Form Elements Reference
- FAQs on workflows
- FAQs on Integrations
- FAQs on App Store
- What is the difference between Data table & Data source
- What is the difference between Original software and community edition of Mongo DB?
- In case of vulnerability in the MongoDB database will Quixy provide support?
- What is an Orphan Event?
- How can I disable the location tracking pop-up for my organization?
- Does Quixy support Active Directory login?
The External lookup feature allows you to retrieve single-columned values (such as names, city names, etc.) into a Quixy application from any third-party database with an Open/Rest API.
There are two types of APIs:
- Open Source: These are universal APIs that can be used without any restrictions or authentication.
- Secured: These APIs are secured with a password, secret key, or token, requiring authentication to access them.
How to configure External Lookups (Without Authentication)?
- Go to the Admin Menu -> Database -> Lookups.
- Click on the External Lookups tab on the Lookups list page.
- Click on the Add button on the top right corner.
- Select a Workspace and give a Name to the External Lookup.
- Enter the API in the App Reference URL box obtained from the third party.
- Enter the optional parameter in the Optional parameter to test box and click Test URL to check if the API is working.
- Select the required input values for which you want the output values.
- Choose the Authentication Type as None since it doesn't require any authentication.
- Save the External Lookup.
How to configure External Lookups (With Authentication)?
To enhance security, databases often secure their APIs with various authentication methods such as passwords, secret keys, or tokens.
In Quixy, we offer different authentication options to access these secured APIs. Users simply need to acquire the security details from the third-party system and input them into Quixy for access.
Configure a External Lookup (With Authentication)
- Go to the Admin Menu -> Database -> Lookups.
- Click on the External Lookups tab on the Lookups list page.
- Click on the Add button on the top right corner.
- Select a Workspace and give a Name to the External Lookup.
- Enter the API in the App Reference URL box obtained from the third party.
- Enter the optional parameter in the Optional parameter to test box and click Test URL to check if the API is working.
- Select the required input values for which you want the output values.
- Choose the required Authentication Type based on the API's security details.
- Obtain the authentication details from the third-party system and provide them in Quixy.
- Once the API is authenticated, save the External Lookup.
What is Authentication?
Authentication is the process of verifying the identity of a user or system, ensuring that they are who they claim to be before granting access to resources or services. Quixy offers a variety of authentication types. Choose the one that suits your needs best.
2. OAuth 2 Basic Authentication
This is used when the API is secured with a combination of an Access Token, User Name & Password.
3. OAuth 2 Client ID Secret
This is used when the API is secured with a Secret Key.
4. Basic Authentication
This is used when the API is secured with a simple User Name & Password.
5. Token Authentication
This is used when the API is secured with a Access Token.