If you want to retrieve data from an external JSON file that contains currency rates or any other data, Outgrow provides a robust JSON data source feature that you can use.

Follow these straightforward steps to get started:

1. Head straight to the Charts or Tables section in the Result Settings.

2. Choose JSON as the data source and enter your JSON feed URL. If the JSON is fetched correctly, the JSON status will show as "connected". You can then add more columns to the right to add formulas.

3. If you've turned on Auto Update for the JSON data source, the formula will have to be defined again every time the feed is refreshed.

4. You can use variables from the calculator in the spreadsheet cells and JSON data, such as R1, R2, Q1, Q2, etc. When the graph is created for the end-user, it will automatically fetch the numbers for the variables.

Important Note: If Auto Update is turned on for the JSON data source, the formula will have to be defined again every time the feed is refreshed.

Also, you can use variables from the calculator in the spreadsheet cells along with JSON data. So you can refer to variables like R1, R2, Q1, Q2, etc., and when the graph is created for the end-user, it will automatically fetch the numbers for the variables.

Important Note: To create your JSON in the correct format, you can use tools like https://myjson.com/. If you have any questions, feel free to contact us at Questions@Outgrow.Co, and we'll be happy to help you.