# Exporting Data using an API **URL:** \ **Category:** Ask for Help\ **Created:** [December 6, 2021, 12:27am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557 "2021-12-06T00:27:05Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [December 6, 2021, 12:27am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557/1 "2021-12-06T00:27:05Z")
I need to export the data into an external database using an API (experimental code Fetch), anyone done this ? This is what I want to do : 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 2. Create a JSON string with the key:value format. So that in the future when I add in new columns it doesn’t break. 3. use an API to send the JSON data across to my API which will then also produce a SHA256 hash and send it back 4. compare the hash and if they are the same then mark row for deletion Interested in how others are exporting data. The export Glide App Data doesn’t seem to export the calculated fields which I need. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 6, 2021, 12:44am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557/2 "2021-12-06T00:44:14Z")
> [@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](https://www.glideapps.com/plugins/sha256). > [@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](https://www.glideapps.com/plugins/fetch) plugin. Otherwise, you might need to use something like Integromat. > [@Dan\_San](#): > > Interested in how others are exporting data. I made a [tutorial](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618) 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. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [December 6, 2021, 2:11am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557/3 "2021-12-06T02:11:06Z")
Thanks Darren, This is very helpful. Let me take a look into this a bit more. Is there way we can automate the sending of the CSV file based on time (at midnight) or does it require user action. Rgds ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 6, 2021, 2:21am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557/4 "2021-12-06T02:21:36Z")
Unfortunately it needs an action to trigger the webhook. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [December 6, 2021, 4:19am UTC](https://community.glideapps.com/t/exporting-data-using-an-api/35557/5 "2021-12-06T04:19:48Z")
Maybe this 2 part scenario from @Mark_Turrell could be of some use > [@Countdown timer sent to SMS or Push Notification](https://community.glideapps.com/t/countdown-timer-sent-to-sms-or-push-notification/35478/4): > > I do this in my telemedicine app slight_smile glide side - button with the parameters to pass to integromat eg tel, message, time to send integromat scenario - 2 separate ones A - webhook gets values and stores in a Data Store (set with 1mb side, structure matches the we hook parameters, store the time value as a string) B - scenario running on scheduled basis i search Data Store - all records (best) II - filter based on time to send compared to now (format as time) Iii - click send…