We are trying to insert exchange rates into a Snowflake table using Open Exchange’s API (https://docs.openexchangerates.org/)
- Currently, the chain looks like Image 1:
- The Open Exchange API outputs a single JSON Object string (Image 2). We are trying to pull the ‘rates’ from this JSON using a Group Node and insert them into a Snowflake table via an ‘Execute Query’ command.
- We’d like to know if this is possible with the JSON Object that Open Exchange provides.
- Snowflake Query looks like (Image 3)