1

I am really struggling with the syntax for importing JSON feeds, so much so that I currently cannot even import one but of this. Does anyone know the context for this and how I can grab the fields? Any help received gratefully.

{"604377":{"competitors":{"3521278":{"Name":"Brazil","Jockey":null,"Weight":null,"Saddle":0,"Barrier":null,"QLDWin":0,"VICWin":0,"    NSWWin":0,"QLDPlace":0,"VICPlace":0,"NSWPlace":0,"DetailedPricing":{"winTotePlus":false,"placeTotePlus":false,"topFluc":false,"bestOfBest":false,"bestOrSP":false    ,"fixedOdds":false,"fixedWin":true,"doubleFixedWin":0,"bestOfEverythingWin":0,"bestAnytimeWin":0,"fixedPlace":true,"startPriceGuarantee":0,"fixedEachWay":true,"placePrices":[0],"startPrice":false,"internationalStartPrice":false,"midToteWin":false,"midTotePlace":true,"topToteWin":true,"topTotePlace":false,"top2ToteWin":false,"top2TotePlace":false,"vicToteWinPlus1":false,"vicTotePlacePlus1":false,"vicToteWinPlus2":false,"vicTotePlacePlus2":false,"vicToteWinPlus5":false,"vicTotePlacePlus5":false,"vicToteWinPlus10":false,"vicTotePlacePlus10":false,"exoticBet":true,"exoticMidTote":false,"exoticBest2Tote":false,"exoticBest3Tote":false,"pickYourOdds":false,"firstfour":true,"midToteWinPrice":0,"midTotePlacePrice":0,"topToteWinPrice":0,"top2ToteWinPrice":0,"top2ToteOrSPWinPrice":0,"vicToteWinPlus1Price":0,"vicToteWinPlus2Price":0,"vicToteWinPlus5Price":0,"vicToteWinPlus10Price":0,"topTotePlacePrice":0,"top2TotePlacePrice":0,"vicTotePlacePlus1Price":0,"vicTotePlacePlus2Price":0,"vicTotePlacePlus5Price":0,"vicTotePlacePlus10Price":0,"topFlucPrice":0,"lastFlucPrice":0,"bestOfBestPrice":0,"bestOrSPPrice":0,"bestOrSPPlacePrice":0.75,"winDeduction":0,"placeDeduction":0,"competitor":11863763,"sport":"Soccer","saddle":0,"description":"Brazil 2014 - World Cup Winner ","team":"Jordan","win":0,"place":0,"numOutcomes":24,"numPlacings":1,"numWinners":1},"Scratched":"no","RisaSilkID":null},"3521279":{"Name":"Argentina","Jockey":null,"Weight":null,"Saddle":0,"Barrier":null,"QLDWin":0,"VICWin":    0,"NSWWin":0,"QLDPlace":0,"VICPlace":0,"NSWPlace":0,"DetailedPricing":
  • Your JSON doesn't validate, could be why it isn't importing: check jsonlint.com – Scott Joudry Nov 26 '13 at 13:25
  • I only copied and pasted an excerpt, that could be why. The whole thing is huge! – Rich Stevens Nov 26 '13 at 13:48
  • Yes it is valid but for some reason does not have any square brackets around the arrays? I need to establish the Context but not sure how to - anyone out there got any ideas? Thanks. – Rich Stevens Nov 27 '13 at 3:45

Browse other questions tagged or ask your own question.