Hola Darko,
As Darren mentioned you earlier, one of options is use the JavaScript column, your code could look like this:
var response = await fetch('https://yesno.wtf/api')
const result= await response.text();
return result
but there are some security warnings that you need to consider. Here we talked about it https://community.glideapps.com/t/fetching-with-a-javascript-column
Saludos!