Lookup tables with API calls - using {key} as field name in the result

Hi,

I am looking to use Lookup Tables with an API for converting currencies in my data.

If I call http://api.fixer.io/latest?symbols=USD I get {“base”:“EUR”,“date”:“2017-07-31”,“rates”:{“USD”:1.1727}}.

My lookup URL looks like this: http://api.fixer.io/{key} How should my single value JSON path look like if I want to obtain the conversion rate for that key? I cant seem to be able to pass the {key} value to the JSON path…

Any hints?

Thanks for your attention.
Regards,
Amin

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.