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
... View more