In this how-to, we want to export data from SugarCRM and change the JSON into a CSV and send it by Email.
If you have not setup your SugarCRM and elastic.io instance please look to the Setup Howto.
In your flow, you have connected SugarCRM already and select Contact records to poll data from.
Press on the (+) Icon and select CSV Action
In our example we want to write data to the CSV file
In the next step, we need to define the CSV. Here you need to start with the CSV Header
In our example, we use only Email and Account Name. Here we map the SguarCRM Data to the CSV
In the next step, we use Email as Action Component
In our example we use static values to send the email always to us
Now valid your setup and you should receive an email like this
Publish and Start your flow. In the Dashboard, you can see each step what happens what
Voila you should get an email with the first 10 Records