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 }