AnsweredAssumed Answered

Hi All,  I am working in REST JSON Virtualisation.

Question asked by kpreethi0689 on Sep 23, 2015

I have multiple JSON request. I am trying to insert all the values into Database. I want to perform INSERT operation multiple times.I want to take the count of the JSON requests as It may vary dynamically.Kindly let me know whether we have an option in Devtest.

 

Sample Request:

{

    "batch":

    [

        {

            "user":

            {                "aid":"/Web.UI/api/users/kpoRFmoBV0jQIzDPJ3oDx05RAtRHEp2DLzW12fJm54ir2Xi-q9o1Mg","mailboxGuid":"95a8bf4c-b171-4bf5-9bd7-19e612a13d23","primarySmtp":"dstilson@archiving-cust.qa","samAccountName":"dstilson","displayName":"Davin Stilson","firstName":null,"lastName":null,"jobTitle":null,"department":null,"startDate":null,"endDate":null,"office":null,"isDeleted":false,"userRoles":null

            },

                                                "metadata":""

        },

                                {

            "user":

           {     "aid":"/Web.UI/api/users/cZtCEW1GyrWfNTES7v_OO6TnqlxdMYyIX84iXhl7hRoU6L849rIPew","mailboxGuid":"695c1d90-d4f5-4625-9040-0adeb0109539","primarySmtp":"jcolvin@archiving-cust.qa","samAccountName":"jcolvin","displayName":"Jason Colvin","firstName":null,"lastName":null,"jobTitle":null,"department":null,"startDate":null,"endDate":null,"office":null,"isDeleted":false,"userRoles":null

            },

                                                "metadata":""

        },

                                {

                                                "user":

            { "aid":"/Web.UI/api/users/QajFKpatD3KKw9XrOhLCYAHH4Ce0AinPJ3Xz9Fpbt0OGMuq85WKlkQ","mailboxGuid":"3b1e6f25-eae5-4dce-ac00-85aa6d0ffdc1","primarySmtp":"rgillies@archiving-cust.qa","samAccountName":"rgillies","displayName":"Richard Gillies","firstName":null,"lastName":null,"jobTitle":null,"department":null,"startDate":null,"endDate":null,"office":null,"isDeleted":false,"userRoles":null

            },

                                                "metadata":""

                                               

                                }

    ]

}

Outcomes