Fetching Data to display in a CSV Editor

Overview

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

Prerequisite

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, and select 'Create Flow' in the top action panel. Then select Default Flow and choose 'Create', name the Flow and select 'Create' again to proceed to the Flow Designer. 
   
   
2. 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. 

   
   

3. 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, add a Show Form step to create a form to display the data in the CSV form. 

   
   

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.