function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sasi Rajasekar 4Sasi Rajasekar 4 

WebService - JSOn

Help us in parsing this nested List -Webservice?


{"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"} }] }]   }]';
Sasi Rajasekar 4Sasi Rajasekar 4
WebService: Below is the Json String given. Our requirement is to parse this nested nodes and update the Salesforce object by using POST method of Rest API.
Could you please help?

The input JSON String:

{"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"} }] }]   }]';
Amol SolankiAmol Solanki
Hi Rajasekar,

This is how you can parse the json string. 
String jsonStr = 
        '{"invoiceList":[' +
        '{"totalPrice":5.5,"statementDate":"2011-10-04T16:58:54.858Z","lineItems":[' +
            '{"UnitPrice":1.0,"Quantity":5.0,"ProductName":"Pencil"},' +
            '{"UnitPrice":0.5,"Quantity":1.0,"ProductName":"Eraser"}],' +
                '"invoiceNumber":1},' +
        '{"totalPrice":11.5,"statementDate":"2011-10-04T16:58:54.858Z","lineItems":[' +
            '{"UnitPrice":6.0,"Quantity":1.0,"ProductName":"Notebook"},' +
            '{"UnitPrice":2.5,"Quantity":1.0,"ProductName":"Ruler"},' +
            '{"UnitPrice":1.5,"Quantity":2.0,"ProductName":"Pen"}],"invoiceNumber":2}' +
        ']}';

    // Parse entire JSON response.
    JSONParser parser = JSON.createParser(jsonStr);
    while (parser.nextToken() != null) {
        // Start at the array of invoices.
        if (parser.getCurrentToken() == JSONToken.START_ARRAY) {
            while (parser.nextToken() != null) {
                // Advance to the start object marker to
                //  find next invoice statement object.
                if (parser.getCurrentToken() == JSONToken.START_OBJECT) {
                    // Read entire invoice object, including its array of line items.
                    Invoice inv = (Invoice)parser.readValueAs(Invoice.class);
                    system.debug('Invoice number: ' + inv.invoiceNumber);
                    system.debug('Size of list items: ' + inv.lineItems.size());
                    // For debugging purposes, serialize again to verify what was parsed.
                    String s = JSON.serialize(inv);
                    system.debug('Serialized invoice: ' + s);

                    // Skip the child start array and start object markers.
                    parser.skipChildren();
                }
            }
        }
    }