Page tree
Skip to end of metadata
Go to start of metadata

This article shows how to initialize the grid with an external data source. You can connect an external data source to the grid using grid configuration.

To initialize a grid follow the steps below:

  1.  Navigate to Data Source tab on the grid configuration page


  2. Select data source you've already connected from the drop-down

    We've added Jira database as a default option in the list. Now you don't need to connect you Jira database as a separate data source. It's already connected by default.




  3. Specify SQL query or JSONPath depending on the data source type

    REST data source 

    SQL data source 


  4. Execute the query to get the data preview

    REST

    SQL data source 

    Try the example REST data source with users' data https://jsonplaceholder.typicode.com/users

    Example of the data retrieved from the Jira database, which is a default option of the SQL data source.

  5. Configure columns mapping
    Select columns from the data source to load information into previously created grid columns. 

    REST data source SQL data source 

    Note!


    Following column types could not display data from the external data source:
    date, date/time. sequence, userlist, and formula.

    In case you have these type of data in your data source, please map them into columns with string or text type.

  6. Save changes.


Congratulations! Now you know how to initialize grid with an external data source.


  • No labels