# Need help in finding more Video resource on how to send data using API (Post) and Get request **URL:** \ **Category:** Ask for Help\ **Created:** [July 25, 2024, 8:16am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156 "2024-07-25T08:16:12Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 25, 2024, 8:16am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/1 "2024-07-25T08:16:12Z")
Hi Guys, I have query on Get and Post. I need to be able to send all names from Column in a table via Post request to an external source. The external source processes request and gives me different value for each names. I need to check for these names in my source Table and add it across different columns. **Is there any resources or videos explaining in detail?** These are few videos I could get [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea5efb694429220400288978917de8bf1457c961.jpeg "Glide 101: EVERYTHING You Need to Know About Call API and Query JSON") ](https://www.youtube.com/watch?v=7F4e9JatqeM) Thank you guys in advance. Regards, Dilip ---
**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:** [July 25, 2024, 11:33pm UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/2 "2024-07-25T23:33:31Z")
Why do you need to send all names at once? So you’re basically checking each name against a table somewhere else, and return a value\> ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 26, 2024, 12:49am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/3 "2024-07-26T00:49:31Z")
Hi @ThinhDinh thank you for replying. There are two parts to my problem. 1. I have a list of creators with their “name” and “instagram handle” in my table called “Roster” I need to be able to send it to a external DB , this company takes all these names processes it in its backend and stores values like “followers”, “Avg views” etc etc and lot of other parameters in its DB This data might need to be sent once in 3 days etc. I understand that I will need to give a button to send data as we need user centric action in glide. **So I will need a post request to send this data right?** 1. Now Second part is once the data is ready on this 3rd party DB I need to be able to fetch it using a get request I need to map all those values it gets back into creators in my “Roster” table against their “Name” or “instagram handle” **So I’ll need a get request right?** Is this something that can be done? Regards, Dilip ---
**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:** [July 26, 2024, 11:44pm UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/4 "2024-07-26T23:44:17Z")
> [@Dilip\_Adiga](#): > > This data might need to be sent once in 3 days etc. > > I understand that I will need to give a button to send data as we need user centric action in glide. I take it you’re sending to an external API. If you have access to the Call API action, you can do it that way instead of having to run it every 3 days. Else, maybe a JavaScript call would be the way, but you are at risk of exposing your API key. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 26, 2024, 11:58pm UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/5 "2024-07-26T23:58:44Z")
Hi , Thank you for replying. I can have both get and post api. How will I map the result I get from third party to my table Specifically to use name or Instagram handle ? Regards, Dilip ---
**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:** [July 27, 2024, 12:01am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/6 "2024-07-27T00:01:17Z")
I mean do you have access to the Call API action? If you’re already sending an API call from a row, using their “name” and “IG handle” then the results will live inside that row. Why do you need to map that back? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 27, 2024, 12:43am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/7 "2024-07-27T00:43:09Z")
Hi @ThinhDinh , Correct me if my understanding is wrong here. Yes in my plan I have access to call API action. So you are saying I give List of Names to the external source via API call. Step 2: I fetch the data and store it in a separate table? **But there is a corner case.** I might send same creator names once in 3 days so instead of writing a new record it should update the existing record for same creator name right? That’s why I’ll need mapping. Regards, Dilip ---
**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:** [July 27, 2024, 1:03am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/8 "2024-07-27T01:03:15Z")
> [@Dilip\_Adiga](#): > > So you are saying I give List of Names to the external source via API call. You don’t give a list, every API call goes with the data on its own row. It fetches automatically for you, your only work is querying from the JSON your API returns. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 27, 2024, 1:29am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/9 "2024-07-27T01:29:45Z")
Hi, Is there some video I can reference to do this entire thing? Tried finding got the one I shared. Is there any other resource ? Regards, Dilip ---
**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:** [July 27, 2024, 1:35am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/10 "2024-07-27T01:35:27Z")
> **[Call API | Glide Docs](https://www.glideapps.com/docs/call-api)** > > Send and receive data from API endpoints. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b98cca7606bfbc17b956f9087807c1ec3ad9c94.jpeg "Call API | Glide Apps Tutorial") ](https://www.youtube.com/watch?v=V7EN5HEz5EE) ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [July 30, 2024, 5:08am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/11 "2024-07-30T05:08:56Z")
Let me check this @ThinhDinh . If there is some specific video which comes similar to my use case , would be grateful if you can send something which you have handy. Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 6, 2024, 8:28am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/12 "2024-08-06T08:28:13Z")
Hi @ThinhDinh , I have got the api to send list of “CreatorName” and “InstagramHandle” by checking “Show API” I got the curl for it. The curl will have fields which have value in it in response Meaning in its response it will show fields which have value, Example if it has any value in column with name “Followers” it’ll show it else it wont. Now when the external server processes my request and sends in value back, How can I map the fields back to corresponding columns? EX: If there are two fields called “Avg Reel Views” and “Engagement Ratio” will come in after they process the request. How can it be mapped to the corresponding row? Can you help me with this understanding? Regards, Dilip ---
**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 6, 2024, 8:31am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/13 "2024-08-06T08:31:34Z")
> [@Dilip\_Adiga](#): > > Meaning in its response it will show fields which have value, Example if it has any value in column with name “Followers” it’ll show it else it wont. > > Now when the external server processes my request and sends in value back, > > How can I map the fields back to corresponding columns? Add some dummy values in those columns so that you can map them. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 6, 2024, 8:47am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/14 "2024-08-06T08:47:59Z")
Hi @Darren_Murphy , Thank you for replying. SO whenever I click “Add button” and add new values I add dummy values to all fields which I would want response to be written to? Would that be a good practice? Regards, Dilip ---
**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 6, 2024, 9:56am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/15 "2024-08-06T09:56:47Z")
No, that’s what I meant at all. Your issue is that when you query the table through the API, any columns that are empty do not show up in the API response, so you can’t map them - correct? The workaround is to temporarily add dummy values to those columns, then they will show up and you can map them. You only need to do that once, and then you can remove the dummy values. If that’s not the answer you’re looking for, then it means I’ve completely misunderstood your question. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 6, 2024, 10:08am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/16 "2024-08-06T10:08:01Z")
My Problem is this I get a curl which gives me fields which have value in my Database Table. I send Creator name and Creator Instagram handle in this API The 3rd party takes this API processes it and gives me some more values like Followers Count, Avg Reel views , and some other parameters. Now the response I get from this 3rd party needs to be written to the same table corresponding to each creators name. **PS: Same table has columns where these values need to be written.** Regards, Dilip ---
**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 6, 2024, 12:39pm UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/17 "2024-08-06T12:39:11Z")
Okay, so I did misunderstand. Can I assume that you are using [make.com](http://make.com)? My responses below are based on that assumption. > [@Dilip\_Adiga](#): > > I get a curl which gives me fields which have value in my Database Table. At this point, you will have the RowID value for each row. > [@Dilip\_Adiga](#): > > Now the response I get from this 3rd party needs to be written to the same table corresponding to each creators name. Use the RowID values that you obtained earlier. If you do all this inside an iterator-aggregator loop, you should be able to refer to the RowID values directly on each iteration, prepare a mutation to update that specific row, then bundle all the mutations up into a single API call back to Glide at the end of the loop. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 7, 2024, 3:20am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/18 "2024-08-07T03:20:10Z")
Thank you for responding @Darren_Murphy I was thinking of making use of Glide API since my plan allows me to do it? Wouldn’t I be able to add values obtained from 3rd party into my same glide table? which basically has these creator names or ID’s as you pointed out? Ill make provision in my table to have columns which can house these values Regards, Dilip ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 7, 2024, 7:49am UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/19 "2024-08-07T07:49:07Z")
Hi @Darren_Murphy Just checking, is it possible to do with Glide API? Using Make would mean ill have to pay for another subscription. Regards, Dilip ---
**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 7, 2024, 2:18pm UTC](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156/20 "2024-08-07T14:18:43Z")
> [@Dilip\_Adiga](#): > > I was thinking of making use of Glide API since my plan allows me to do it? But do you have access to the Call API action? What plan are you on? [Next page](https://community.glideapps.com/t/need-help-in-finding-more-video-resource-on-how-to-send-data-using-api-post-and-get-request/75156.md?page=2)