david9595Q: Hi!
I was wondering if it's possible to make an API call for each row using the value from a cell, for example:
Text 1 | Text 2 | API_RETURN_USING_TEXT1_TEXT2
Text 3 | Text 3 | API_RETURN_USING_TEXT3_TEXT4
Thanks!
PS: How long will you be on Appsumo?
Meelad
May 14, 2024A: Hi there! You can reference the value of a cell in your API request using this feature: https://apipheny.io/reference-cell-value-api-request/
And then you can use the =Apipheny formula to paste your API request response in a specific cell: https://apipheny.io/apipheny-custom-function/
So based on the information you provided you could potentially use these two features together to get your desired outcome.
If you have any further questions please reach out to us on our website so we can help you further.
Cheers,
Meelad
Hi Meelad,
Thank you for your reply!
The reference would have to be dynamic, because i can use the {{{cell}}} as a fixed value, so I would have to write a single function for each cell.
I was thinking that another way would be staking the endpoints, but i would need to stack as many lines as rows.
Neither are very practical. I have an API for OCR, imagine I have a list of 1000 URL for images, I want to call the API for each URL, and get a text as an API response for each, so in theory I would have 1000 inputs and 1000 different outputs (each is a single API call).
I checked all your videos and articles and came o the conclusion that is not possible yet.
If Apipheny could be used to "define" a POST/GET for a complete Column, using references to same-row cells, this could potentially replace Zapier and others completely, because it could apply the API call upon receiving new rows of input (maybe the only missing thing would be allowing to define a webhook to append new payloads as new rows)
But I'm realistic, and probably this is outside the scope of the product you guys are aiming for (which seems more like a DATA approach to API instead of transactional/operational)
Thanks!
I would badly need this functionality. I have recomendedApipheny to several friends that bought it.
We really need it.
Hello! If you mean the "reference a range of cells" feature, I wanted to let you know that we just released this feature and it is ready for use. Check it out and contact support if you have any further questions. Thanks!
Hi Meelad,
Do you have a changelog, or a documentation where we could see this in action?
Thanks!
Hello here is the link to the documentation: https://apipheny.io/reference-cell-value-api-request/
Thanks! But not what I thought. My question is:
Can i do something like an arrayformula so that by just using one formula i can make several api calls for all the rows in one column.
I understand i can drag the formulas, but that's not what I would like to do (use case: using apipheny on a google forms result, so every time an entry is received a new api call is made)
Thanks!