# Exporting Data using an API

**URL:** <https://community.glideapps.com/t/exporting-data-using-an-api/35557>\
**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:** 1\
**Showing post:** 2

<div class="post-metadata">

**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")

</div>

> [@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.

---

_[View the full topic](https://community.glideapps.com/t/exporting-data-using-an-api/35557)._