Parsing Json file

[Sukesh33]

Hi,

We have to import an input json file on a daily basis that has below structure,

{

   "/profile/users":[

     {"id":"001","name":"Sam"},

     {"id":"002","name":"Dav"}

   ],

 "/profile/usernames":[

   {"id":"001","usrnm":"sam123"},

   {"id":"002","usrnm":"dav009"}

  ]

}

I am trying to create a map file to parse the above json, but i was not able to specify path for above users and user names array as that have "/" in them.

{
"DATASETS": [
{
"DSNAME": "users",
"TABLEPATH": "/root/profile/users",
"VARIABLES": [
       {
         "NAME": "id",
         "TYPE": "NUMERIC",
         "PATH": "/root/profile/users/id"
       }

                        ]

}

]}

I am not able to import any data due to the table path. I am able to import and see data when I change the array name as /profile/users -> /profile_users and update path as /root/profile/users/id -> /root/profile_users/id.

How do i read the file as is, sincei will not be able to change it on a daily basis