# Bulk insert from one table to another

**URL:** <https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760>\
**Category:** Ask for Help\
**Tags:** make\
**Created:** [April 20, 2024, 6:58pm UTC](https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760 "2024-04-20T18:58:52Z")\
**Posts on this page:** 2\
**Page:** 2

<div class="post-metadata">

**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\
**Post date:** [April 29, 2024, 8:49pm UTC](https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760/21 "2024-04-29T20:49:01Z")

</div>

Well, I’ve managed to make it work, but IN POSTMAN:

In Glide, it gives the following error:  
“Unexpected token in JSON at position 2”  
Clearly, it’s telling me that my JSON is malformed, right? That’s what I thought, so I started testing in POSTMAN and **exactly the same JSON could add a row correctly to my native glide table**. It returns 200 OK and the new rowID

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46e0711bf0eafa1a0c926b6ffb68119d60571b59.jpeg)

Let me explain how I form the JSON in Glide:

**1** - I form the “mutation” ( I took from the Add Row example of the table where I want to make the insertion) with a template column:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0b8d0a04f6cc6b667012683df93b59bcfa0aae7.png)

**2** - In another table, I call that column “mutation” using a Single Value link

**3** - In a column of type template (called body), I add the App Id and below it the mutation

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7988c013fd34dea91977667230d7119bbe6678b1.png)

It look like this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/38aa3eb5b15c3aacfc4048e2fdc539bc40a523f3.png)

**For me is the same that I write in POSTMAN** I don’t know why is not working

**4** - In the CALL API, I place the headers and the body.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/089cd59f3bd1bd63b97cf887e859f3f663756d02.png)

**What could it be? Is some column adding unwanted characters to my JSON?**  
@ThinhDinh @Darren_Murphy

---

<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:** [April 29, 2024, 11:16pm UTC](https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760/22 "2024-04-29T23:16:51Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7988c013fd34dea91977667230d7119bbe6678b1.png)

Why are you using a single value column here though? Not that it directly is the cause, but I thought you should be using a lookup here.

Any reasons you don’t use a JSON column to create this here, but a template column?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0b8d0a04f6cc6b667012683df93b59bcfa0aae7.png)

[Previous page](https://community.glideapps.com/t/bulk-insert-from-one-table-to-another/72760.md?page=1)