AnsweredAssumed Answered

Best why to pull data from Json file

Question asked by Tom_Droz on Feb 24, 2018
Latest reply on Feb 25, 2018 by fmpdude

I have a long json code.  I am not sure the order will be the same each time so instead of pulling data based on a number in the array, I want to pull it based on the name of the element.  Example: in the data shown below I want to see the value "2002" for the "Model Year", the "Make" would return "Pontiac" an so forth.  Can anyone direct me to a good example that shows this?

 

I have to pull 100 pieces of info from the file then put them into fields inside FM, so any tips how to do this efficiently is appreciated!!

 

[

            {

                        "name"
: "Model Year",

                        "unit"
: "",

                        "value"
: "2002"

            },

            {

                        "name"
: "Make",

                        "unit"
: "",

                        "value"
: "
Pontiac"

            },

            {

                        "name"
: "Model",

                        "unit"
: "",

                        "value"
: "Bonneville"

            },

            {

                        "name"
: "Trim Level",

                        "unit"
: "",

                        "value"
: "SE"

            },

Outcomes