Skip to main content

Following steps to create dataset using External Datasource

  • From this document, you will learn to create a dataset in AIV, Also you will learn to make a dataset using External Data Sources.

What is External Dataset?

  • datasets are populated by LiveCompare actions where the results are stored as External Data Sources. User can use this dataset when they want live data.

  • Examples of traditional external data may include information from statistics departments, third-party market research databases, official press releases, etc. ...

Prerequisite

  • User need a API with CSV or JSON extension from which user like to pull the data.

  • There are two supported FileType:- CSV & JSON

  1. Click on hamburger icon.

  2. In Master Data Tab click on Dataset.

    Docusaurus Slash Introduction

  3. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Enter following details in Create Dataset.

info

We are using unpaid API for this example. It is necessary that the API URL should be CSV Type for this example.

  • There are two types of request:-

1. GET: GET request is usually used to get existing data or to retrieve data for an entity set.
2. POST: POST request is usually used to create a new object in the system and obtain information about it.

info

Follow this Link to know more APIs.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

info

POST Request type will releases in subsequent releases.

  1. Click on Preview and submit button.

  2. You will see the External Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  3. Click on visualization Tab and open Dashboard.

  4. From Right Vertical Menu Select the Table Widget icon.

  5. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  6. Enter Following Details in edit box, As shown in figure below:

  • Dataset: External.ds
  • Select all the Field in Dataset Column.
  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

Dataset from CSV

Dataset from EXCEL

Dataset from JSON

Dataset from Flatfiles

info

JSON Filetype & POST Request type will releases in subsequent releases.

✒️To know more about how to create dataset using different sources follow below Links:-

Dataset using CSV

Dataset using JSON

Dataset using Flatfiles

Dataset using Excel

Dataset using Google BigQuery

Dataset using noSQL

Dataset using Join

Dataset using Union

Dataset using Server Script

Dataset using Client Script

Dataset using Stored Procedure

Dataset using View

Dataset using Simple Query

Dataset using Drag & Drop