Transforming Data to CSV Format

"CSV"  takes input data in the form of JSON array and transforms them into a CSV format as output.

We will create a flow: "When contacts are imported from HubSpot, fetch contacts from Sendinblue."

Sendinblue doesn’t support the creation of multiple contacts through a JSON input. So, we will convert the query output into a CSV format file using "CSV."

1. Go to the Flows tab from the top menu.
2. Create a new flow.
3. Search and select Setup.
   • Setup acts as a trigger in this flow and runs all the child steps.
   • Setup doesn't require any configuration. Click Done.
4. Add HubSpot in the child step.
5. Add "Get Contacts" query.
6. Connect your account.
7. Enter the number of records you want to import.
   • The records will be imported page-by-page, and the number you provide will be rounded to the nearest page.
   • Leave this field empty, if you want to import all records.
8. Select the List from which you want to import the contacts. Click Continue.
9. Click Test.
10. You will receive a success message when Integry fetches all HubSpot contacts. Click Done.
11.  Click on the three-dots menu on the far right of the query step and then click "Add Child Step."
12. Search and select CSV.
13. Add "JSON to CSV" action.
14. Provide a 'CSV Delimiter' that separates the values in the CSV file (mostly the comma (,) character).
15. Provide the input JSON array in the 'JSON Text' field.
    • Click on the '+' sign, then Get Contacts, and "Add to Field" in front of 'Obj' to add a dynamic tag to the field. Click Continue.
16. Click Test.
17. You will receive a success message when the JSON array of the records fetched by the query step has been converted into CSV format.
18. Click on Test Result to view the converted records.
    • All the contacts imported by the HubSpot query have been converted into CSV format and are separated by a (,).
19. Click on the three-dots menu on the right of the CSV step and the click 'Add Step.'
20. Add "File Append."
21. Add the Append File action.
22. Enter the File Name, File Extension and Data to be appended to the file.
    • Click on the '+' sign, then click on JSON to CSV, then 'Out', and "Add to Field" in front of 'output' to add the tag for the data coming in from CSV step.
23. Click Continue.
24. Click Test.
25. You will see a success message when the data from CSV step has been appended into a file.
26. The File Append step will provide a URL of the file containing CSV data of all imported contacts from HubSpot. Click Done.
27. Click on the three-dots menu on the right of the File Append step and the click 'Add Step.'
28. Add Sendinblue action "Import Contacts."
29. Connect your account.
30. Enter the File URL.
    • You can either enter a value or use tags to add the URL we got in output of the File Append step.
    • Click on the '+' sign on the right of the List field, then click Append File, Out, and then click "Add to Field" to add the tag for 'file_url' to the List field. 
31. Select the List in which you want to import the contacts.
    • You can either enter the List name or use tags to add the URL of the List.
32. Click Continue and the click Test.
33. You will see a success message when all contacts fetched from HubSpot have been imported into Sendinblue.
34. Save and publish your flow.