# Glide API and JSON question **URL:** \ **Category:** Ask for Help\ **Created:** [September 5, 2022, 12:53pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624 "2022-09-05T12:53:29Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 5, 2022, 12:53pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/1 "2022-09-05T12:53:29Z")
Hi glide friends, I’m trying to create a row in a glide table via Zapier, using the Glide API and a JSON string. BUT, it won’t work 😄 Please see attached screenshot from Zapier. Am I replacing the right information? Or should I really be replacing the stuff in front of the colons? Or am I missing something else completely? Thanks in advance for your tips! Cheers, Daniel ![Screenshot 2022-09-05 at 13.48.58](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/567a7c66e74a8eb827bf16593df679ea69908f61.png) ---
**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:** [September 6, 2022, 12:35am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/2 "2022-09-06T00:35:52Z")
It looks to be the correct structure for me. What response does it give to you when you run a POST request? ---
**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:** [September 6, 2022, 12:41am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/3 "2022-09-06T00:41:44Z")
Check your source data for any character or string sequences that might be invalidating the JSON. Unescaped multi-line strings is a common source of error. Does Zapier have a “Construct JSON” module? If it does, I’d encourage you to use that to prepare your JSON payload. ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 6, 2022, 6:51pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/4 "2022-09-06T18:51:45Z")
Thanks ThinhDinh, I’m getting this error in Zapier. ![Screenshot 2022-09-06 at 20.50.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca83e783b491f11975db4724e261baf3288ec86d.png) ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 6, 2022, 7:19pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/5 "2022-09-06T19:19:18Z")
Also thanks to you Darren, Inspecting JSON like you suggest is beyond my knowledge, I’m afraid 😵‍💫 In Zapier I’m using the “Custom Request”, but it also do have POST. See attached. Maybe I should give that a try. ![Screenshot 2022-09-06 at 21.17.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9c65f2f88a726861664e8df5e797cd24edda10d.png) ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [September 6, 2022, 11:23pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/6 "2022-09-06T23:23:15Z")
Could you please show the rest of the details for the setup for this zap’s action? Once you select Custom Request there is a dropdown to select Post. Maybe you have something missing from one of the other selections… ---
**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:** [September 6, 2022, 11:50pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/7 "2022-09-06T23:50:50Z")
Yeah, maybe we need to see if the header has been added. I suspect this is an authentication error when there’s no authentication bearer key. ---
**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:** [September 7, 2022, 1:09am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/8 "2022-09-07T01:09:51Z")
> [@Daniel\_Gjode](#): > > Inspecting JSON like you suggest is beyond my knowledge, I’m afraid 😵‍💫 That’s not what I suggested 🙂 > [@Darren\_Murphy](#): > > Check your source data Your source data is the data that’s being sent from Glide. I assume that inspecting your own data is not beyond your knowledge? 😉 Some characters are reserved in JSON and can only be used if they are [properly escaped](https://www.tutorialspoint.com/json_simple/json_simple_escape_characters.htm). So, if the data that you are sending from Glide contains new lines or tabs (for example), then that would most likely invalidate your JSON, and Glide would reject it. And the reason I suggested looking for a “Construct JSON” module in Zapier is because something like that would take care of the above for you, so you don’t need to worry about it. ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 17, 2022, 11:30am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/9 "2022-09-17T11:30:03Z")
Hi NFNHello, Apologies for late response. I really appreciate you trying to help. Here’s two screenshots showing the remaining fields. Still can’t get it to work. Any tips would be massively appreciated. ![Screenshot 2022-09-17 at 12.11.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/745d3f2105074bf295969ce6cb4fe26f13fc46fd.png) ![Screenshot 2022-09-17 at 12.11.12](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c02adb69c1cde973560e19397014b7871a62226.png) ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 17, 2022, 11:31am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/10 "2022-09-17T11:31:05Z")
Apologies for late response. I really appreciate you trying to help! I posted two screenshots below showing the Zap. Do you see anything wrong there? THANKS Daniel ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [September 17, 2022, 7:35pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/11 "2022-09-17T19:35:37Z")
I don’t see anything obvious. My troubleshooting mind starts to wonder about a few things… - Your screenshot shows a green check for the Zapier Test action. Is this because you skipped the test, or did you resolve the original problem? - Does your app support API access? Only current Pro apps and above, and certain older plans allow API access. - Is your webhook using the information for the right app and table? Is it the same one you are verifying? These are just shots in the dark and are based on my own personal mistakes. Hopefully they’ll help you figure out what’s going on. ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 19, 2022, 5:47pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/12 "2022-09-19T17:47:12Z")
Thanks NFNHello, I skipped the test, and I’m running Business App. I’ll double-check webhook information, but I feel I’ve copied it out from the app a thousand times to retry 🙂 Thanks for shooting in the dark. At some point we’ll hit something! ---
**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:** [September 20, 2022, 11:35am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/13 "2022-09-20T11:35:45Z")
Your URL is wrong. It should start with [https://api.glideapp.io/…](https://api.glideapp.io/%E2%80%A6) ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [September 20, 2022, 3:48pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/14 "2022-09-20T15:48:55Z")
I remember recently seeing a different URL under the Show API menu. It looked similar to the one in the screenshot above. I never used it because I keep a note file for easy copy/pasting that has the [api.glideapp.io](http://api.glideapp.io) one but there may either be a bug or something else. I went back to the app and it no longer has the other URL, so maybe it was fixed? ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [September 20, 2022, 5:43pm UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/15 "2022-09-20T17:43:43Z")
Thanks for spotting this Robert. I swear it’s a copy/paste from Glide 😶‍🌫️ – But as you say NFNHello, it might be a bug that’s been corrected. I’ll try it asap and let you know. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 22, 2022, 11:54am UTC](https://community.glideapps.com/t/glide-api-and-json-question/48624/16 "2022-09-22T11:54:58Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.