Fetching Data From Database to CSV File
  • Updated on 17 Sep 2014
  • 1 minute to read
  • Print
  • Dark
    Light

Fetching Data From Database to CSV File

  • Print
  • Dark
    Light

Overview

Database entities represent external databases which can be integrated with a flow and then displayed on a CSV file. In this example, we are going to fetch data from the database into a CSV file. Next the data from the database will display on a form using a CSV editor step.

Example

Fetching data from a database and then displaying the data on a CSV file can be assembled in two steps in the flow designer.  In the flow designer navigate to Integrations > My Integrations > Database > Accounts(Database) > dbo_entity_account (Table) category and select Get all from dbo_entity_account step. Select Add to add this element to the flow.
2018-08-16_161150.jpg

In order to convert the data from the database to a CSV file set the property to CSV File and choose to limit the count to a constant if needed. 
2018-08-17_110140.jpg

After the Data Return option is selected on the Get All from entity_account Step, create a form to display the data in CSV form. On the form use a CSV editor component to display the specified data as a CSV file.
2018-08-17_111844.jpg

In the Flow Designer set the input data on the form, Select Entity_account_Result.
2018-08-17_111604.jpg

Our Form opens in the Debugger . We can see that CSV Editor component displays fetched from database accounts as we designed. We click Done on the Form
2018-08-17_112145.jpg

Was this article helpful?