ImportAccountEntJSON - How to map response having no key only value

[AJ23494]

• ImportAccountEntJSON

Hi Experts , 

The API response i am getting as below (only value no key 😞

 {"data": [

        [

            "a.elumalai@company.com",

            "N",

            "2746"

        ],

        [

            "j.ebrole@company.com",

            "N",

            "2728"

        ],

        [

            "d.perumal@company.com",

            "N",

            "71"

        ],

        [

            "j.b@company.com",

            "N",

            "2706"

        ]}

How to map it in my ImportAccountEntJSON , i tried the below but no luck

"listField": "data",
"keyField": "name",
"colsToPropsMap": {
"accountID": "0~#~char",
"name": "0~#~char",
"customproperty2": "0~#~char",
"customproperty3": "1~#~char",
"customproperty4": "2~#~char"

[This post has been edited by a Moderator to remove sensitive information.]

[shivmano]

have you tried "accountID": "data[0]~#~char" assuming email is always the first value in the list?

[AJ23494]

No luck , already tried