Hi,
I’ve tried the JavaScript column method, to run API call but is not giving any results, I’m not sure that I understand haw it is working, here is my code (API_KEY is meant to be hided):
One thing to be aware of with this approach is that while you can probably get it to work with a JavaScript column, it won’t be secure. This is because the API call is executed client side, which means that any user of your App could potentially discover your API key - if they know how.
I believe that later this year Glide will give us some more options for doing this sort of thing more securely. In fact I wouldn’t be surprised if we get a direct integration option with OpenAI.
In the meantime, I think if I was to try something like this I’d probably delegate the API call to a 3rd party. Something like Make. So a flow like:
Webhook from Glide to Make
API call from Make to OpenAI
Parse the response in Make and post the data back to Glide via the Glide API
There might be a slight delay using this approach, but I wouldn’t imagine it would be any more than a few seconds.