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
