How to remove multiple roots in JSON after Conversion

[former_member853862]

Hi,

Am getting below output after xml to json converter. How to remove root in between each record.

{"EmployeeCode":"KIM143291","TitleTypeCode":"MRS","Initials":"AM","FirstName":"Ashley","SecondName":"Long","LastName":"McBain","MaidenName":"","BirthDate":"1976-09-18","Gender":"F","NationalityCountryCode":"USA","Addresses":[{"UseWork":"FALSE","UsePhysical":"TRUE","UsePostal":"TRUE","CareOf":"","AddressServiceTypeCode":"STREET","CityTown":"Cape Town","SuburbDistrict":"","DistrictCode":"","Province":"","CountryCode":"ZAF","PostalCode":"."}],"IDNumber":"784197620941829","Department":"90163","JobTitleTypeCode":"10000518","NatureOfContractCode":"PERM","DateEngaged":"2022-05-01","TerminationDate":"9999-12-31","RaceGroupCode":"","TaxNo":"784-1976-2094182-9","Disabled":"","DisabilityTypeCode":"","TerminationReason":"","PeriodSalary":"100.0","ForeignIncome":"FALSE","RWA_EMP_TYPE":"Perm_S","EntityCode":"477","GenEntityTypeCode":"INDV","GenEntitySubTypeCode":"EMPL","RemunerationEarnDefCode":"BASIC_SALARY","LeavePolicyCode":"STD_LVE","FinalCalcNow":"2","LeaveStartDate":"2022-05-01","LegallyRetiredforTaxPurpose":"FALSE","OverrideAnnualBonusCalcRecurrence":"FALSE","CalendarMonth":"12","TaxStatusCode":"ST","TaxStartDate":"2021-01-01","TaxCalculation":"A","BankAccounts":[{"AccountHolderRelationship":"O","AccountName":"Ashley Long McBain","BankCode":"EBILAEAD","AccountTypeCode":"ARE","AccountNo":"014055917901","BankBranchID":"302620122"}],"HoursPerPeriod":"173.36","HoursPerDay":"8","CreditLineNumber":"AE940260001014055917901","LanguageTypeCode":"ENG","RSSBNumber":"EmiratesID"},"root":{"EmployeeCode":"6009","TitleTypeCode":"MR","Initials":"CS","FirstName":"Craig","SecondName":"George","LastName":"Storkey","MaidenName":"","MaritalStatusTypeCode":"MRI","BirthDate":"1971-10-25","Gender":"M","NationalityCountryCode":"ZAF","Addresses":[{"UseWork":"FALSE","UsePhysical":"TRUE","UsePostal":"TRUE","AddressServiceTypeCode":"STREET","DistrictCode":""}],"IDNumber":"23923","Department":"90163","JobTitleTypeCode":"10000518","NatureOfContractCode":"PERM","DateEngaged":"2022-01-01","TerminationDate":"2022-04-30","RaceGroupCode":"4","TaxNo":"1 1982 7 0092142 0 00","Disabled":"","DisabilityTypeCode":"","TerminationReason":"","PeriodSalary":"100.0","ForeignIncome":"FALSE","RWA_EMP_TYPE":"Perm_S","EntityCode":"477","GenEntityTypeCode":"INDV","GenEntitySubTypeCode":"EMPL","RemunerationEarnDefCode":"BASIC_SALARY","LeavePolicyCode":"STD_LVE","LeaveStartDate":"2022-01-01","LegallyRetiredforTaxPurpose":"FALSE","OverrideAnnualBonusCalcRecurrence":"FALSE","CalendarMonth":"12","TaxStatusCode":"ST","TaxStartDate":"2021-01-01","TaxCalculation":"A","BankAccounts":[{"AccountHolderRelationship":"O"}],"HoursPerPeriod":"173.36","HoursPerDay":"8","LanguageTypeCode":"ENG","RSSBNumber":"NIDNRW"},

Please suggest.

Thanks,

Rupa

[anoop-jose]

Hi Rupa, Is Suppress JSON Root Element in XML to JSON Converter selected ?