Parsing Json file

Sukesh33 — Tue, 21 Jul 2020 15:49:57 GMT

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

topic Parsing Json file in SAS Enterprise Guide

Parsing Json file