Data Sync
  • 2 Minutes to read
  • Contributors

    Data Sync


      Article summary

      An overview of syncing data from 3rd party databases into Quixy

      This functionality makes it safer and easier for Org.admins to import data automatically into the Quixy database from 3rd party databases at regular intervals. With API calls and authentication, this functionality assures data confidentiality and credibility.

      Typically this functionality can be used in transactional processes (such as Employee data sync). On the one hand, data is collected on an ongoing basis, and on the other, you can set up a daily, weekly, or monthly schedule for the collected data to be automatically synced into Quixy database. 

      CAUTION
      Because the Data Sync engine is still in its early stages, there are a few limitations. We will gradually push the limits until it reaches its full potential.

      How to configure Data Sync?

      A NOTE TO ADMINS

      Before jumping into the configuration part, please ensure that you are ready with the below given points:

      1. Create a data table with all the required fields according to your premeditated plan.
      2. Obtain the APIs, Authentication details(if the API is secured), and JSON body from the 3rd party.
      3. The API supports POST and GET method.
      • Navigate to the Data Sync option using the GIF provided below.

      Data Sync Gif

      • Once you land on the Data Sync configure page, as shown below, you need to provide all the details like APIs, Authentication details, Json body, etc.

      2

      • Because every configuration is different, begin by proving the Job Name first.

      3-1

      Config. Option NumberConfig. OptionDescription
      2Operation TypeThis option specifies the operation to be carried out. You can only Add data to the Quixy database right now. 
      3Data Sync FromThis option allows you to choose the mode in which you want to sync your data. API or External Database  
      4API TypeThis option allows you to choose the type of API you're utilizing. SOAP or REST
      5API URLThis is where you put the API that you got from a third party
      6Data formatThis option allows you to choose the type of data format that will be used to fetch data into the Quixy database
      7IntervalThis option allows you to select the intervals that will trigger the data sync
      8Start TimeThis option allows you to specify the exact time at which the trigger point for updating the data in the Quixy database occurs
      9Authentication TypeThis option allows you to bypass the security of secured APIs and choose None for an open API
      10Custom HeadersDefine the headers
      11Input MappingThis option is to define the Input Elements
      12Json ObjectThis is where you enter the JSON body obtained from a third party
      13TypeThis option allows you to specify whether you want the synced data to be displayed as a grid or as individual fields
      • After providing all of the necessary information, you must map the data fields in the 3rd party's Json body to the data fields in the Quixy datatable to ensure no data discrepancy.
      TIP
      The data fields mapping process in this case is similar to the App Data Function's data mapping process.Your content goes here.

      4-4

      • Create the mapping and save the job, as shown below.

      ezgif.com-gif-maker (1)

      • Once the job is saved the data will be synced automatically according to the set interval. However, you will have the option to sync data manually on-demand.

      16-4

      NOTE
      The Data sync functionality can handle connections within Quixy and will automatically handles internet outages by queuing the sync job(s) until internet connection is restored.



       


      Was this article helpful?

      What's Next