# Query JSON - quotation marks **URL:** \ **Category:** Ask for Help\ **Created:** [August 24, 2023, 9:07pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362 "2023-08-24T21:07:02Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Adam\_Crossley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_crossley/32/24083_2.png) [@Adam\_Crossley](https://community.glideapps.com/u/Adam_Crossley)\ **Post date:** [August 24, 2023, 9:07pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/1 "2023-08-24T21:07:02Z")
How do I get the query JSON column to return a string value without quotation marks using JSONata? ---
**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:** [August 24, 2023, 11:28pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/2 "2023-08-24T23:28:49Z")
> [@Adam\_Crossley](#): > > quotation marks I think I know what you mean … are your annoying **quotation marks** at the beginning and end of the received JSON data, right? I suffered this yesterday 🥴 Can you show some screenshots to verify if my workaround is useful for you? Saludos! ---
**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:** [August 24, 2023, 11:54pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/3 "2023-08-24T23:54:05Z")
We talked to @Brett about this yesterday. If I hear something from him, I’ll let you know. ---
**Author:** ![Adam\_Crossley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_crossley/32/24083_2.png) [@Adam\_Crossley](https://community.glideapps.com/u/Adam_Crossley)\ **Post date:** [August 25, 2023, 8:08am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/4 "2023-08-25T08:08:05Z")
```auto {"id":"string","resource":"payment","mode":"test","amount":{"value":"600.00","currency":"QAR"},"description":"Jamm Factory :: Monday - 14:00 :: Drummer","method":"creditcard","redirectUrl":"URLstring","webhookUrl":null,"status":"open","organizationId":"string","sequenceType":"oneoff","metadata":{},"createdAt":"2023-08-24T21:34:43.001Z","expiresAt":"2023-08-24T21:49:42.990Z","_links":{"self":{"href":"URLstring","type":"application/hal+json"},"checkout":{"href":"URLstring","type":"text/html"},"dashboard":{"href":"URLstring","type":"text/html"}}} ``` I need $.\_links.checkout.href but it is returning “URLstring”. I can remove them with an additional template column, but it’s not really a solution with bigger objects with many multiple values needing to be extracted. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 25, 2023, 9:46am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/5 "2023-08-25T09:46:40Z")
Not sure what to do for this! If this is a bug glide team will fix it! In the meantime for one column solution you can use the JavaScript column! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00b84f47b0ab99959b4563a81ecee0ecd37eb38d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17e91a29671189f6d20e40c7b1e338dfcfa39af5.png) JS Code : ```auto const jsonData = JSON.parse(p1); const checkoutHref = jsonData._links.checkout.href; return checkoutHref; ``` Thank you ---
**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:** [August 25, 2023, 9:51am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/6 "2023-08-25T09:51:56Z")
I don’t think it’s a bug, I think it’s default JSONata behaviour. There is probably a simple way to force JSONata to return an unquoted string, but I’ve been searching the [docs](https://docs.jsonata.org/overview) and haven’t found it yet 🤷‍♂️ I’ll be watching this thread to see if somebody provides a simple answer. ---
**Author:** ![Rev](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@Rev](https://community.glideapps.com/u/Rev)\ **Post date:** [August 27, 2023, 9:22am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/7 "2023-08-27T09:22:08Z")
This is so strange, I have this setup on one of my projects and it was working fine without the quotes, now it’s suddenly including the quotes. Is there a way to extract the text within the quotes? I’ve tried using ‘Extract Matching Text’ but haven’t had any luck. ---
**Author:** ![Adam\_Crossley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_crossley/32/24083_2.png) [@Adam\_Crossley](https://community.glideapps.com/u/Adam_Crossley)\ **Post date:** [August 27, 2023, 9:35am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/8 "2023-08-27T09:35:04Z")
Yes, my experience was similar, I could have sworn on the first day the quotation marks didn’t appear. The easiest solution I found for my purposes was to use a template column and replace " with nothing. Obviously a terrible hack and only worked for me because the string itself didn’t contain that character. I’m not quite savvy enough to implement to JavaScript solution above. I’m hoping a solution will appear that doesn’t require additional columns 🙏🤞 ---
**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:** [August 27, 2023, 10:42am UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/9 "2023-08-27T10:42:06Z")
> [@Adam\_Crossley](#): > > Yes, my experience was similar, I could have sworn on the first day the quotation marks didn’t appear. I can confirm this. Not sure what changed on their side. ---
**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:** [August 27, 2023, 5:01pm UTC](https://community.glideapps.com/t/query-json-quotation-marks/65362/10 "2023-08-27T17:01:19Z")
yes I think something was changed from some JSONata library I used to receive the data like: > Aug 18, 2023, 10:13:31 PM|#83a7b|Olguita|555000|0412-555000|olga@dsados.com|Qta Olga, maracay edo. aragua|- (1) RISOTTO ALL’ARAGOSTA: US$9.60|US$9.6|N/A| but now I have the same data wrapped in quotes 🥴 > **"** Aug 18, 2023, 10:13:31 PM|#83a7b|Olguita|555000|0412-555000|olga@dsados.com|Qta Olga, maracay edo. aragua|- (1) RISOTTO ALL’ARAGOSTA: US$9.60|US$9.6|N/A| **"** My workaround to remove these quotes (at the beginning and at the end) was using a JS code (@Adam_Crossley): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8ba1c7d49ccbd242f2a024c7f4bb1e54753a6ace.png) ```auto let lon= p1.length return p1.substring(1, lon-1) ``` I hope it helps meanwhile Saludos!