|
Chilkat • HOME • Android™ • Classic ASP • C • C++ • C# • Mono C# • .NET Core C# • C# UWP/WinRT • DataFlex • Delphi ActiveX • Delphi DLL • Visual FoxPro • Java • Lianja • MFC • Objective-C • Perl • PHP ActiveX • PHP Extension • PowerBuilder • PowerShell • PureBasic • CkPython • Chilkat2-Python • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • Visual Basic 6.0 • VB.NET • VB.NET UWP/WinRT • VBScript • Xojo Plugin • Node.js • Excel • Go
(Excel) Activix CRM Search for LeadsDemonstrates how to full-text search for leads, returning a JSON list of leads. For more information, see https://docs.crm.activix.ca/api/resources/lead
' This example requires the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. Dim http As Chilkat.Http Set http = Chilkat.NewHttp http.AuthToken = "ACCESS_TOKEN" http.Accept = "application/json" strResp = http.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe") If (http.LastMethodSuccess <> True) Then Debug.Print http.LastErrorText Exit Sub End If Debug.Print "Response Status Code: "; http.LastStatus Dim jsonResponse As Chilkat.JsonObject Set jsonResponse = Chilkat.NewJsonObject Dim success As Boolean success = jsonResponse.Load(strResp) jsonResponse.EmitCompact = False Debug.Print jsonResponse.Emit() If (http.LastStatus <> 200) Then Debug.Print "Failed." Exit Sub End If ' Sample output... ' (See the parsing code below..) ' ' Use this online tool to generate parsing code from sample JSON: ' Generate Parsing Code from JSON ' { ' "data": [ ' { ' "id": 3387562, ' "created_at": "2018-04-09T18:05:00+00:00", ' "updated_at": "2018-04-09T18:07:00+00:00", ' "first_name": "John", ' "last_name": "Doe", ' ... ' "account": { ' "id": 66, ' ... ' }, ' "advisor": { ' "id": 51112, ' ... ' }, ' "emails": [ ' { ' "id": 3664451, ' ... ' }, ' ... ' ], ' "phones": [ ' { ' "id": 9465546, ' ... ' }, ' ... ' ], ' "vehicles": [ ' { ' "id": 4542214, ' ... ' }, ' ... ' ] ' }, ' ... ' ], ' "links": { ' "first": "https://crm.activix.ca/api/v2/leads/search?query=John&page=1", ' "last": "https://crm.activix.ca/api/v2/leads/search?query=John&page=47", ' "prev": null, ' "next": "https://crm.activix.ca/api/v2/leads/search?query=John&page=2" ' }, ' "meta": { ' "current_page": 1, ' "from": 1, ' "last_page": 47, ' "path": "https://crm.activix.ca/api/v2/leads/search", ' "per_page": 25, ' "to": 25, ' "total": 1161 ' } ' } linksFirst = jsonResponse.StringOf("links.first") linksLast = jsonResponse.StringOf("links.last") linksPrev = jsonResponse.StringOf("links.prev") linksNext = jsonResponse.StringOf("links.next") metaCurrent_page = jsonResponse.IntOf("meta.current_page") metaFrom = jsonResponse.IntOf("meta.from") metaLast_page = jsonResponse.IntOf("meta.last_page") metaPath = jsonResponse.StringOf("meta.path") metaPer_page = jsonResponse.IntOf("meta.per_page") metaTo = jsonResponse.IntOf("meta.to") metaTotal = jsonResponse.IntOf("meta.total") i = 0 count_i = jsonResponse.SizeOfArray("data") Do While i < count_i jsonResponse.I = i id = jsonResponse.IntOf("data[i].id") created_at = jsonResponse.StringOf("data[i].created_at") updated_at = jsonResponse.StringOf("data[i].updated_at") account_id = jsonResponse.IntOf("data[i].account_id") address_line1 = jsonResponse.StringOf("data[i].address_line1") address_line2 = jsonResponse.StringOf("data[i].address_line2") appointment_date = jsonResponse.StringOf("data[i].appointment_date") appt_call = jsonResponse.BoolOf("data[i].appt_call") available_date = jsonResponse.StringOf("data[i].available_date") average_spending = jsonResponse.StringOf("data[i].average_spending") be_back_date = jsonResponse.StringOf("data[i].be_back_date") birth_date = jsonResponse.StringOf("data[i].birth_date") business = jsonResponse.StringOf("data[i].business") call_date = jsonResponse.StringOf("data[i].call_date") city = jsonResponse.StringOf("data[i].city") civility = jsonResponse.StringOf("data[i].civility") code = jsonResponse.StringOf("data[i].code") country = jsonResponse.StringOf("data[i].country") csi_date = jsonResponse.StringOf("data[i].csi_date") delivered_by_id = jsonResponse.StringOf("data[i].delivered_by_id") delivered_date = jsonResponse.StringOf("data[i].delivered_date") delivery_date = jsonResponse.StringOf("data[i].delivery_date") division = jsonResponse.StringOf("data[i].division") end_service_date = jsonResponse.StringOf("data[i].end_service_date") first_name = jsonResponse.StringOf("data[i].first_name") gas = jsonResponse.StringOf("data[i].gas") gender = jsonResponse.IntOf("data[i].gender") invoiced = jsonResponse.BoolOf("data[i].invoiced") last_name = jsonResponse.StringOf("data[i].last_name") last_visit_date = jsonResponse.StringOf("data[i].last_visit_date") locale = jsonResponse.StringOf("data[i].locale") loyalty = jsonResponse.StringOf("data[i].loyalty") next_visit_date = jsonResponse.StringOf("data[i].next_visit_date") odometer_last_visit = jsonResponse.StringOf("data[i].odometer_last_visit") open_work_order_date = jsonResponse.StringOf("data[i].open_work_order_date") planned_pick_up_date = jsonResponse.StringOf("data[i].planned_pick_up_date") postal_code = jsonResponse.StringOf("data[i].postal_code") prepaid = jsonResponse.StringOf("data[i].prepaid") prepared = jsonResponse.BoolOf("data[i].prepared") presented_date = jsonResponse.StringOf("data[i].presented_date") promised_date = jsonResponse.StringOf("data[i].promised_date") province = jsonResponse.StringOf("data[i].province") rating = jsonResponse.StringOf("data[i].rating") reached_client = jsonResponse.BoolOf("data[i].reached_client") refinanced_date = jsonResponse.StringOf("data[i].refinanced_date") repair_date = jsonResponse.StringOf("data[i].repair_date") repair_order = jsonResponse.StringOf("data[i].repair_order") result = jsonResponse.StringOf("data[i].result") road_test_date = jsonResponse.StringOf("data[i].road_test_date") sale_date = jsonResponse.StringOf("data[i].sale_date") second_contact = jsonResponse.StringOf("data[i].second_contact") second_contact_civility = jsonResponse.StringOf("data[i].second_contact_civility") segment = jsonResponse.StringOf("data[i].segment") service_cleaned = jsonResponse.BoolOf("data[i].service_cleaned") service_interval_km = jsonResponse.StringOf("data[i].service_interval_km") service_monthly_km = jsonResponse.StringOf("data[i].service_monthly_km") service_processIntention = jsonResponse.StringOf("data[i].service_process.intention") service_processTransport = jsonResponse.StringOf("data[i].service_process.transport") service_processWalk_around = jsonResponse.StringOf("data[i].service_process.walk_around") sex = jsonResponse.StringOf("data[i].sex") source = jsonResponse.StringOf("data[i].source") status = jsonResponse.StringOf("data[i].status") storage = jsonResponse.StringOf("data[i].storage") take_over_date = jsonResponse.StringOf("data[i].take_over_date") v_type = jsonResponse.StringOf("data[i].type") unsubscribe_all_date = jsonResponse.StringOf("data[i].unsubscribe_all_date") unsubscribe_call_date = jsonResponse.StringOf("data[i].unsubscribe_call_date") unsubscribe_email_date = jsonResponse.StringOf("data[i].unsubscribe_email_date") unsubscribe_sms_date = jsonResponse.StringOf("data[i].unsubscribe_sms_date") work_order = jsonResponse.StringOf("data[i].work_order") accountId = jsonResponse.IntOf("data[i].account.id") accountCreated_at = jsonResponse.StringOf("data[i].account.created_at") accountUpdated_at = jsonResponse.StringOf("data[i].account.updated_at") accountPartner_id = jsonResponse.IntOf("data[i].account.partner_id") accountActivity_report = jsonResponse.BoolOf("data[i].account.activity_report") accountCommercial = jsonResponse.BoolOf("data[i].account.commercial") accountEvent = jsonResponse.BoolOf("data[i].account.event") accountLeadxpress = jsonResponse.BoolOf("data[i].account.leadxpress") accountLoyalty = jsonResponse.BoolOf("data[i].account.loyalty") accountPhone_up = jsonResponse.BoolOf("data[i].account.phone_up") accountRenewal = jsonResponse.BoolOf("data[i].account.renewal") accountSale_table = jsonResponse.BoolOf("data[i].account.sale_table") accountService = jsonResponse.BoolOf("data[i].account.service") accountWalk_in = jsonResponse.BoolOf("data[i].account.walk_in") accountWebboost = jsonResponse.BoolOf("data[i].account.webboost") accountAccount_manager = jsonResponse.BoolOf("data[i].account.account_manager") accountActivation_date = jsonResponse.StringOf("data[i].account.activation_date") accountActive = jsonResponse.BoolOf("data[i].account.active") accountAssigned_lead = jsonResponse.BoolOf("data[i].account.assigned_lead") accountAuto_renewal = jsonResponse.BoolOf("data[i].account.auto_renewal") accountAuto_renewal_new = jsonResponse.BoolOf("data[i].account.auto_renewal_new") accountAuto_renewal_used = jsonResponse.BoolOf("data[i].account.auto_renewal_used") accountAutomation = jsonResponse.BoolOf("data[i].account.automation") accountBdc_advisor = jsonResponse.BoolOf("data[i].account.bdc_advisor") accountCalendar_options = jsonResponse.BoolOf("data[i].account.calendar_options") accountClient_card_fieldsProcessGas = jsonResponse.BoolOf("data[i].account.client_card_fields.process.gas") accountClient_card_fieldsProcessRecorded = jsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded") accountClient_card_fieldsProcessAvailable = jsonResponse.BoolOf("data[i].account.client_card_fields.process.available") accountClient_card_fieldsProcessDiscounted = jsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted") accountClient_card_fieldsCommercialProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit") accountClient_card_fieldsCommercialExclude = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude") accountClient_card_fieldsCommercialMeeting = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting") accountClient_card_fieldsPerformanceDeposit = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit") accountClient_card_fieldsPerformanceRefinanced = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced") accountClient_card_fieldsPerformanceDealer_tour = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour") accountClient_card_fieldsPerformanceWalk_around = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around") accountClient_card_fieldsPerformanceQualification = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification") accountClient_card_fieldsPerformanceTwenty_four_hour = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour") accountClient_card_fieldsGeneral_infoBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget") accountClient_card_fieldsGeneral_infoSector = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector") accountClient_card_fieldsGeneral_infoCustom_1 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1") accountClient_card_fieldsGeneral_infoCustom_2 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2") accountClient_card_fieldsGeneral_infoCustom_3 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3") accountClient_card_fieldsGeneral_infoCustom_4 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4") accountClient_card_fieldsGeneral_infoCustom_5 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5") accountClient_card_fieldsGeneral_infoCustom_6 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6") accountClient_card_fieldsGeneral_infoCustom_7 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7") accountClient_card_fieldsGeneral_infoCustom_8 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8") accountClient_card_fieldsGeneral_infoCustom_9 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9") accountClient_card_fieldsGeneral_infoCustom_10 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10") accountClient_card_fieldsGeneral_infoCommunication_preference = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference") accountClient_card_fieldsWanted_vehicleVin = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin") accountClient_card_fieldsWanted_vehicleFuel = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel") accountClient_card_fieldsWanted_vehicleRate = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate") accountClient_card_fieldsWanted_vehicleTerm = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term") accountClient_card_fieldsWanted_vehicleTire = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire") accountClient_card_fieldsWanted_vehicleYear = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year") accountClient_card_fieldsWanted_vehicleColor = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color") accountClient_card_fieldsWanted_vehiclePrice = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price") accountClient_card_fieldsWanted_vehicleStock = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock") accountClient_card_fieldsWanted_vehicleTotal = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total") accountClient_card_fieldsWanted_vehicleBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget") accountClient_card_fieldsWanted_vehicleEngine = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine") accountClient_card_fieldsWanted_vehicleLength = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length") accountClient_card_fieldsWanted_vehicleProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit") accountClient_card_fieldsWanted_vehicleSuffix = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix") accountClient_card_fieldsWanted_vehicleWeight = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight") accountClient_card_fieldsWanted_vehicleComment = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment") accountClient_card_fieldsWanted_vehicleMileage = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage") accountClient_card_fieldsWanted_vehiclePayment = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment") accountClient_card_fieldsWanted_vehicleBodyType = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType") accountClient_card_fieldsWanted_vehicleCategory = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category") accountClient_card_fieldsWanted_vehicleModality = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality") accountClient_card_fieldsWanted_vehicleResidual = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual") accountClient_card_fieldsWanted_vehicleSleeping = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping") accountClient_card_fieldsWanted_vehicleWarranty = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty") accountClient_card_fieldsWanted_vehicleFrequency = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency") accountClient_card_fieldsWanted_vehicleAccessories = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories") accountClient_card_fieldsWanted_vehicleCategory_rv = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv") accountClient_card_fieldsWanted_vehiclePreparation = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation") accountClient_card_fieldsWanted_vehicleInitial_cash = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash") accountClient_card_fieldsWanted_vehicleOffer_number = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number") accountClient_card_fieldsWanted_vehicleOrder_number = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number") accountClient_card_fieldsWanted_vehicleTransmission = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission") accountClient_card_fieldsWanted_vehicleDocumentation = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation") accountClient_card_fieldsWanted_vehicleDrivingWheels = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels") accountClient_card_fieldsWanted_vehicleColor_exterior = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior") accountClient_card_fieldsWanted_vehicleColor_interior = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior") accountClient_card_fieldsWanted_vehicleAllowed_mileage = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage") accountClient_card_fieldsWanted_vehicleSecurity_deposit = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit") accountClient_card_fieldsWanted_vehicleEnd_contract_date = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date") accountClient_card_fieldsExchange_vehicleVin = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin") accountClient_card_fieldsExchange_vehicleFuel = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel") accountClient_card_fieldsExchange_vehicleLink = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link") accountClient_card_fieldsExchange_vehicleRate = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate") accountClient_card_fieldsExchange_vehicleTerm = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term") accountClient_card_fieldsExchange_vehicleYear = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year") accountClient_card_fieldsExchange_vehicleColor = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color") accountClient_card_fieldsExchange_vehiclePrice = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price") accountClient_card_fieldsExchange_vehicleStock = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock") accountClient_card_fieldsExchange_vehicleValue = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value") accountClient_card_fieldsExchange_vehicleBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget") accountClient_card_fieldsExchange_vehicleEngine = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine") accountClient_card_fieldsExchange_vehicleLength = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length") accountClient_card_fieldsExchange_vehicleProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit") accountClient_card_fieldsExchange_vehicleSuffix = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix") accountClient_card_fieldsExchange_vehicleWeight = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight") accountClient_card_fieldsExchange_vehicleBalance = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance") accountClient_card_fieldsExchange_vehicleComment = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment") accountClient_card_fieldsExchange_vehicleMileage = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage") accountClient_card_fieldsExchange_vehiclePayment = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment") accountClient_card_fieldsExchange_vehicleRenewal = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal") accountClient_card_fieldsExchange_vehicleSold_by = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by") accountClient_card_fieldsExchange_vehicleBodyType = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType") accountClient_card_fieldsExchange_vehicleCategory = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category") accountClient_card_fieldsExchange_vehicleModality = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality") accountClient_card_fieldsExchange_vehicleResidual = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual") accountClient_card_fieldsExchange_vehicleSleeping = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping") accountClient_card_fieldsExchange_vehicleWarranty = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty") accountClient_card_fieldsExchange_vehicleCondition = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition") accountClient_card_fieldsExchange_vehicleFrequency = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency") accountClient_card_fieldsExchange_vehicleIntention = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention") accountClient_card_fieldsExchange_vehicleRefinance = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance") accountClient_card_fieldsExchange_vehicleRequested = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested") accountClient_card_fieldsExchange_vehicleSold_date = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date") accountClient_card_fieldsExchange_vehicleCategory_rv = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv") accountClient_card_fieldsExchange_vehicleInstitution = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution") accountClient_card_fieldsExchange_vehicleInitial_cash = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash") accountClient_card_fieldsExchange_vehicleOffer_number = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number") accountClient_card_fieldsExchange_vehicleTransmission = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission") accountClient_card_fieldsExchange_vehicleDrivingWheels = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels") accountClient_card_fieldsExchange_vehicleColor_exterior = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior") accountClient_card_fieldsExchange_vehicleColor_interior = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior") accountClient_card_fieldsExchange_vehicleAllowed_mileage = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage") accountClient_card_fieldsExchange_vehicleSecurity_deposit = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit") accountClient_card_fieldsExchange_vehicleEnd_contract_date = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date") accountClient_number = jsonResponse.BoolOf("data[i].account.client_number") accountConfirmation_appt = jsonResponse.BoolOf("data[i].account.confirmation_appt") accountCredit = jsonResponse.BoolOf("data[i].account.credit") accountCsi = jsonResponse.BoolOf("data[i].account.csi") accountCsi_used = jsonResponse.BoolOf("data[i].account.csi_used") accountDefault_deliveryman_user_id = jsonResponse.StringOf("data[i].account.default_deliveryman_user_id") accountDelivered_by = jsonResponse.BoolOf("data[i].account.delivered_by") accountDisable_communication_audio = jsonResponse.BoolOf("data[i].account.disable_communication_audio") accountDuplicates = jsonResponse.BoolOf("data[i].account.duplicates") accountGuest_action = jsonResponse.BoolOf("data[i].account.guest_action") accountEmail_client = jsonResponse.BoolOf("data[i].account.email_client") accountIn_turn = jsonResponse.BoolOf("data[i].account.in_turn") accountIn_turn_director_management = jsonResponse.BoolOf("data[i].account.in_turn_director_management") accountLeads_other_division = jsonResponse.BoolOf("data[i].account.leads_other_division") accountLeadxpress_optionPriority = jsonResponse.IntOf("data[i].account.leadxpress_option.priority") accountLeadxpress_optionReminderFrequency = jsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency") accountLeadxpress_optionReminderRecurrence = jsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence") accountLeadxpress_optionScheduleAccount = jsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account") accountLeadxpress_optionScheduleAdvisor = jsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor") accountLimited_audio_access = jsonResponse.BoolOf("data[i].account.limited_audio_access") accountLogo = jsonResponse.StringOf("data[i].account.logo") accountLogo_en = jsonResponse.StringOf("data[i].account.logo_en") accountMandatory_coordinate = jsonResponse.BoolOf("data[i].account.mandatory_coordinate") accountManually_status = jsonResponse.BoolOf("data[i].account.manually_status") accountMerge_rule = jsonResponse.StringOf("data[i].account.merge_rule") accountMonth_start_day = jsonResponse.IntOf("data[i].account.month_start_day") accountName = jsonResponse.StringOf("data[i].account.name") accountNiotext = jsonResponse.BoolOf("data[i].account.niotext") accountNiotext_phone = jsonResponse.BoolOf("data[i].account.niotext_phone") accountPhone = jsonResponse.StringOf("data[i].account.phone") accountPower_sport = jsonResponse.BoolOf("data[i].account.power_sport") accountProcess = jsonResponse.BoolOf("data[i].account.process") accountRecreative_special = jsonResponse.BoolOf("data[i].account.recreative_special") accountResult_date_validation = jsonResponse.BoolOf("data[i].account.result_date_validation") accountSale_accessories = jsonResponse.BoolOf("data[i].account.sale_accessories") accountSale_by_phone = jsonResponse.BoolOf("data[i].account.sale_by_phone") accountSale_date_month = jsonResponse.BoolOf("data[i].account.sale_date_month") accountSale_table_optionsAccessory_column = jsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column") accountSale_table_optionsCommercial_column = jsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column") accountSale_table_optionsDivision_grouped_total_column = jsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column") accountSale_validation = jsonResponse.BoolOf("data[i].account.sale_validation") accountScan = jsonResponse.BoolOf("data[i].account.scan") accountStock_required_for_sale = jsonResponse.BoolOf("data[i].account.stock_required_for_sale") accountTake_over_director = jsonResponse.BoolOf("data[i].account.take_over_director") accountTrade_report = jsonResponse.BoolOf("data[i].account.trade_report") accountUnrestricted_assignment = jsonResponse.BoolOf("data[i].account.unrestricted_assignment") accountUnsubscribe = jsonResponse.BoolOf("data[i].account.unsubscribe") accountUntreated_lead = jsonResponse.BoolOf("data[i].account.untreated_lead") accountVehicle_model_text = jsonResponse.BoolOf("data[i].account.vehicle_model_text") accountVehicle_text = jsonResponse.BoolOf("data[i].account.vehicle_text") accountVerified_sale = jsonResponse.BoolOf("data[i].account.verified_sale") accountVin_decoder = jsonResponse.BoolOf("data[i].account.vin_decoder") accountWaiting_sale_date = jsonResponse.StringOf("data[i].account.waiting_sale_date") accountWaiting_sale_option = jsonResponse.BoolOf("data[i].account.waiting_sale_option") advisor = jsonResponse.StringOf("data[i].advisor") j = 0 count_j = jsonResponse.SizeOfArray("data[i].emails") Do While j < count_j jsonResponse.J = j id = jsonResponse.IntOf("data[i].emails[j].id") created_at = jsonResponse.StringOf("data[i].emails[j].created_at") updated_at = jsonResponse.StringOf("data[i].emails[j].updated_at") lead_id = jsonResponse.IntOf("data[i].emails[j].lead_id") address = jsonResponse.StringOf("data[i].emails[j].address") v_type = jsonResponse.StringOf("data[i].emails[j].type") valid = jsonResponse.BoolOf("data[i].emails[j].valid") j = j + 1 Loop j = 0 count_j = jsonResponse.SizeOfArray("data[i].phones") Do While j < count_j jsonResponse.J = j id = jsonResponse.IntOf("data[i].phones[j].id") created_at = jsonResponse.StringOf("data[i].phones[j].created_at") updated_at = jsonResponse.StringOf("data[i].phones[j].updated_at") lead_id = jsonResponse.IntOf("data[i].phones[j].lead_id") extension = jsonResponse.StringOf("data[i].phones[j].extension") number = jsonResponse.StringOf("data[i].phones[j].number") v_type = jsonResponse.StringOf("data[i].phones[j].type") valid = jsonResponse.BoolOf("data[i].phones[j].valid") validated = jsonResponse.BoolOf("data[i].phones[j].validated") mobile = jsonResponse.BoolOf("data[i].phones[j].mobile") j = j + 1 Loop j = 0 count_j = jsonResponse.SizeOfArray("data[i].vehicles") Do While j < count_j jsonResponse.J = j id = jsonResponse.IntOf("data[i].vehicles[j].id") created_at = jsonResponse.StringOf("data[i].vehicles[j].created_at") updated_at = jsonResponse.StringOf("data[i].vehicles[j].updated_at") lead_id = jsonResponse.IntOf("data[i].vehicles[j].lead_id") accessories = jsonResponse.StringOf("data[i].vehicles[j].accessories") allowed_odometer = jsonResponse.StringOf("data[i].vehicles[j].allowed_odometer") balance = jsonResponse.IntOf("data[i].vehicles[j].balance") budget_max = jsonResponse.StringOf("data[i].vehicles[j].budget_max") budget_min = jsonResponse.StringOf("data[i].vehicles[j].budget_min") cash_down = jsonResponse.StringOf("data[i].vehicles[j].cash_down") category = jsonResponse.StringOf("data[i].vehicles[j].category") category_rv = jsonResponse.StringOf("data[i].vehicles[j].category_rv") client_number = jsonResponse.StringOf("data[i].vehicles[j].client_number") color_exterior = jsonResponse.StringOf("data[i].vehicles[j].color_exterior") color_interior = jsonResponse.StringOf("data[i].vehicles[j].color_interior") comment = jsonResponse.StringOf("data[i].vehicles[j].comment") condition = jsonResponse.StringOf("data[i].vehicles[j].condition") end_contract_date = jsonResponse.StringOf("data[i].vehicles[j].end_contract_date") end_warranty_date = jsonResponse.StringOf("data[i].vehicles[j].end_warranty_date") engine = jsonResponse.StringOf("data[i].vehicles[j].engine") extended_warranty = jsonResponse.StringOf("data[i].vehicles[j].extended_warranty") fuel = jsonResponse.StringOf("data[i].vehicles[j].fuel") length_max = jsonResponse.StringOf("data[i].vehicles[j].length_max") length_min = jsonResponse.StringOf("data[i].vehicles[j].length_min") license_plate = jsonResponse.StringOf("data[i].vehicles[j].license_plate") make = jsonResponse.StringOf("data[i].vehicles[j].make") modality = jsonResponse.StringOf("data[i].vehicles[j].modality") model = jsonResponse.StringOf("data[i].vehicles[j].model") odometer = jsonResponse.StringOf("data[i].vehicles[j].odometer") offer_number = jsonResponse.StringOf("data[i].vehicles[j].offer_number") v_option = jsonResponse.StringOf("data[i].vehicles[j].option") order_number = jsonResponse.StringOf("data[i].vehicles[j].order_number") payment = jsonResponse.StringOf("data[i].vehicles[j].payment") payment_frequency = jsonResponse.StringOf("data[i].vehicles[j].payment_frequency") preparation = jsonResponse.StringOf("data[i].vehicles[j].preparation") price = jsonResponse.StringOf("data[i].vehicles[j].price") profit = jsonResponse.StringOf("data[i].vehicles[j].profit") purchase_date = jsonResponse.StringOf("data[i].vehicles[j].purchase_date") rate = jsonResponse.StringOf("data[i].vehicles[j].rate") recall = jsonResponse.StringOf("data[i].vehicles[j].recall") recorded_date = jsonResponse.StringOf("data[i].vehicles[j].recorded_date") residual = jsonResponse.StringOf("data[i].vehicles[j].residual") security_deposit = jsonResponse.StringOf("data[i].vehicles[j].security_deposit") sleeping = jsonResponse.StringOf("data[i].vehicles[j].sleeping") sold = jsonResponse.BoolOf("data[i].vehicles[j].sold") sold_by = jsonResponse.StringOf("data[i].vehicles[j].sold_by") sold_date = jsonResponse.StringOf("data[i].vehicles[j].sold_date") stock = jsonResponse.StringOf("data[i].vehicles[j].stock") stock_state = jsonResponse.StringOf("data[i].vehicles[j].stock_state") term = jsonResponse.StringOf("data[i].vehicles[j].term") tire = jsonResponse.BoolOf("data[i].vehicles[j].tire") transmission = jsonResponse.StringOf("data[i].vehicles[j].transmission") trim = jsonResponse.StringOf("data[i].vehicles[j].trim") v_type = jsonResponse.StringOf("data[i].vehicles[j].type") url = jsonResponse.StringOf("data[i].vehicles[j].url") value = jsonResponse.StringOf("data[i].vehicles[j].value") vin = jsonResponse.StringOf("data[i].vehicles[j].vin") warranty = jsonResponse.StringOf("data[i].vehicles[j].warranty") weight = jsonResponse.StringOf("data[i].vehicles[j].weight") year = jsonResponse.StringOf("data[i].vehicles[j].year") year_max = jsonResponse.StringOf("data[i].vehicles[j].year_max") year_min = jsonResponse.StringOf("data[i].vehicles[j].year_min") j = j + 1 Loop j = 0 count_j = jsonResponse.SizeOfArray("data[i].products") Do While j < count_j jsonResponse.J = j j = j + 1 Loop i = i + 1 Loop |
||||
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.