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. 

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 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 bottom Action Panel.
2. Select Default Flow and choose CREATE.
3. Name the Flow and select CREATE again to proceed to the Flow Designer. 

   

4. In the Flow Designer, navigate to Integrations > My Integrations > Database > Accounts(Database) > dbo_entity_account (Table) category and select the Get all from dbo_entity_account step. 
5. Select Add to add this element to the Flow. 
6. To set up this table, please learn more in the Alternate Access Pattern For Table Integrations article.

   

7. 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.

   

8. 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 CSV form. 

   

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

    

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

Debug

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