Thus, your JSON data has been successfully converted to CSV format. The Output block will contain a URL to the generated CSV file:Ĭopy it and paste it into a web browser to view the CSV data: The Input block shows the inputs provided. In the Steps section, click the action bar to expand. Click on the record that just got created. You'll be taken to the History tab automatically. Save all the changes in the journey and click the Save & Start button.

In the Fields field, specify all the keys present in your JSON object in a comma-separated format.

Ensure to remove the comma from the last curly bracket of the JSON object, else you'll face an error. Note: You can generate the sample JSON data from JSONPlacholder while testing this app.

In the JSON data field, specify the JSON you want to convert:.

In that case, you can simply add a logger and record the output or use the output obtained directly in the form of a data pill in further actions whenever required. You can also select string optionally if you do not need the output in a file.

In the Output field type field, select the CSV output as URL if you need the output in the format of a CSV file.Since here we are using a sample JSON object and hardcoding it, we have selected String. In the JSON data source field, select String or URL as a source of JSON depending on your requirement.No authorization is required as this is a self-created app of Quickwork.Select the Convert JSON to CSV action from the drop-down menu in the Actions field.Under the Steps section, click on the Simple Action button and choose the JSON to CSV app from the drop-down menu in the Apps field.Set the date and time of your choice in the Start at field and keep the Custom payload field empty:.

Set the Interval for One day as we need to fetch the breaking news only once a day on a daily basis.

Select the trigger event, New scheduled event, from the drop-down menu in the Triggers field.

In the Event section, choose the Scheduler by Quickwork app from the drop-down menu in the Apps field.

Converting json file to csv