Skip to content
This repository has been archived by the owner on Feb 2, 2023. It is now read-only.

using ImportJSON only return content of nested array #216

Open
jerrytohvan opened this issue Aug 19, 2021 · 0 comments
Open

using ImportJSON only return content of nested array #216

jerrytohvan opened this issue Aug 19, 2021 · 0 comments

Comments

@jerrytohvan
Copy link

Hello team,
I was wondering if there are any configurations or way that allow me to include values of events.markets.outcomes.
Screenshot 2021-08-19 at 1 01 10 PM

Currently, running =IMPORTJSON("https://smartlyio-travel.herokuapp.com/more_games.json", "/events/markets/outcomes","noInherit,noTruncate") is returning first appearing outcome object.

{
   "key":"rules",
   "name":"Rules",
   "events":[
      {
         "key":"971329",
         "name":"Team A v Team B",
         "markets":[
            {
               "key":"16255688",
               "name":"Match Results (Team A v Team B)",
               "category":"Match Result",
               "outcomes":[
                  {
                     "key":"1",
                     "name":"Team A",
                     "price":1.7
                  },
                  {
                     "key":"2",
                     "name":"Team B",
                     "price":2.5
                  }
               ]
            }
         ],
         "specialFixedOddsMarkets":[
            
         ],
         "competitionMetaData":{
            "featuredName":"AFL",
            "featuredSortOrder":1
         }
      },
      {
         "key":"971329",
         "name":"Team C v Team B",
         "markets":[
            {
               "key":"16255688",
               "name":"Match Results (Team C v Team B)",
               "category":"Match Result",
               "outcomes":[
                  {
                     "key":"2",
                     "name":"Team C",
                     "price":1.2
                  },
                  {
                     "key":"3",
                     "name":"Team B",
                     "price":3.2
                  }
               ]
            }
         ],
         "specialFixedOddsMarkets":[
            
         ],
         "competitionMetaData":{
            "featuredName":"AFL",
            "featuredSortOrder":1
         }
      }
   ]
}
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant