python - Parsing a JSON response from URL -


my requirement parse json response url response. json feed comprised of 2 list namely:

a. "ownerships" - list contain 2 main attributes

  1. nodecode
  2. parentcode

b. "nodes" - list consists of 2 attributes

  1. nodecode (nodecode primary identifier of each node)
  2. nodetype (nodetype can have values "level01", "level02" ,..., "level06")

the logic is:

  • for each nodecode value in "nodes" scan "ownerships" list related parentcode

  • come "nodes" list , search parentcode obtained in earlier step nodecode, , corresponding "nodetype"

  • repeat earlier steps till nodecodes parsed, @ end have below(all these columns single record):

    level01nodecode level02nodecode level03nodecode level04nodecode level05nodecode level06nodecode

bottom line starting lowest level(assuming level01), scan nodes , ownerhips lists, nodecode corresponding level, , keep searching based on parentcode till top levels covered.

the problem here is: a nodecode @ level01 may have parentcode can reside in 1 of levels above(it may @ level03, level04 or @ level06)

how flatten kind of data structure?

sample data structure:

{    "ownerships":[       {          "parentcode":"xx01",          "nodecode":"tt01"       },       {          "parentcode":"xx02",          "nodecode":"tt02"       }    ],    "nodes":[       {          "nodecode":"tt02",          "nodetype ":"level01"       },       {          "nodecode":"xx02",          "nodetype ":"level03"       },       {          "nodecode":"xx01",          "nodetype ":"level05"       }    ] } 


Comments

Popular posts from this blog

networking - Vagrant-provisioned VirtualBox VM is not reachable from Ubuntu host -

c# - ASP.NET Core - There is already an object named 'AspNetRoles' in the database -

ruby on rails - ArgumentError: Missing host to link to! Please provide the :host parameter, set default_url_options[:host], or set :only_path to true -