Jump to content

Trouble getting JSON data


Recommended Posts

I'm trying to update a field from a JSON object, but can't seem to get it to work in FMP16.

 

My JSON object looks like this:

 

{
  • "Global Quote": {
    • "01. symbol": "LUV",
    • "02. open": "36.1400",
    • "03. high": "39.3200",
    • "04. low": "36.0500",
    • "05. price": "38.7600",
    • "06. volume": "11846803",
    • "07. latest trading day": "2020-10-02",
    • "08. previous close": "37.9300",
    • "09. change": "0.8300",
    • "10. change percent": "2.1882%"
    }

}

which I have in a variable ($json), but when trying to update my field, I just get a blank field.

JSONGetElement ( $json ; "Global Quote.price" )

is what I'm using to try to do the update. Anyone see where I'm going wrong?

Link to post
Share on other sites

Thank you!!

after importing his custom functions, 

JSONGetElementDots ( $jsonFormatted ; "Global Quote.05\. price" )

worked!

  • Like 1
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.