Desairalze Json string to Jobject

Hello All,
I’m trying to Desairalze Json String into Json Oject so i can write that extracted data into an Excel sheet.
For that I’m using “Read Jason” activity in OpenRPA but not getting the exact output. Please help me regarding this issue.
Below you can find the Json String that needs to be converted in to Jobject form:

{ “GUID” : “DRP33435S9K4C8Z10ICSGGROUPH11131” ,“WorkingSector” : {“Domain”: “Marketing/sales”, “Subcategory”: “”} ,
“WorkSector” : [{“PWorkSector”:“”}] ,
“Organization” : [{“POrg”: “Zaptas Technologies Private Limited”, “POrgDesignation”: “”, “POrgStartDate”: “1 year”, “POrgEndDate”: “”, “OrgStartFormatDate”: “1 year”, “OrgEndFormatDate”: “”, “OrgWorkDurationYears”: “1.0”, “OrgWorkDurationMonths”: “12”, “PSectionOrg”: “”, “OrgGapPeriod”: 0},{“POrg”: “Treemark Solutions private limited”, “POrgDesignation”: “”, “POrgStartDate”: “1 year”, “POrgEndDate”: “”, “OrgStartFormatDate”: “1 year”, “OrgEndFormatDate”: “”, “OrgWorkDurationYears”: “1.0”, “OrgWorkDurationMonths”: “12”, “PSectionOrg”: “”, “OrgGapPeriod”: 0},{“POrg”: “JanBask Digital Design”, “POrgDesignation”: “”, “POrgStartDate”: “1 year”, “POrgEndDate”: “”, “OrgStartFormatDate”: “1 year”, “OrgEndFormatDate”: “”, “OrgWorkDurationYears”: “1.0”, “OrgWorkDurationMonths”: “12”, “PSectionOrg”: “”, “OrgGapPeriod”: 0},{“POrg”: “InTech Services”, “POrgDesignation”: “Content Writer”, “POrgStartDate”: “8 Months”, “POrgEndDate”: “”, “OrgStartFormatDate”: “8 Months”, “OrgEndFormatDate”: “”, “OrgWorkDurationYears”: “0.8”, “OrgWorkDurationMonths”: “8”, “PSectionOrg”: “”, “OrgGapPeriod”: 0}] ,
“ClientOrg” : [{“PClientOrg”:“”,“PClientOrgStartDate”:“”,“PClientOrgEndDate”:“”,“PClientOrgStartFormatDate”:“”,“PClientOrgEndFormatDate”:“” }] ,
“Education” : [{“PEduDegree”: “”, “PEduUniversity”: “Mount Olivet Sr. Sec School-CBSE”, “EduUniversityFullName”: “”, “PEduFaculty”: “”, “PEduPercentage”: “”, “PEduStartDate”: “”, “PEduEndDate”: “2012”, “EduStartDate”: “”, “EduEndDate”: “2012”, “DegreeFullName”: “”, “DegreeShortName”: “”, “DegreeType”: “”, “CollegeName”: “”, “CollegeCityName”: “”, “CollegeStateName”: “”, “CollegeCountryName”: “”, “CollegeUniversityName”: “”, “CollegeDistrictName”: “”, “CollegeShortName”: “”, “UniversityName”: “”, “UniversityCityName”: “”, “UniversityStateName”: “”, “UniversityCountryName”: “”, “UniversityShortName”: “”, “UniversityDistrictName”: “”},{“PEduDegree”: “”, “PEduUniversity”: “Joseph and Mary Public School-CBSE”, “EduUniversityFullName”: “”, “PEduFaculty”: “”, “PEduPercentage”: “Class 12”, “PEduStartDate”: “”, “PEduEndDate”: “2014”, “EduStartDate”: “”, “EduEndDate”: “2014”, “DegreeFullName”: “”, “DegreeShortName”: “”, “DegreeType”: “”, “CollegeName”: “”, “CollegeCityName”: “”, “CollegeStateName”: “”, “CollegeCountryName”: “”, “CollegeUniversityName”: “”, “CollegeDistrictName”: “”, “CollegeShortName”: “”, “UniversityName”: “”, “UniversityCityName”: “”, “UniversityStateName”: “”, “UniversityCountryName”: “”, “UniversityShortName”: “”, “UniversityDistrictName”: “”},{“PEduDegree”: “B.Com”, “PEduUniversity”: “Delhi University (SOL)-DU”, “EduUniversityFullName”: “”, “PEduFaculty”: “”, “PEduPercentage”: “”, “PEduStartDate”: “”, “PEduEndDate”: “2017”, “EduStartDate”: “”, “EduEndDate”: “2017”, “DegreeFullName”: “”, “DegreeShortName”: “”, “DegreeType”: “”, “CollegeName”: “”, “CollegeCityName”: “”, “CollegeStateName”: “”, “CollegeCountryName”: “”, “CollegeUniversityName”: “”, “CollegeDistrictName”: “”, “CollegeShortName”: “”, “UniversityName”: “”, “UniversityCityName”: “”, “UniversityStateName”: “”, “UniversityCountryName”: “”, “UniversityShortName”: “”, “UniversityDistrictName”: “”}] ,
“Certifications” : [{“PCertifications” : “”}] ,“Achievements” : [{“PAchievements” : “”}] ,
“References” : [{“ReferenceOnRequest”: “”, “PReference”: “”, “RefFirstName”: “”, “RefMiddleName”: “”, “RefLastName”: “”, “RefEmail”: “”, “RefPhone”: “”, “RefCompanyName”: “”, “RefPositionTitle”: “”, “PReferenceFullName”: “”, “RefAddress”: “”}] ,
“Trainings” : [{“PTrainings” : “”}] ,
“ResumeOrigin” : “India Based” ,“ProjSkillDuration” : [] ,
“Projects” : [{“PProjectName”:“” , “PProjectDesc”:“” }] ,
“Skills” : [{“PTechSkills”: “MICROSOFT OFFICE”, “TechSkillDuration”: “”, “TechSkillLastUsed”: “”, “TechSkillSelfRating”: “”}, {“PTechSkills”: “POWERPOINT”, “TechSkillDuration”: “”, “TechSkillLastUsed”: “”, “TechSkillSelfRating”: “”}, {“PTechSkills”: “OPTIMIZILLA”, “TechSkillDuration”: “”, “TechSkillLastUsed”: “”, “TechSkillSelfRating”: “”}, {“PTechSkills”: “SEO”, “TechSkillDuration”: “”, “TechSkillLastUsed”: “”, “TechSkillSelfRating”: “”}, {“PTechSkills”: “GOOGLE ADWORDS”, “TechSkillDuration”: “”, “TechSkillLastUsed”: “”, “TechSkillSelfRating”: “”}] ,
“SoftSkills” : [{“PSoftSkills”: “”, “SoftSkillDuration”: “”, “SoftSkillLastUsed”: “”, “SoftSkillSelfRating”: “”}] ,
“ProjectSkills” : [{“ProjectSkillDuration”: “”, “PProjectSkill”: “”, “ProjectSkillLastUsed”: “”}] ,
“ExpSummary” : [{“PEXPSUMMARY”: “”}] ,
“TotalExpNum” : {“PTotalExpNum”: “3.8”} ,
“PersonalInfo” : {“AlternateContactCountryCode”: “”, “AlternateContactNo”: “”, “CurrentAddress”: {“PCurrentFullAddress”: “Flat No. 701, Tower 1 River Heights, Raj Nagar Extensions, Ghaziabad”, “ZipCode”: “201001”, “Street”: “Raj Nagar Extensions”, “State”: “UTTAR PRADESH”, “Country”: “India”, “City”: “Ghaziabad”, “Landmark”: “”, “Address1”: “Flat No. 701 Tower 1 River Heights”},
“DateOfBirthFormat”: “1/12/1996”, “FirstName”: “Anusha”, “FormatName”: “Anusha Tyagi”, “LastName”: “Tyagi”, “MiddleName”: “”, “MobileCountryCode”: “+91”, “MobileNo”: “9650866623”, “PAadharNo”: “”, “PAlternateContactNo”: “”, “PAlternateEmail”: “”, “PCurrentLocation”: “”, “PDateOfBirth”: “1-December-1996”, “PEmail”: “anushatyagi3@gmail.com”, “PFacebook”: “”, “PFatherName”: “”, “PGender”: “”, “PGitHub”: “”, “PHobbies”: “Listening to music and Travelling new places”, “PInstagram”: “”, “PLanguage”: “English,Hindi”, “PLinkedIn”: “”, “PMaritalStatus”: “Married”, “PMobileNo”: “+919650866623”, “PMotherName”: “”, “PName”: “Anusha Tyagi”, “PNationality”: “Indian”, “PPanNo”: “”, “PPinterest”: “”, “PSkypeID”: “”, “PTwitter”: “”, “PassportDetails”: {“PPassportExpiryDate”: “”, “PassportExpiryFormatDate”: “”, “PPassportIssueDate”: “”, “PassportIssueFormatDate”: “”, “PPassportIssuePlace”: “”, “PPassport”: “”}, “PermanentAddress”: {“City”: “”, “State”: “”, “Country”: “”, “Street”: “”, “ZipCode”: “”, “Address1”: “”, “PPermanentFullAddress”: “”, “Landmark”: “”}, “TitleName”: “”, “VisaDetails”: [{“PVisaType”: “”, “PVisaExpireDate”: “”, “PVisaCountry”: “”, “VisaExpireFormatDate”: “”, “VisaStatus”: “”}], “FileName”: “anusha updated resume 2023.docx”, “PInterestArea”: “”} ,“PCandidatePhoto” : “” ,“SalaryDetail” : {“CurrentSalary”: {“PCurrentSalary”: “”, “PCurrentCurrencyType”: “”, “FormattedCurrentSalary”: “”},
“ExpectedSalary”: {“PExpectedSalary”: “”, “PExpectedCurrencyType”: “”, “FormattedExpectedSalary”: “”},
“PNoticePeriod”: “”, “Immediate”: “”, “Negotiate”: “”, “BuyOut”: “”, “PPreferredLocation”: “”, “ReadyToRelocate”: “”} ,“Extension” : “docx” ,“FileName” : “anusha updated resume 2023.docx” ,“CreatedDate” : “2023-05-24 12:07:06.567005” ,“ResumeSource” : “INDIVIDUAL” ,“CurrentWorkTitle” : “Content Writer” ,“Duplicate” : “No” ,“_id” : 7409 }

I am not at a machine with openrpa right now, butif i remember correctly read json only works with arrays and only flat json trees
But you can read the json files content using system.io.file.readalltext and then load it using JObject.Parse( json )

When reading and deserializing getting this error. Please check it.

1 Like

Thank you Allan, Those methods are working.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.