# Glide data to Postgre

**URL:** https://community.glideapps.com/t/glide-data-to-postgre/72729
**Category:** Ask for Help
**Created:** [April 19, 2024, 12:42pm UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729 "2024-04-19T12:42:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Qasim\_Javeed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qasim_javeed/32/64719_2.png) [@Qasim\_Javeed](https://community.glideapps.com/u/Qasim_Javeed)
#### Post date: [April 19, 2024, 12:42pm UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/1 "2024-04-19T12:42:50Z")

</div>

why Make integration with Glide is not working properly I added the module Get Rows and then I inserted those rows into the Postgre but it only gets row data when is there are more than 10 rows and the same for the data insertion in the Postre, it pushes the first row of the table again and again instead of m, moving to next one and I didn’t see any option to solve this a bit complex scenario.

---

<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 20, 2024, 12:24am UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/2 "2024-04-20T00:24:50Z")

</div>

> [@Qasim\_Javeed](#):
>
> but it only gets row data when is there are more than 10 rows

Can you explain this? What do you mean by “only gets row data”?

---

<div class="post-metadata">

### Author: ![Qasim\_Javeed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qasim_javeed/32/64719_2.png) [@Qasim\_Javeed](https://community.glideapps.com/u/Qasim_Javeed)
#### Post date: [April 22, 2024, 5:49am UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/3 "2024-04-22T05:49:36Z")

</div>

like i have a table named test just to test the Make and Glide integration for Postgre  
In this scenario, I am trying to get all the rows of the table test and then trying to insert these rows into the Postgre database but it only gets the first row data as you can see in the image I used a repeater and repeater does the same like I set repeater to 15 and it inserts the first row 15 times in the Postgre,

what else do I have to do to **achieve this** : I want to run the action and it gets all the rows from the Glide table and then inserts/updates data in the Postgre database based on a Column maybe id, like if incoming data contains the same data then update that row else insert the new record.

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

---

<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: [April 22, 2024, 7:35am UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/4 "2024-04-22T07:35:52Z")

</div>

What does the output of your Glide module look like? How many bundles are there?  
Instead of an Repeater, you probably want to use an Interator.  
But even then, what you will have there will be very expensive in terms of Make operations. If you have 1000 rows in your Glide table, that will translate to 2000 operations.

A much better way to do this would be to use a HTTP module to fetch all rows via the API, then an Iterator to step through each row, followed by an Array Aggregator to bundle them up, followed by the PostgreSQL module to insert them all at once.

---

<div class="post-metadata">

### Author: ![Qasim\_Javeed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qasim_javeed/32/64719_2.png) [@Qasim\_Javeed](https://community.glideapps.com/u/Qasim_Javeed)
#### Post date: [April 22, 2024, 8:05am UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/5 "2024-04-22T08:05:38Z")

</div>

I once tried the HTTP with Glide Table Api but the HTTP, asks for a URL, and in the Glide Table Api, there is no specific URL that I can give to the HTTP Module in Make, can you explain it Furthermore, HTTP and GlieTable APi?

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

Maybe you tell me which I have to select in the HTTP.

---

<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: [April 22, 2024, 8:24am UTC](https://community.glideapps.com/t/glide-data-to-postgre/72729/6 "2024-04-22T08:24:29Z")

</div>

Select the “Make a request” module.

Watch the below video. It will answer most of your questions.

> [@electric\_plug Glide API: Connect any platform to your Glide App!](https://community.glideapps.com/t/glide-api-connect-any-platform-to-your-glide-app/38266):
>
> [[Glide API: Connect ANY platform to your Glide App!] ](https://www.youtube.com/watch?v=bHidpKeQSAk)In this video, we take a look at Glide’s newest feature—API integration! Imagine every time you receive a new tweet, payment, calendar booking, or file share, new records get added to your Glide app. With Glide’s API, this is possible in a matter of seconds. In this video, I present one example of connecting Calendly with a Glide app, but the possibilities are endless. Note: Glide API is limited to Pro/Enterprise level apps …
