I'm trying to find a way to use the output of existing org-babel block in org-mode spreadsheet formulae without rewriting them in emacs-lisp. Is it possible?
TBLFM line is pseudo code, it is syntactically invalid.
#+NAME: currencyRateOnDate #+BEGIN_SRC http :pretty :select .[0].rate GET https://bank.gov.ua/NBUStatService/v1/statdirectory/exchange?valcode=USD&date=${date}&json #+END_SRC | Name | Date | Currency rate | |------+----------+---------------| | Foo | 20210125 | | #+TBLFM: $3=currencyRateOnDate(date=$2) #+CALL: currencyRateOnDate(date="20210714") #+RESULTS: : 27.3216 or alternatively, is it possible to wrap existing org-babel blocks(e.g. in http, ruby "languages") as emacs-lisp wrapped blocks(which could be easily called in org-mode spreadsheet formula)?