(Solved) – VBA Parsing JSON resonse from MongoDB query using pymongo

  • by
(solved)-–-vba-parsing-json-resonse-from-mongodb-query-using-pymongo

I am trying to parse below JSon to key:value pairs but facing issues (like date formats and others) with JsonParser (got from other posts)

{"_id": "5df07732ee35880001d66984", "applicantIndex": 0, "isAutoPrompt": False, "losLoanOfficerId": "lo.testtwo", "journey": "FULLAPPLICATION", "queryParams": {"creditVendor": "CBC_CRE_1", "branchId": "964", "redirectUrl": "http://www.google.com/", "creditPreferenceIndicator": "true", "nmlsId": 654321, "creditVendorId": "123456"}, "originatedInFinX": True, "fullName": "personemail", "updatedDate": datetime.2019, 12, 11, 9, 35, 51, 255000, "userId": "personemail.personlast@zetat.com", "fullApplication": {"incomeIntegrationDetails": {"incomeIntegrated": False, "isIntegrationFailed": False}, "propertyDetails": {"propertyIdentified": "Yes", "underContract": "Yes"}, "sectionDetails": [{"isFormCompleted": False, "section": "FULLAPP_GET_STARTED", "isCompleted": False}, {"isFormCompleted": False, "section": "FULLAPP_INCOME_DETAILS", "isCompleted": False}, {"isFormCompleted": False, "section": "FULLAPP_DECLARATION_DETAILS", "isCompleted": False}, {"isFormCompleted": False, "section": "FULLAPP_ECONSENT_DETAILS", "isCo
mpleted": False}, {"isFormCompleted": False, "section": "FULLAPP_SUMMARY_DETAILS", "isCompleted": False}], "assetIntegrationDetails": {"isIntegrationFailed": False, "assetIntegrated": False}, "personalDetails": {"firstName": "personemail", "lastName": "personlast", "address": [{"itemId": "a8aa589f-df25-4f2f-95c8-23581a7df73e", "residenceType": "I own this property", "months": 2, "cityName": "Irving", "stateName": "Texas", "mailingAddress": True, "addressType": "current", "postalCode": "75063", "stateCode": "TX", "streetAddressLine1": "4555", "years": 12, "encompassId": "Residence/0"}], "contactPreference": "Home", "dob": datetime.1988, 12, 12, 0, 0, "homePhone": "168-233-1197", "usCitizen": "Yes", "maritalStatus": "Married", "email": "personemail.personlast@zetat.com"}, "basicDetails": "I am employed", "creditIntegrationDetails": {"isIntegrationFailed": False, "creditIntegrated": False}}, "referenceId": "IN004192", "currentConditionId": "CREDIT_SCORE", "createdDate": datetime.2019, 12, 11, 4, 57, 22, 958000, "loanOfficeI
d": "cyclet@cycletmc.com", "verifyAssetsLOPreferenceIndicator": "true", "isCoAppAutomiticallyCreated": False, "name": "personemail", "creditPullLOPreferenceIndicator": "true", "verifyEmploymentLOPreferenceIndicator": "true", "status": "PARTIAL", "purposeCategory": "Buy a new home", "touchPoint": None, "firstLosCreateRequestDateTime": datetime.2019, 12, 11, 4, 58, 22, 306000, "losStatus": "PARTIAL_COMPLETED", "submissionStatus": "COMPLETED", "losDetails": {"maxVodIndex": None, "mailingAddressEncompassId": "Residence/1", "borrowedAmountVodIndex": None, "personalDetails": {"address": [{"encompassId": "Residence/0", "itemId": "a8aa589f-df25-4f2f-95c8-23581a7df73e"}]}}, "loanNumber": "1070035589", "submittedDate": datetime.2019, 12, 11, 4, 58, 47, 928000, "loanguid": "de1f75e4-bdb5-41e5-a20a-b811ecb1923f", "encompassBorrowerId": "88856bd0-0fa2-4fa3-b8f3-04af1d336cca", "losUpdatedDate": datetime.2019, 12, 11, 9, 35, 51, 255000}

Leave a Reply

Your email address will not be published. Required fields are marked *