Retrieve data into Quixy from 3rd party database (External App References)

An overview on External App References

External App References feature is used to retrieve any kind of data into an Quixy application from any 3rd party database that has an Open/Rest API.

There are two different types of APIs:

  1. Open Source: These are universal APIs that can be used by any individual to retrieve the data from the 3rd party database without any restrictions because it does not require any authentication.
  2. Secured: These are also universal APIs but these are secured with a Password, or secret key, or token, etc., that require authentication while consuming these APIs and retrieve the data from the 3rd party database.      

How to configure External App Reference (Without Authentication)?

  • On the dashboard page, click on the Admin Menu > Database > Lookups.

  • On Lookups list page, click on the External App References tab.

  • On External App References list page, click on the Add button on the top right corner of the page.

  • You will land on the External App Reference creation page.

  • Start by giving a Name to the External App Reference.
  • Since we are creating an External Reference with an Open Source API, it doesn't require any authentication, so, choose the Authentication Type as None.  
  • Enter the API that you have obtained from 3rd party system in the App Reference Url box.

  • After entering the API, click on the Test API button at the bottom to examine the API and make sure that it works.
  • If the API works, you will get the option to select the input values.

You can add multiple input fields and the selected Input fields will be in-relation to each other.

  • Once you select the input values, you will have an option the check the output values.
  • The output values will be listed based on the input values that you select.
  • To see the list of output values, click on the Get Output button.

  • The output values would list as shown below

  • Finally, click on the Submit button to save the reference.

How to configure External App Reference (With Authentication)?

Many people across the globe would secure their database's APIs with different types of authentications. The APIs might be secured with a Password, or secret key, or token, etc.,

To consume these APIs, in Quixy we have different types of authentications to access these secured APIs. We just need to obtain the security details from the 3rd party system and provide it in Quixy.

Configure a External App Reference (With Authentication)

  • On the dashboard page, click on the Admin Menu > Database > Lookups.

  • On Lookups list page, click on the External App References tab.

  • On External App References list page, click on the Add button on the top right corner of the page.

  • You will land on the External App Reference creation page.

  • Start by giving a Name to the External App Reference.
  • Select the Authentication type according to the API that you are consuming and it's security.
  • As of now in Quixy, we have four different authentication types.
    • OAuth 2 Clientid Secret: This is used when the API is secured with a Secret Key.

    • Token Authentication: This is used when the API is secured with a Access Token.
 
    • Basic Authentication: This is used when the API is secured with a simple User Name & Password.

    • OAuth 2 Basic: This is used when the API is secured with a combination Access Token, User Name & Password.

Note: You need to obtain the security details (i.e., Token End Point, User Name, Password, Secret Key, Client ID) from the 3rd party system and provide it in Quixy.

  • After providing the authentication values, give the API in the App Reference Url box and click Test API to authenticate the API.

  • Once the API get authenticated, you will get an option to select the Input Values.
  • Select the input values and obtain the Output values.
  • Click on Submit to save the External App Reference.