# 🌐 Please help us test: API Column and Webhook action

**URL:** <https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920>\
**Category:** Ask for Help\
**Created:** [December 15, 2020, 10:30pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920 "2020-12-15T22:30:00Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [December 16, 2020, 7:13am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/42 "2020-12-16T07:13:26Z")

</div>

Yeah, thanks Mark, love the potential!  
Of course you can only do one thing at a time but I was already seeing future presets people could use where they would only have to add their own credentials or stuff.  
But … in the future!  
The potential of this is great!

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [December 16, 2020, 10:52am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/43 "2020-12-16T10:52:21Z")

</div>

Thanks @Mark , and about the OUTPUT from Glide to API services, can you also provide a solution on how to easily send data packets in JSON format? I’m struggling with something as trivial as replacing special characters with their escape sequences, for example. A substr function would suffice but I’m not getting it from the data editor and so I have to involve sheet.  
I hope I have not been too off topic with respect to your help request…

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [December 16, 2020, 12:14pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/44 "2020-12-16T12:14:07Z")

</div>

Same here. Clueless in api 🤦🏻‍♂️

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 16, 2020, 2:27pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/45 "2020-12-16T14:27:35Z")

</div>

This is great feature.  
I guess the maximum benefit of this column will be to integrate various payment solutions as almost all payment solutions provides APIs to work

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 16, 2020, 3:02pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/46 "2020-12-16T15:02:42Z")

</div>

@Roldy What are you trying to do?

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [December 16, 2020, 4:36pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/47 "2020-12-16T16:36:32Z")

</div>

Thanks @Mark.  
My requirement is to create a PDF file through PDFMonkey service via Zapier. PDFMonkey requires a JSON data packet as an input parameter. So in my APP I have a button with a Zapier action that passes some values ​​to the Zapier service and one of these, the most important, is the JSON data packet which represents the information contained within the PDF document to be created.  
Obviously, through a Template column in the data editor, I build the JSON package to be sent, but I have the problem, for example, of checking if there are special characters inside the texts, because if they exist then they must be replaced with escape sequences. It’s a tough job to do inside the data editor, so I’m forced to do it outside Glide, in the sheet.  
In my opinion, the coolest thing would be to have a computed JSON Glide column that represents all the data in the row; alternatively, a function that replaces strings might do the trick.  
Thanks for your attention.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [December 16, 2020, 4:51pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/48 "2020-12-16T16:51:25Z")

</div>

I see. We’ve been thinking of supporting different kinds of escapes/encodings, such as for URLs or JSON.

You could do that with the API column, too 😉

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [December 16, 2020, 4:53pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/49 "2020-12-16T16:53:39Z")

</div>

This would be great @Mark, as is your team.

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [December 16, 2020, 6:37pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/50 "2020-12-16T18:37:04Z")

</div>

Impressive demo of the API column by @david

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/532692986ac2680aacad0e305135566deb2942d8.jpeg "Weekly Fireside Glide") ](https://www.youtube.com/watch?v=-5UMf6UuPKA)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [December 16, 2020, 7:07pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/51 "2020-12-16T19:07:48Z")

</div>

@26:00 Being able to save and reuse actions by mid January! Awesome.

---

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [December 16, 2020, 7:09pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/52 "2020-12-16T19:09:01Z")

</div>

Ah, I forgot to go to the fireside!!!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 17, 2020, 12:30am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/53 "2020-12-17T00:30:22Z")

</div>

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54021e5e48aec624071dd69f2fcbd81922535de1.gif)

---

<div class="post-metadata">

**Author:** ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)\
**Post date:** [December 17, 2020, 1:55am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/54 "2020-12-17T01:55:33Z")

</div>

How can we find out about these? Would love to view more but they are unlisted.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 17, 2020, 4:44am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/55 "2020-12-17T04:44:45Z")

</div>

Yeah!

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [December 17, 2020, 4:55am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/56 "2020-12-17T04:55:06Z")

</div>

Yeeees! I lost webinar but that was what I asked for! AWESOME!

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [December 17, 2020, 8:57am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/57 "2020-12-17T08:57:12Z")

</div>

Hmmm…interesting!

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [December 17, 2020, 2:59pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/58 "2020-12-17T14:59:20Z")

</div>

@Mark @david goo job guys we can definitely use this in email validation(real email or not), Phone number validation, currency exchange, ip location,etc…

Excellent work

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 17, 2020, 4:34pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/59 "2020-12-17T16:34:35Z")

</div>

Just a quick heads up for those that are using Microsoft sharepoint and excel for business or enterprise. Microsft has an api for their excel spreadsheets that you can copy, get, and even insert into those sheets. I know I gave some quick and easy ways to convert excel into google sheets but you could use this in sheets currently as well as when the api feature rolls out. that means no more wasting rows on excel imports 🙂

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [December 19, 2020, 4:03am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/60 "2020-12-19T04:03:04Z")

</div>

Holy smokes I did something!

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 19, 2020, 4:21am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/61 "2020-12-19T04:21:40Z")

</div>

Congrats…I think this is the first video of yours I’ve watched…I didn’t think you would be on a Apple device…hmmm…I wonder how many people use Apple…

[Previous page](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920.md?page=2)

[Next page](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920.md?page=4)
