Fetching External Data to a CSV
  • 16 Aug 2024
  • 1 Minute to read
  • Dark
    Light

Fetching External Data to a CSV

  • Dark
    Light

Article summary

Overview

Database entities represent external databases that can be integrated with a flow and then displayed on a CSV file. 

Pre-requisite
Before following this example, create a table integration with the dbo.entity_acount with the database LOCAL CONNECTION. Refer to Integrate with Database Table

Example

In this example, fetch data from the database and place it into a CSV file. Next, the data from the database will display on a form using a CSV editor step. This process can be assembled in two steps in the Flow Designer. 


  1. Begin in a Designer Folder, select Create Flow in the top action panel.

  2. In the Flow Designer, navigate to Integrations > Database > Local Connection > dbo_entity_account (Table) category and select Get all from dbo_entity_account step. Select Add to add this element to the flow. 

  3. In order to convert the data from the database to a CSV file set the Return Data Option property to CSV File and choose to limit the count to a constant if needed.

  4. After the Return Data Option is selected on the Get All from entity_account step, create a Form by using a Show Form step to display the data in CSV control. 

  5. The Form uses a CSV Editor component to display the specified data as a CSV file. Name this component CSVEditor and choose Optional for the Outcome Scenario. This Form also has a Button to close the Form and continue the Flow. Save and close the Form Designer.

  6. Back in the Flow Designer, set the input data on the form. With the Form selected, in the Properties panel under Inputs > CSVEditor choose entity_account_result. Connect the remaining outcome paths to the End step.


Debug

Select Debug in the top action panel of the Flow Designer. When the Flow runs the Form opens and shows the CSV Editor component displays data from the accounts table as designed. Select Done on the Form to finish the Flow. 


For further information on Integrations, visit the Decisions Forum.



Was this article helpful?