# Template output Inconsistent?

**URL:** <https://community.glideapps.com/t/template-output-inconsistent/57290>\
**Category:** Ask for Help\
**Created:** [January 31, 2023, 3:50am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290 "2023-01-31T03:50:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 31, 2023, 3:50am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/1 "2023-01-31T03:50:52Z")

</div>

Dear Community and Support

We are trying to send a Staff and/or Family JSON string to an api via the template component,

 ![JXMXET5WLC6Z7X4${F}O](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0ab173d3595e0830117392a44fcb9b503e26887d.png)

The JSON string are setup and extracted from 2 different tables. Both tables’ template column share the same structure.

 ![JSON Setup from Staff Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1fb498d469c9ce91305e8a0c7740e68a0b813d63.jpeg)

 ![JSON Setup from Family Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6106b4fbde4a40d14d1f18b52de8729e502876f6.jpeg)

We then send the chosen JSON to [Pabbly.com](http://Pabbly.com) which direct the data to an NoCodeAPI to populate google sheet. The issue comes when:

If we setup the API call using Staff JSON, it can process Staff JSON, but not Family JSON. and vice verse.

 ![API has different output with same JSOn string format](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e8986e5122b31dd82ff77a9df1397f1bb9ce537.jpeg)

The API returns the following error

 ![Issue shown](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c73f5146a0ab35dcb98c061412682e3b34453e62.jpeg)

The following results in Pabbly showing successes using Staff JSON and failure for Family JSON.

 ![API has different output with same JSOn string format 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e4ccb63ff65f694f1ac100be46539c63d735f6b8.jpeg)

Our question is will template output be inconsistent and how can we check?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b90dc33396b77f276e30ad5ff2dc91d840b02b7.png)

 ![IDAZNOF2~9ZO@D1H)M@XI5K](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b929b271abe10397adfb2b74326bb7ab76450cd.png)

---

<div class="post-metadata">

**Author:** ![glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glide/32/53398_2.png) [@glide](https://community.glideapps.com/u/glide)\
**Post date:** [January 31, 2023, 3:50am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/2 "2023-01-31T03:50:56Z")

</div>

_This is an experimental reply from a bot. Please like it if it’s correct._

Template output can be inconsistent if the data sources used in the template column are not set up correctly. To check, you can review the data sources and make sure they are properly configured. [Glide Docs • Template Store Guidelines](https://www.glideapps.com/docs/reference/faq/template-store-guidelines)

---

<div class="post-metadata">

**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:** [January 31, 2023, 4:01am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/3 "2023-01-31T04:01:34Z")

</div>

@Darren_Murphy I think you or someone else has answered this before. Is Construct URL or URLEncoding the answer here?

---

<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:** [January 31, 2023, 4:04am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/4 "2023-01-31T04:04:31Z")

</div>

yeah, malformed JSON. The answer is to either use the Make JSON column to construct the JSON, or URLencode the strings.

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 31, 2023, 4:22am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/5 "2023-01-31T04:22:41Z")

</div>

URLEncoding? Is there a guide in Glide for this?

Couldn’t get much help here: [Glide Docs • Template Store Guidelines](https://www.glideapps.com/docs/reference/faq/template-store-guidelines)

---

<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:** [January 31, 2023, 4:24am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/6 "2023-01-31T04:24:43Z")

</div>

> **[Glide • Encode Text column](https://www.glideapps.com/plugins/encode)**
>
> Encode text in a variety of formats.

Note that if you use that method, you will have to decode the content on the Pabbly side.  
I would advise trying the Make JSON column first. That’ll probably be a bit easier.

---

<div class="post-metadata">

**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:** [January 31, 2023, 4:35am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/7 "2023-01-31T04:35:29Z")

</div>

> [@pepewaio](#):
>
> Couldn’t get much help here: [Glide Docs • Template Store Guidelines](https://www.glideapps.com/docs/reference/faq/template-store-guidelines)

Unrelated to Darren’s solution, but the link you are referring to was for the template store. I assume you trying to find info on the template column instead.

> **[Template Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/template-column)**
>
> Display dynamic text that can change with the values in other columns.

---

<div class="post-metadata">

**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\
**Post date:** [January 31, 2023, 4:40am UTC](https://community.glideapps.com/t/template-output-inconsistent/57290/8 "2023-01-31T04:40:41Z")

</div>

Thanks Jeff! Let me check through.
