# Glide API breaks column

**URL:** <https://community.glideapps.com/t/glide-api-breaks-column/46772>\
**Category:** Report a Bug\
**Created:** [August 15, 2022, 9:16am UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772 "2022-08-15T09:16:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\
**Post date:** [August 15, 2022, 9:16am UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772/1 "2022-08-15T09:16:32Z")

</div>

**Describe the bug:**  
When making a http-request in [make.com](http://make.com) which sets a column value to this:

> [customer\_tax\_location\_invalid] Automatic tax calculation in Checkout requires a valid address on the Customer. Add a valid address to the Customer or set either `customer_update[address]` to ‘auto’ or `customer_update[shipping]` to ‘auto’ to save the address entered in Checkout to the Customer. Reference: [Error codes | Stripe Documentation](https://stripe.com/docs/error-codes/customer-tax-location-invalid)

then Glide’s API fails to write to this column **during all future http-requests** even after changing the text.

I assume it has to do with the special characters in stripe’s error message.

**workaround:**  
create new column

---

<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:** [August 15, 2022, 11:23am UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772/2 "2022-08-15T11:23:32Z")

</div>

> [@Gregory](#):
>
> Glide’s API fails to write to this column **during all future http-requests** even after changing the text.

That’s weird. What HTTP response do you get from future requests?

---

<div class="post-metadata">

**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\
**Post date:** [August 15, 2022, 11:30am UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772/3 "2022-08-15T11:30:16Z")

</div>

thanks to @Darren_Murphy I realized that stripe caused the problem by returning a multiline string. I just needed a substring, but this thread offers other solutions too:

> [@Can't add paragraphs via Glide API](https://community.glideapps.com/t/cant-add-paragraphs-via-glide-api/46682/4):
>
> Yes, I understand what the problem is. And as I mentioned, multi line strings in JSON must be properly escaped otherwise your JSON will be invalid.

edit: @ThinhDinh : The http request module returned “Status code: 200” (=success), which made it hard to debug.

---

<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:** [August 15, 2022, 12:00pm UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772/4 "2022-08-15T12:00:23Z")

</div>

You can actually avoid this problem if you use the Create JSON module in Make, and then use the output of that in the HTTP module when you make the API call to Glide. Using the Create JSON module will ensure that you always have a valid JSON structure.

---

<div class="post-metadata">

**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:** [August 16, 2022, 12:00pm UTC](https://community.glideapps.com/t/glide-api-breaks-column/46772/5 "2022-08-16T12:00:35Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.