You need to sign in to do that
Don't have an account?
Sasi Rajasekar 4
JSON Parsing- How to parse a nested Array in APex
The below is Json String:
Our requirement is to parse the below Json and update/insert the Salesforce object. Please any one help how to read the nested nodes.
{"ProductionOrder":"O000039","statusType":"download",
"folder1":[{"subFolder1":[{"FileVar":{"Name":"Age-Christoffer Lundeby_extra-large.jpeg","currentext":".jpeg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg"}},
{"FileVar":{"Name":"Aqua.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg"}},
{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg"}},
{"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps"}},
{"subFolder2":[{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg"}},
{"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps"}
}]
}]
}]
'{"ProductionOrder":"O000039","statusType":"download", "folder1":[{"subFolder1":[{"FileVar":{"Name":"Age-Christoffer Lundeby_extra-large.jpeg","currentext":".jpeg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg"}}, {"FileVar":{"Name":"Aqua.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg"}}, {"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg"}}, {"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps"}}, {"subFolder2":[{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg"}}, {"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps"} }] }] }]';
Our requirement is to parse the below Json and update/insert the Salesforce object. Please any one help how to read the nested nodes.
{"ProductionOrder":"O000039","statusType":"download",
"folder1":[{"subFolder1":[{"FileVar":{"Name":"Age-Christoffer Lundeby_extra-large.jpeg","currentext":".jpeg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg"}},
{"FileVar":{"Name":"Aqua.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg"}},
{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg"}},
{"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps"}},
{"subFolder2":[{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg"}},
{"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps"}
}]
}]
}]
'{"ProductionOrder":"O000039","statusType":"download", "folder1":[{"subFolder1":[{"FileVar":{"Name":"Age-Christoffer Lundeby_extra-large.jpeg","currentext":".jpeg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Age-Christoffer Lundeby_extra-large.jpeg"}}, {"FileVar":{"Name":"Aqua.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Aqua.jpg"}}, {"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/Blinds.jpg"}}, {"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/heart_wings.eps"}}, {"subFolder2":[{"FileVar":{"Name":"Blinds.jpg","currentext":".jpg","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/Blinds.jpg"}}, {"FileVar":{"Name":"heart_wings.eps","currentext":".eps","Dirfilename":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","location":"a0eN0000000tELT","filepreviewurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps","filethumburl":"/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings_t.jpg","orderid":"O000039","filestatus":"TBI","fileurl":"cifs://121.240.144.237:445/share/JavaDev/Input/20151124/O000039/JAPAN/20151030/subFolder/heart_wings.eps"} }] }] }]';