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
Thank you guys in advance.
Regards,
Dilip
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>
Hi @ThinhDinh thank you for replying.
There are two parts to my problem.
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?
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
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.
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
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?
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
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.
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
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
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
Add some dummy values in those columns so that you can map them.
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
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.
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
Okay, so I did misunderstand. Can I assume that you are using make.com?
My responses below are based on that assumption.
At this point, you will have the RowID value for each row.
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.
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
Just checking, is it possible to do with Glide API?
Using Make would mean ill have to pay for another subscription.
Regards,
Dilip
But do you have access to the Call API action? What plan are you on?