Exporting Data using an API

[Darren_Murphy]

@Dan_San

1. concatenate all/selected columns into a single column and then use SHA256 to hash it.
   Is there an easy way to concatenate all the columns into one

Use a template column to concatenate, and then you can get your hash using this plugin.

@Dan_San

Create a JSON string with the key:value format. So that in the future when I add in new columns it doesn’t break.

You can use a template column to create the JSON structure. For the API part, it depends what the API expects. If it responds to GET requests, then you can probably use the Fetch JSON plugin. Otherwise, you might need to use something like Integromat.

@Dan_San

Interested in how others are exporting data.

I made a tutorial a while back that shows how to create a CSV export. Not entirely applicable in this case, but may give you some ideas about how to use a template column to prepare your JSON.