# Call API Value **URL:** \ **Category:** Ask for Help\ **Created:** [March 28, 2025, 10:37am UTC](https://community.glideapps.com/t/call-api-value/81034 "2025-03-28T10:37:36Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [March 28, 2025, 10:37am UTC](https://community.glideapps.com/t/call-api-value/81034/1 "2025-03-28T10:37:36Z")
Hi guys, can you please tell me what I might have done wrong? I am trying to use an API call to transfer data from the original table to the destination table. I used a JSON template, and while some data has successfully been copied to the destination table, it appears to be the column names rather than the actual values. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70f8d5fbaf95531564b24fcb350e2a1fe5f30f75.png) ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70f8d5fbaf95531564b24fcb350e2a1fe5f30f75.png) ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [March 28, 2025, 10:39am UTC](https://community.glideapps.com/t/call-api-value/81034/2 "2025-03-28T10:39:24Z")
this is the destination table ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0d60978ebb85864ca22495f813c1bb946dc997a.png) ---
**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:** [March 28, 2025, 10:41am UTC](https://community.glideapps.com/t/call-api-value/81034/3 "2025-03-28T10:41:33Z")
You got the column names because that’s what you sent. You need to use replacements in the JSON Template to include the column values. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [March 28, 2025, 11:03am UTC](https://community.glideapps.com/t/call-api-value/81034/4 "2025-03-28T11:03:42Z")
![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9e3d17694586be9f7210bd52b9106eaa95762bf.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d6f1e58c19a119219143e875cedcb1b142e71bb.png) I added the JSON object to the template, which seemed fine, but when I ran it, an error message appeared. ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d359e1d51df16e33ace7fc2a99f1fc2b13171c9.png) ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36ddcae3b27c86d46b4a6cfa2e14690324a177cf.jpeg) ---
**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:** [March 28, 2025, 11:11am UTC](https://community.glideapps.com/t/call-api-value/81034/5 "2025-03-28T11:11:11Z")
You fixed the values in the JSON Template, and broke the keys. ![CleanShot 2025-03-28 at 19.09.29@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f7450cd8a6f26cd8862f5c90b5032f96dc8c0948.jpeg) ![CleanShot 2025-03-28 at 19.10.30@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/613db9d913066a1b296083e69cef4c5d201335ea.png) ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [March 28, 2025, 11:21am UTC](https://community.glideapps.com/t/call-api-value/81034/6 "2025-03-28T11:21:56Z")
Did I do it wrong, please? The value isn’t correct after mapping. ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dff443e2caceec36afa756533763fe4f91e3d00f.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/6669879b6b7f8846b6e49b90ec71fbdffa625341.png) ---
**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:** [March 28, 2025, 12:01pm UTC](https://community.glideapps.com/t/call-api-value/81034/7 "2025-03-28T12:01:51Z")
Yes, it’s still wrong. On the right hand side of your template you have literal strings, so the replacements are being ignored. Instead of “Name”, you should have $Name, and so on. ---
**Author:** ![Stephen\_Hui](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@Stephen\_Hui](https://community.glideapps.com/u/Stephen_Hui)\ **Post date:** [March 28, 2025, 2:53pm UTC](https://community.glideapps.com/t/call-api-value/81034/8 "2025-03-28T14:53:31Z")
> [@Darren\_Murphy](#): > > literal Yes, I made it! Appreciate a lot Darren 🤝 ---
**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:** [April 4, 2025, 2:53pm UTC](https://community.glideapps.com/t/call-api-value/81034/9 "2025-04-04T14:53:44Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.