Set up Filemaker to pull data from Yahoo Finance API

I need have a database with stock symbols and need certain data pulled from this API:

[login to view URL]

Choose one of the various methods listed there, though JavaScript is preferred. I have the MBS plug-in.

The script should cycle through each stock symbol and then return the data to fields for each symbol. Here are the ones to be filled in:

From GET stock/v2/get-analysis

{"maxAge":1,"period":"+5y","endDate":null,"growth":{"raw":0.38900003,"fmt":"38.90%"} : I'm looking for the 38.90 number

"pegRatio":{}

From GET stock/v2/get-statistics

forwardEps":{"raw":0.11,"fmt":"0.11"}

trailingEps":{"raw":-0.05,"fmt":"-0.05"

regularMarketPrice":{"raw":6.5,"fmt":"6.50

The product should be a file with a single table with fields for "Symbol" and the above 5 fields. It should have a script to cycle through the symbols (so pick some sample ones) and fill in the 5 fields from the API.

JavaScript

Project ID: #29568183

About the project