# šŸŒ Please help us test: API Column and Webhook action **URL:** \ **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:** 6
**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\ **Post date:** [December 23, 2020, 8:16pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/102 "2020-12-23T20:16:59Z")
Hi Guys, I really new to API, a while ago i was trying to make a tournament seeding glide app, but didnt get too far with it. I would appreciate if somebody could help me use this website API, to pull and send data either to a google sheet, or if someone could tell me, if this is something i can do with this API column. **API documentation:** > **[Challonge API v1 Documentation - Challonge](https://api.challonge.com/v1)** ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 27, 2020, 2:22am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/103 "2020-12-27T02:22:13Z")
Hi @Mark Help me please to understand better what syntax the API Column is using to get a right answer? Iā€™m testing a REST API to monitor values from external devices. I can read/write values using it in order to start/stop a light, pump, valve or know their temperatures, levels, etc. Itā€™s something like this but the Glide APP will be the front end for users: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9012615dd998897591cb5432e0c391c7a74397e.jpeg) My API works with this syntax: > http://{server}:{TCP\_Port}/tags/{Object} If I fire a request to read 2 variables (tags) to know their values from any web browser, I will see the answer like: `http://valher.dyndns.org:9990/tags/Temperatures` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/66bad6f50670a33789c797e155b6af44e6da17ac.png) Its JSON file looks like: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/293a406082d5a6c2e6ccb7e538e7cab26515bc79.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/2661328d6b8ce0418a107bd4afa2487d608eb9ac.png) and as you can see, the API supports POST, GET, PUT and DELETE. With it, I could write any value to devices (pump, motor, lamp) in order to start/stop it from Glide if API column is able to use PUT method (so far, it only supports POST). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1f911e1d69ab1bfec727665eabe947c4114ddeb.png) Until here, everything is fine butā€¦ I donā€™t know how to write the right syntax into API Column in my case!! I saw your API demo with Pokemon example and you use: `https://silent-comet-jasmine.glitch.me/pokedex` but at the end, what is the final syntax that API Column is waiting/wishing with its parameter {PokemonName}?. Something like: 1. `https://silent-comet-jasmine.glitch.me/pokedex={PokemonName}` ? 2. `https://silent-comet-jasmine.glitch.me/pokedex/{PokemonName}` ? 3. `https://silent-comet-jasmine.glitch.me/pokedex="{PokemonName}"` ? Again, my API needs to use the syntax: > http://{server}:{TCP\_Port}/tags/{Object} and I could use: 1. `http://valher.dyndns.org:9990/tags/Temperatures` to read **Temp** values 2. `http://valher.dyndns.org:9990/tags/Presures` to read **Pressure** values or 3. `http://valher.dyndns.org:9990/tags/Levels` to read **Levels** values from my devices. but the API Column does not give me any replyā€¦ Must my API have the same Gildeā€™s API Column syntax in order to work? Is there a workaround or Iā€™m missing anything? šŸ™ƒ What I try to do with all this is to bring IIoT world to Glide!! An amazing field and business for many of us. Thanks in advance for your help. Saludos ---
**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 27, 2020, 2:51am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/104 "2020-12-27T02:51:26Z")
What parameters are you passing to your API column within the GDE? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 27, 2020, 3:22am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/105 "2020-12-27T03:22:41Z")
Robert, the Object! http://{server}:{TCP\_Port}/tags/ **Object** My API Column has the value set to: _[http://valher.dyndns.org:9990/tags/](http://valher.dyndns.org:9990/tags/)_ And my parameter is the Object: Pressures, Temperatures or Levels Thanks ---
**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 27, 2020, 3:43am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/106 "2020-12-27T03:43:32Z")
> [@gvalero](#): > > [http://valher.dyndns.org:9990/tags/Temperatures](http://valher.dyndns.org:9990/tags/Temperatures) I imagine Iā€™m unable to access this url? ---
**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 27, 2020, 11:36am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/107 "2020-12-27T11:36:45Z")
The API column expects a result in a very specific format, and your API doesnā€™t provide that format (not its fault, it wasnā€™t built to work with Glideā€™s API column). Youā€™ll have to either change the result format of that API, if itā€™s under your control, or implement a go-between server. The API column is also meant to just read data, not write it. You canā€™t (or rather, shouldnā€™t) use it to actuate a pump. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 27, 2020, 3:28pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/108 "2020-12-27T15:28:29Z")
I see @Mark So far the problems with API column are (I suppose): 1. We need to work with its input format, there is no way to create a custom template in order to work other APIs. Its format is static. 2. We also need to work and have a very specific format as result to get a valid reply. In order to get it automatically, you have to create what you wrote above: a Postman API Clientā€¦ right? but meanwhile, why donā€™t you let to receive the raw data (any answer) and show it into column to handle it as an option if the answer doesnā€™t have the Glide format? I mean, let the API column works like a web browser and shows the incoming result when the format is not the expected. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/66bad6f50670a33789c797e155b6af44e6da17ac.png) In this way, we might handle and modify it using Split Text, Joined Text, ITE, etc and have what I want ā€¦ itā€™s just an idea while the column is improved!. šŸ’Ŗ @Robert_Petitto, you are right, my URL is down for security reasons. I can open it for a short time to test if you want to verify something. My laptop is working as the Devices simulator and the host where the API is running. Thanks and happy weekend. Saludos! ---
**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 27, 2020, 5:58pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/109 "2020-12-27T17:58:25Z")
If you want to activate it today, Iā€™ll see if I can get something working. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 27, 2020, 6:11pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/110 "2020-12-27T18:11:52Z")
Tomorrow Robert, Iā€™m outside my house today. I will notify you to test. Bye ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 27, 2020, 6:32pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/111 "2020-12-27T18:32:47Z")
So, this is still a very early testing or is it possible to use it with apis like payments and sort? ---
**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 27, 2020, 6:33pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/112 "2020-12-27T18:33:55Z")
VERY earlyā€”only availble in Staging at the moment and Glide has mentioned that it wonā€™t be available for quite a while. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 29, 2020, 8:35pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/113 "2020-12-29T20:35:17Z")
> [@Roldy](#): > > 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 Couldnā€™t you just take the url that you built within a template column, then create a second template column that uses the original template column as the template, then add your replacements within that second template columnā€™s settings? ---
**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 29, 2020, 11:18pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/114 "2020-12-29T23:18:18Z")
Thanks @Jeff_Hager, In fact this was my initial approach, but then I realized it was insufficient to be sure the json string would be well parsed. So I opted to build a script and from there, using the JSON.stringify function, I got the perfect data package I needed. ---
**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:** [January 2, 2021, 7:40pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/115 "2021-01-02T19:40:51Z")
---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 12, 2021, 10:21pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/116 "2021-02-12T22:21:15Z")
here my demo APP to try to use the API Column when it is ready and has more capabilities. Meanwhile, I had to use a GS script to get JSON data and make my APP something functional. I will wait for the improvements that @mark will do soon. > **[Machine Control](https://iiot-v2.glideapp.io/)** > > Using IIoT Gateway to control machines ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/484a55135bfab645afd5a8431fe363e5274528f9.jpeg) Saludos! ---
**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:** [February 12, 2021, 11:13pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/117 "2021-02-12T23:13:05Z")
Please donā€™t hold your breath for the API column. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [February 12, 2021, 11:29pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/118 "2021-02-12T23:29:32Z")
Sure! Here I explained my workaround to do my APP but I had wished to make it using API column > [@Glide with IoT, IIoT (Industrial IoT) and Domotic applications](https://community.glideapps.com/t/glide-with-iot-iiot-industrial-iot-and-domotic-applications/22698): > > Hi guys, Here I show you my demo APP where I simulate a Supervisory Control and Data Acquisition (SCADA) for cellular stations. From APP, the user could read/write values (real-time and historical data) from/to devices or machines connected to system. Of course, machines donā€™t talk XML, JSON or HTML and Glide and Google services donā€™t talk industrial protocols either so, I use something called \*\* IoT Gateway\*\* as translator and move the data from plant floor to cloud and vice verā€¦ Happy weekend Mark! ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [March 3, 2021, 1:44pm UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/119 "2021-03-03T13:44:53Z")
How does API Column execute? Is it fired when new row added? In my cases, its iterating same row every time. Iā€™ve tested 3 columns and 3 parameters as well. ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [March 17, 2021, 6:54am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/120 "2021-03-17T06:54:42Z")
Any roadmap to API column? When itā€™ll rollout to glide builder? I think the original concept of API column is replaced by webhook method. Does this column retrieve value and write back to the glide table? Itā€™s hard when playing with APIs on GAS and retrieving back to the sheets and then showing data in glide app. Hope API column make this easier. ---
**Author:** ![mubeeniftikhar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mubeeniftikhar/32/34148_2.png) [@mubeeniftikhar](https://community.glideapps.com/u/mubeeniftikhar)\ **Post date:** [November 18, 2021, 8:10am UTC](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920/121 "2021-11-18T08:10:01Z")
![Screenshot 2021-11-18 at 12.51.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/741b4bba730db7219d20936e03f9db6e560d7a4b.jpeg) I am trying to fetch my authorization which is password back from glide, but unable to get this header in my next response webhook. I am just getting my header1 result. Do you know how can I get my header 4 data to make comparison with my glide password and one fetched here for authorization purpose. [Previous page](https://community.glideapps.com/t/please-help-us-test-api-column-and-webhook-action/19920.md?page=5)