Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Visual FoxPro) 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
LOCAL loHttp LOCAL lcStrResp LOCAL loJsonResponse LOCAL lcLinksFirst LOCAL lcLinksLast LOCAL lcLinksPrev LOCAL lcLinksNext LOCAL lnMetaCurrent_page LOCAL lnMetaFrom LOCAL lnMetaLast_page LOCAL lcMetaPath LOCAL lnMetaPer_page LOCAL lnMetaTo LOCAL lnMetaTotal LOCAL i LOCAL lnCount_i LOCAL lnId LOCAL lcCreated_at LOCAL lcUpdated_at LOCAL lnAccount_id LOCAL lcAddress_line1 LOCAL lcAddress_line2 LOCAL lcAppointment_date LOCAL lnAppt_call LOCAL lcAvailable_date LOCAL lcAverage_spending LOCAL lcBe_back_date LOCAL lcBirth_date LOCAL lcBusiness LOCAL lcCall_date LOCAL lcCity LOCAL lcCivility LOCAL lcCode LOCAL lcCountry LOCAL lcCsi_date LOCAL lcDelivered_by_id LOCAL lcDelivered_date LOCAL lcDelivery_date LOCAL lcDivision LOCAL lcEnd_service_date LOCAL lcFirst_name LOCAL lcGas LOCAL lnGender LOCAL lnInvoiced LOCAL lcLast_name LOCAL lcLast_visit_date LOCAL lcLocale LOCAL lcLoyalty LOCAL lcNext_visit_date LOCAL lcOdometer_last_visit LOCAL lcOpen_work_order_date LOCAL lcPlanned_pick_up_date LOCAL lcPostal_code LOCAL lcPrepaid LOCAL lnPrepared LOCAL lcPresented_date LOCAL lcPromised_date LOCAL lcProvince LOCAL lcRating LOCAL lnReached_client LOCAL lcRefinanced_date LOCAL lcRepair_date LOCAL lcRepair_order LOCAL lcResult LOCAL lcRoad_test_date LOCAL lcSale_date LOCAL lcSecond_contact LOCAL lcSecond_contact_civility LOCAL lcSegment LOCAL lnService_cleaned LOCAL lcService_interval_km LOCAL lcService_monthly_km LOCAL lcService_processIntention LOCAL lcService_processTransport LOCAL lcService_processWalk_around LOCAL lcSex LOCAL lcSource LOCAL lcStatus LOCAL lcStorage LOCAL lcTake_over_date LOCAL lcV_type LOCAL lcUnsubscribe_all_date LOCAL lcUnsubscribe_call_date LOCAL lcUnsubscribe_email_date LOCAL lcUnsubscribe_sms_date LOCAL lcWork_order LOCAL lnAccountId LOCAL lcAccountCreated_at LOCAL lcAccountUpdated_at LOCAL lnAccountPartner_id LOCAL lnAccountActivity_report LOCAL lnAccountCommercial LOCAL lnAccountEvent LOCAL lnAccountLeadxpress LOCAL lnAccountLoyalty LOCAL lnAccountPhone_up LOCAL lnAccountRenewal LOCAL lnAccountSale_table LOCAL lnAccountService LOCAL lnAccountWalk_in LOCAL lnAccountWebboost LOCAL lnAccountAccount_manager LOCAL lcAccountActivation_date LOCAL lnAccountActive LOCAL lnAccountAssigned_lead LOCAL lnAccountAuto_renewal LOCAL lnAccountAuto_renewal_new LOCAL lnAccountAuto_renewal_used LOCAL lnAccountAutomation LOCAL lnAccountBdc_advisor LOCAL lnAccountCalendar_options LOCAL lnAccountClient_card_fieldsProcessGas LOCAL lnAccountClient_card_fieldsProcessRecorded LOCAL lnAccountClient_card_fieldsProcessAvailable LOCAL lnAccountClient_card_fieldsProcessDiscounted LOCAL lnAccountClient_card_fieldsCommercialProfit LOCAL lnAccountClient_card_fieldsCommercialExclude LOCAL lnAccountClient_card_fieldsCommercialMeeting LOCAL lnAccountClient_card_fieldsPerformanceDeposit LOCAL lnAccountClient_card_fieldsPerformanceRefinanced LOCAL lnAccountClient_card_fieldsPerformanceDealer_tour LOCAL lnAccountClient_card_fieldsPerformanceWalk_around LOCAL lnAccountClient_card_fieldsPerformanceQualification LOCAL lnAccountClient_card_fieldsPerformanceTwenty_four_hour LOCAL lnAccountClient_card_fieldsGeneral_infoBudget LOCAL lnAccountClient_card_fieldsGeneral_infoSector LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_1 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_2 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_3 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_4 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_5 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_6 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_7 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_8 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_9 LOCAL lnAccountClient_card_fieldsGeneral_infoCustom_10 LOCAL lnAccountClient_card_fieldsGeneral_infoCommunication_preference LOCAL lnAccountClient_card_fieldsWanted_vehicleVin LOCAL lnAccountClient_card_fieldsWanted_vehicleFuel LOCAL lnAccountClient_card_fieldsWanted_vehicleRate LOCAL lnAccountClient_card_fieldsWanted_vehicleTerm LOCAL lnAccountClient_card_fieldsWanted_vehicleTire LOCAL lnAccountClient_card_fieldsWanted_vehicleYear LOCAL lnAccountClient_card_fieldsWanted_vehicleColor LOCAL lnAccountClient_card_fieldsWanted_vehiclePrice LOCAL lnAccountClient_card_fieldsWanted_vehicleStock LOCAL lnAccountClient_card_fieldsWanted_vehicleTotal LOCAL lnAccountClient_card_fieldsWanted_vehicleBudget LOCAL lnAccountClient_card_fieldsWanted_vehicleEngine LOCAL lnAccountClient_card_fieldsWanted_vehicleLength LOCAL lnAccountClient_card_fieldsWanted_vehicleProfit LOCAL lnAccountClient_card_fieldsWanted_vehicleSuffix LOCAL lnAccountClient_card_fieldsWanted_vehicleWeight LOCAL lnAccountClient_card_fieldsWanted_vehicleComment LOCAL lnAccountClient_card_fieldsWanted_vehicleMileage LOCAL lnAccountClient_card_fieldsWanted_vehiclePayment LOCAL lnAccountClient_card_fieldsWanted_vehicleBodyType LOCAL lnAccountClient_card_fieldsWanted_vehicleCategory LOCAL lnAccountClient_card_fieldsWanted_vehicleModality LOCAL lnAccountClient_card_fieldsWanted_vehicleResidual LOCAL lnAccountClient_card_fieldsWanted_vehicleSleeping LOCAL lnAccountClient_card_fieldsWanted_vehicleWarranty LOCAL lnAccountClient_card_fieldsWanted_vehicleFrequency LOCAL lnAccountClient_card_fieldsWanted_vehicleAccessories LOCAL lnAccountClient_card_fieldsWanted_vehicleCategory_rv LOCAL lnAccountClient_card_fieldsWanted_vehiclePreparation LOCAL lnAccountClient_card_fieldsWanted_vehicleInitial_cash LOCAL lnAccountClient_card_fieldsWanted_vehicleOffer_number LOCAL lnAccountClient_card_fieldsWanted_vehicleOrder_number LOCAL lnAccountClient_card_fieldsWanted_vehicleTransmission LOCAL lnAccountClient_card_fieldsWanted_vehicleDocumentation LOCAL lnAccountClient_card_fieldsWanted_vehicleDrivingWheels LOCAL lnAccountClient_card_fieldsWanted_vehicleColor_exterior LOCAL lnAccountClient_card_fieldsWanted_vehicleColor_interior LOCAL lnAccountClient_card_fieldsWanted_vehicleAllowed_mileage LOCAL lnAccountClient_card_fieldsWanted_vehicleSecurity_deposit LOCAL lnAccountClient_card_fieldsWanted_vehicleEnd_contract_date LOCAL lnAccountClient_card_fieldsExchange_vehicleVin LOCAL lnAccountClient_card_fieldsExchange_vehicleFuel LOCAL lnAccountClient_card_fieldsExchange_vehicleLink LOCAL lnAccountClient_card_fieldsExchange_vehicleRate LOCAL lnAccountClient_card_fieldsExchange_vehicleTerm LOCAL lnAccountClient_card_fieldsExchange_vehicleYear LOCAL lnAccountClient_card_fieldsExchange_vehicleColor LOCAL lnAccountClient_card_fieldsExchange_vehiclePrice LOCAL lnAccountClient_card_fieldsExchange_vehicleStock LOCAL lnAccountClient_card_fieldsExchange_vehicleValue LOCAL lnAccountClient_card_fieldsExchange_vehicleBudget LOCAL lnAccountClient_card_fieldsExchange_vehicleEngine LOCAL lnAccountClient_card_fieldsExchange_vehicleLength LOCAL lnAccountClient_card_fieldsExchange_vehicleProfit LOCAL lnAccountClient_card_fieldsExchange_vehicleSuffix LOCAL lnAccountClient_card_fieldsExchange_vehicleWeight LOCAL lnAccountClient_card_fieldsExchange_vehicleBalance LOCAL lnAccountClient_card_fieldsExchange_vehicleComment LOCAL lnAccountClient_card_fieldsExchange_vehicleMileage LOCAL lnAccountClient_card_fieldsExchange_vehiclePayment LOCAL lnAccountClient_card_fieldsExchange_vehicleRenewal LOCAL lnAccountClient_card_fieldsExchange_vehicleSold_by LOCAL lnAccountClient_card_fieldsExchange_vehicleBodyType LOCAL lnAccountClient_card_fieldsExchange_vehicleCategory LOCAL lnAccountClient_card_fieldsExchange_vehicleModality LOCAL lnAccountClient_card_fieldsExchange_vehicleResidual LOCAL lnAccountClient_card_fieldsExchange_vehicleSleeping LOCAL lnAccountClient_card_fieldsExchange_vehicleWarranty LOCAL lnAccountClient_card_fieldsExchange_vehicleCondition LOCAL lnAccountClient_card_fieldsExchange_vehicleFrequency LOCAL lnAccountClient_card_fieldsExchange_vehicleIntention LOCAL lnAccountClient_card_fieldsExchange_vehicleRefinance LOCAL lnAccountClient_card_fieldsExchange_vehicleRequested LOCAL lnAccountClient_card_fieldsExchange_vehicleSold_date LOCAL lnAccountClient_card_fieldsExchange_vehicleCategory_rv LOCAL lnAccountClient_card_fieldsExchange_vehicleInstitution LOCAL lnAccountClient_card_fieldsExchange_vehicleInitial_cash LOCAL lnAccountClient_card_fieldsExchange_vehicleOffer_number LOCAL lnAccountClient_card_fieldsExchange_vehicleTransmission LOCAL lnAccountClient_card_fieldsExchange_vehicleDrivingWheels LOCAL lnAccountClient_card_fieldsExchange_vehicleColor_exterior LOCAL lnAccountClient_card_fieldsExchange_vehicleColor_interior LOCAL lnAccountClient_card_fieldsExchange_vehicleAllowed_mileage LOCAL lnAccountClient_card_fieldsExchange_vehicleSecurity_deposit LOCAL lnAccountClient_card_fieldsExchange_vehicleEnd_contract_date LOCAL lnAccountClient_number LOCAL lnAccountConfirmation_appt LOCAL lnAccountCredit LOCAL lnAccountCsi LOCAL lnAccountCsi_used LOCAL lcAccountDefault_deliveryman_user_id LOCAL lnAccountDelivered_by LOCAL lnAccountDisable_communication_audio LOCAL lnAccountDuplicates LOCAL lnAccountGuest_action LOCAL lnAccountEmail_client LOCAL lnAccountIn_turn LOCAL lnAccountIn_turn_director_management LOCAL lnAccountLeads_other_division LOCAL lnAccountLeadxpress_optionPriority LOCAL lnAccountLeadxpress_optionReminderFrequency LOCAL lnAccountLeadxpress_optionReminderRecurrence LOCAL lnAccountLeadxpress_optionScheduleAccount LOCAL lnAccountLeadxpress_optionScheduleAdvisor LOCAL lnAccountLimited_audio_access LOCAL lcAccountLogo LOCAL lcAccountLogo_en LOCAL lnAccountMandatory_coordinate LOCAL lnAccountManually_status LOCAL lcAccountMerge_rule LOCAL lnAccountMonth_start_day LOCAL lcAccountName LOCAL lnAccountNiotext LOCAL lnAccountNiotext_phone LOCAL lcAccountPhone LOCAL lnAccountPower_sport LOCAL lnAccountProcess LOCAL lnAccountRecreative_special LOCAL lnAccountResult_date_validation LOCAL lnAccountSale_accessories LOCAL lnAccountSale_by_phone LOCAL lnAccountSale_date_month LOCAL lnAccountSale_table_optionsAccessory_column LOCAL lnAccountSale_table_optionsCommercial_column LOCAL lnAccountSale_table_optionsDivision_grouped_total_column LOCAL lnAccountSale_validation LOCAL lnAccountScan LOCAL lnAccountStock_required_for_sale LOCAL lnAccountTake_over_director LOCAL lnAccountTrade_report LOCAL lnAccountUnrestricted_assignment LOCAL lnAccountUnsubscribe LOCAL lnAccountUntreated_lead LOCAL lnAccountVehicle_model_text LOCAL lnAccountVehicle_text LOCAL lnAccountVerified_sale LOCAL lnAccountVin_decoder LOCAL lcAccountWaiting_sale_date LOCAL lnAccountWaiting_sale_option LOCAL lcAdvisor LOCAL j LOCAL lnCount_j LOCAL lnLead_id LOCAL lcAddress LOCAL lnValid LOCAL lcExtension LOCAL lcNumber LOCAL lnValidated LOCAL lnMobile LOCAL lcAccessories LOCAL lcAllowed_odometer LOCAL lnBalance LOCAL lcBudget_max LOCAL lcBudget_min LOCAL lcCash_down LOCAL lcCategory LOCAL lcCategory_rv LOCAL lcClient_number LOCAL lcColor_exterior LOCAL lcColor_interior LOCAL lcComment LOCAL lcCondition LOCAL lcEnd_contract_date LOCAL lcEnd_warranty_date LOCAL lcEngine LOCAL lcExtended_warranty LOCAL lcFuel LOCAL lcLength_max LOCAL lcLength_min LOCAL lcLicense_plate LOCAL lcMake LOCAL lcModality LOCAL lcModel LOCAL lcOdometer LOCAL lcOffer_number LOCAL lcV_option LOCAL lcOrder_number LOCAL lcPayment LOCAL lcPayment_frequency LOCAL lcPreparation LOCAL lcPrice LOCAL lcProfit LOCAL lcPurchase_date LOCAL lcRate LOCAL lcRecall LOCAL lcRecorded_date LOCAL lcResidual LOCAL lcSecurity_deposit LOCAL lcSleeping LOCAL lnSold LOCAL lcSold_by LOCAL lcSold_date LOCAL lcStock LOCAL lcStock_state LOCAL lcTerm LOCAL lnTire LOCAL lcTransmission LOCAL lcTrim LOCAL lcUrl LOCAL lcValue LOCAL lcVin LOCAL lcWarranty LOCAL lcWeight LOCAL lcYear LOCAL lcYear_max LOCAL lcYear_min * This example requires the Chilkat API to have been previously unlocked. * See Global Unlock Sample for sample code. * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http') loHttp = CreateObject('Chilkat.Http') loHttp.AuthToken = "ACCESS_TOKEN" loHttp.Accept = "application/json" lcStrResp = loHttp.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe") IF (loHttp.LastMethodSuccess <> 1) THEN ? loHttp.LastErrorText RELEASE loHttp CANCEL ENDIF ? "Response Status Code: " + STR(loHttp.LastStatus) * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJsonResponse = CreateObject('Chilkat.JsonObject') loJsonResponse.Load(lcStrResp) loJsonResponse.EmitCompact = 0 ? loJsonResponse.Emit() IF (loHttp.LastStatus <> 200) THEN ? "Failed." RELEASE loHttp RELEASE loJsonResponse CANCEL ENDIF * 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 * } * } lcLinksFirst = loJsonResponse.StringOf("links.first") lcLinksLast = loJsonResponse.StringOf("links.last") lcLinksPrev = loJsonResponse.StringOf("links.prev") lcLinksNext = loJsonResponse.StringOf("links.next") lnMetaCurrent_page = loJsonResponse.IntOf("meta.current_page") lnMetaFrom = loJsonResponse.IntOf("meta.from") lnMetaLast_page = loJsonResponse.IntOf("meta.last_page") lcMetaPath = loJsonResponse.StringOf("meta.path") lnMetaPer_page = loJsonResponse.IntOf("meta.per_page") lnMetaTo = loJsonResponse.IntOf("meta.to") lnMetaTotal = loJsonResponse.IntOf("meta.total") i = 0 lnCount_i = loJsonResponse.SizeOfArray("data") DO WHILE i < lnCount_i loJsonResponse.I = i lnId = loJsonResponse.IntOf("data[i].id") lcCreated_at = loJsonResponse.StringOf("data[i].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].updated_at") lnAccount_id = loJsonResponse.IntOf("data[i].account_id") lcAddress_line1 = loJsonResponse.StringOf("data[i].address_line1") lcAddress_line2 = loJsonResponse.StringOf("data[i].address_line2") lcAppointment_date = loJsonResponse.StringOf("data[i].appointment_date") lnAppt_call = loJsonResponse.BoolOf("data[i].appt_call") lcAvailable_date = loJsonResponse.StringOf("data[i].available_date") lcAverage_spending = loJsonResponse.StringOf("data[i].average_spending") lcBe_back_date = loJsonResponse.StringOf("data[i].be_back_date") lcBirth_date = loJsonResponse.StringOf("data[i].birth_date") lcBusiness = loJsonResponse.StringOf("data[i].business") lcCall_date = loJsonResponse.StringOf("data[i].call_date") lcCity = loJsonResponse.StringOf("data[i].city") lcCivility = loJsonResponse.StringOf("data[i].civility") lcCode = loJsonResponse.StringOf("data[i].code") lcCountry = loJsonResponse.StringOf("data[i].country") lcCsi_date = loJsonResponse.StringOf("data[i].csi_date") lcDelivered_by_id = loJsonResponse.StringOf("data[i].delivered_by_id") lcDelivered_date = loJsonResponse.StringOf("data[i].delivered_date") lcDelivery_date = loJsonResponse.StringOf("data[i].delivery_date") lcDivision = loJsonResponse.StringOf("data[i].division") lcEnd_service_date = loJsonResponse.StringOf("data[i].end_service_date") lcFirst_name = loJsonResponse.StringOf("data[i].first_name") lcGas = loJsonResponse.StringOf("data[i].gas") lnGender = loJsonResponse.IntOf("data[i].gender") lnInvoiced = loJsonResponse.BoolOf("data[i].invoiced") lcLast_name = loJsonResponse.StringOf("data[i].last_name") lcLast_visit_date = loJsonResponse.StringOf("data[i].last_visit_date") lcLocale = loJsonResponse.StringOf("data[i].locale") lcLoyalty = loJsonResponse.StringOf("data[i].loyalty") lcNext_visit_date = loJsonResponse.StringOf("data[i].next_visit_date") lcOdometer_last_visit = loJsonResponse.StringOf("data[i].odometer_last_visit") lcOpen_work_order_date = loJsonResponse.StringOf("data[i].open_work_order_date") lcPlanned_pick_up_date = loJsonResponse.StringOf("data[i].planned_pick_up_date") lcPostal_code = loJsonResponse.StringOf("data[i].postal_code") lcPrepaid = loJsonResponse.StringOf("data[i].prepaid") lnPrepared = loJsonResponse.BoolOf("data[i].prepared") lcPresented_date = loJsonResponse.StringOf("data[i].presented_date") lcPromised_date = loJsonResponse.StringOf("data[i].promised_date") lcProvince = loJsonResponse.StringOf("data[i].province") lcRating = loJsonResponse.StringOf("data[i].rating") lnReached_client = loJsonResponse.BoolOf("data[i].reached_client") lcRefinanced_date = loJsonResponse.StringOf("data[i].refinanced_date") lcRepair_date = loJsonResponse.StringOf("data[i].repair_date") lcRepair_order = loJsonResponse.StringOf("data[i].repair_order") lcResult = loJsonResponse.StringOf("data[i].result") lcRoad_test_date = loJsonResponse.StringOf("data[i].road_test_date") lcSale_date = loJsonResponse.StringOf("data[i].sale_date") lcSecond_contact = loJsonResponse.StringOf("data[i].second_contact") lcSecond_contact_civility = loJsonResponse.StringOf("data[i].second_contact_civility") lcSegment = loJsonResponse.StringOf("data[i].segment") lnService_cleaned = loJsonResponse.BoolOf("data[i].service_cleaned") lcService_interval_km = loJsonResponse.StringOf("data[i].service_interval_km") lcService_monthly_km = loJsonResponse.StringOf("data[i].service_monthly_km") lcService_processIntention = loJsonResponse.StringOf("data[i].service_process.intention") lcService_processTransport = loJsonResponse.StringOf("data[i].service_process.transport") lcService_processWalk_around = loJsonResponse.StringOf("data[i].service_process.walk_around") lcSex = loJsonResponse.StringOf("data[i].sex") lcSource = loJsonResponse.StringOf("data[i].source") lcStatus = loJsonResponse.StringOf("data[i].status") lcStorage = loJsonResponse.StringOf("data[i].storage") lcTake_over_date = loJsonResponse.StringOf("data[i].take_over_date") lcV_type = loJsonResponse.StringOf("data[i].type") lcUnsubscribe_all_date = loJsonResponse.StringOf("data[i].unsubscribe_all_date") lcUnsubscribe_call_date = loJsonResponse.StringOf("data[i].unsubscribe_call_date") lcUnsubscribe_email_date = loJsonResponse.StringOf("data[i].unsubscribe_email_date") lcUnsubscribe_sms_date = loJsonResponse.StringOf("data[i].unsubscribe_sms_date") lcWork_order = loJsonResponse.StringOf("data[i].work_order") lnAccountId = loJsonResponse.IntOf("data[i].account.id") lcAccountCreated_at = loJsonResponse.StringOf("data[i].account.created_at") lcAccountUpdated_at = loJsonResponse.StringOf("data[i].account.updated_at") lnAccountPartner_id = loJsonResponse.IntOf("data[i].account.partner_id") lnAccountActivity_report = loJsonResponse.BoolOf("data[i].account.activity_report") lnAccountCommercial = loJsonResponse.BoolOf("data[i].account.commercial") lnAccountEvent = loJsonResponse.BoolOf("data[i].account.event") lnAccountLeadxpress = loJsonResponse.BoolOf("data[i].account.leadxpress") lnAccountLoyalty = loJsonResponse.BoolOf("data[i].account.loyalty") lnAccountPhone_up = loJsonResponse.BoolOf("data[i].account.phone_up") lnAccountRenewal = loJsonResponse.BoolOf("data[i].account.renewal") lnAccountSale_table = loJsonResponse.BoolOf("data[i].account.sale_table") lnAccountService = loJsonResponse.BoolOf("data[i].account.service") lnAccountWalk_in = loJsonResponse.BoolOf("data[i].account.walk_in") lnAccountWebboost = loJsonResponse.BoolOf("data[i].account.webboost") lnAccountAccount_manager = loJsonResponse.BoolOf("data[i].account.account_manager") lcAccountActivation_date = loJsonResponse.StringOf("data[i].account.activation_date") lnAccountActive = loJsonResponse.BoolOf("data[i].account.active") lnAccountAssigned_lead = loJsonResponse.BoolOf("data[i].account.assigned_lead") lnAccountAuto_renewal = loJsonResponse.BoolOf("data[i].account.auto_renewal") lnAccountAuto_renewal_new = loJsonResponse.BoolOf("data[i].account.auto_renewal_new") lnAccountAuto_renewal_used = loJsonResponse.BoolOf("data[i].account.auto_renewal_used") lnAccountAutomation = loJsonResponse.BoolOf("data[i].account.automation") lnAccountBdc_advisor = loJsonResponse.BoolOf("data[i].account.bdc_advisor") lnAccountCalendar_options = loJsonResponse.BoolOf("data[i].account.calendar_options") lnAccountClient_card_fieldsProcessGas = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.gas") lnAccountClient_card_fieldsProcessRecorded = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded") lnAccountClient_card_fieldsProcessAvailable = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.available") lnAccountClient_card_fieldsProcessDiscounted = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted") lnAccountClient_card_fieldsCommercialProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit") lnAccountClient_card_fieldsCommercialExclude = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude") lnAccountClient_card_fieldsCommercialMeeting = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting") lnAccountClient_card_fieldsPerformanceDeposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit") lnAccountClient_card_fieldsPerformanceRefinanced = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced") lnAccountClient_card_fieldsPerformanceDealer_tour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour") lnAccountClient_card_fieldsPerformanceWalk_around = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around") lnAccountClient_card_fieldsPerformanceQualification = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification") lnAccountClient_card_fieldsPerformanceTwenty_four_hour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour") lnAccountClient_card_fieldsGeneral_infoBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget") lnAccountClient_card_fieldsGeneral_infoSector = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector") lnAccountClient_card_fieldsGeneral_infoCustom_1 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1") lnAccountClient_card_fieldsGeneral_infoCustom_2 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2") lnAccountClient_card_fieldsGeneral_infoCustom_3 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3") lnAccountClient_card_fieldsGeneral_infoCustom_4 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4") lnAccountClient_card_fieldsGeneral_infoCustom_5 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5") lnAccountClient_card_fieldsGeneral_infoCustom_6 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6") lnAccountClient_card_fieldsGeneral_infoCustom_7 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7") lnAccountClient_card_fieldsGeneral_infoCustom_8 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8") lnAccountClient_card_fieldsGeneral_infoCustom_9 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9") lnAccountClient_card_fieldsGeneral_infoCustom_10 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10") lnAccountClient_card_fieldsGeneral_infoCommunication_preference = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference") lnAccountClient_card_fieldsWanted_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin") lnAccountClient_card_fieldsWanted_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel") lnAccountClient_card_fieldsWanted_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate") lnAccountClient_card_fieldsWanted_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term") lnAccountClient_card_fieldsWanted_vehicleTire = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire") lnAccountClient_card_fieldsWanted_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year") lnAccountClient_card_fieldsWanted_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color") lnAccountClient_card_fieldsWanted_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price") lnAccountClient_card_fieldsWanted_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock") lnAccountClient_card_fieldsWanted_vehicleTotal = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total") lnAccountClient_card_fieldsWanted_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget") lnAccountClient_card_fieldsWanted_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine") lnAccountClient_card_fieldsWanted_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length") lnAccountClient_card_fieldsWanted_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit") lnAccountClient_card_fieldsWanted_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix") lnAccountClient_card_fieldsWanted_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight") lnAccountClient_card_fieldsWanted_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment") lnAccountClient_card_fieldsWanted_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage") lnAccountClient_card_fieldsWanted_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment") lnAccountClient_card_fieldsWanted_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType") lnAccountClient_card_fieldsWanted_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category") lnAccountClient_card_fieldsWanted_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality") lnAccountClient_card_fieldsWanted_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual") lnAccountClient_card_fieldsWanted_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping") lnAccountClient_card_fieldsWanted_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty") lnAccountClient_card_fieldsWanted_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency") lnAccountClient_card_fieldsWanted_vehicleAccessories = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories") lnAccountClient_card_fieldsWanted_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv") lnAccountClient_card_fieldsWanted_vehiclePreparation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation") lnAccountClient_card_fieldsWanted_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash") lnAccountClient_card_fieldsWanted_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number") lnAccountClient_card_fieldsWanted_vehicleOrder_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number") lnAccountClient_card_fieldsWanted_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission") lnAccountClient_card_fieldsWanted_vehicleDocumentation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation") lnAccountClient_card_fieldsWanted_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels") lnAccountClient_card_fieldsWanted_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior") lnAccountClient_card_fieldsWanted_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior") lnAccountClient_card_fieldsWanted_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage") lnAccountClient_card_fieldsWanted_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit") lnAccountClient_card_fieldsWanted_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date") lnAccountClient_card_fieldsExchange_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin") lnAccountClient_card_fieldsExchange_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel") lnAccountClient_card_fieldsExchange_vehicleLink = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link") lnAccountClient_card_fieldsExchange_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate") lnAccountClient_card_fieldsExchange_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term") lnAccountClient_card_fieldsExchange_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year") lnAccountClient_card_fieldsExchange_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color") lnAccountClient_card_fieldsExchange_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price") lnAccountClient_card_fieldsExchange_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock") lnAccountClient_card_fieldsExchange_vehicleValue = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value") lnAccountClient_card_fieldsExchange_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget") lnAccountClient_card_fieldsExchange_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine") lnAccountClient_card_fieldsExchange_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length") lnAccountClient_card_fieldsExchange_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit") lnAccountClient_card_fieldsExchange_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix") lnAccountClient_card_fieldsExchange_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight") lnAccountClient_card_fieldsExchange_vehicleBalance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance") lnAccountClient_card_fieldsExchange_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment") lnAccountClient_card_fieldsExchange_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage") lnAccountClient_card_fieldsExchange_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment") lnAccountClient_card_fieldsExchange_vehicleRenewal = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal") lnAccountClient_card_fieldsExchange_vehicleSold_by = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by") lnAccountClient_card_fieldsExchange_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType") lnAccountClient_card_fieldsExchange_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category") lnAccountClient_card_fieldsExchange_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality") lnAccountClient_card_fieldsExchange_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual") lnAccountClient_card_fieldsExchange_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping") lnAccountClient_card_fieldsExchange_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty") lnAccountClient_card_fieldsExchange_vehicleCondition = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition") lnAccountClient_card_fieldsExchange_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency") lnAccountClient_card_fieldsExchange_vehicleIntention = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention") lnAccountClient_card_fieldsExchange_vehicleRefinance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance") lnAccountClient_card_fieldsExchange_vehicleRequested = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested") lnAccountClient_card_fieldsExchange_vehicleSold_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date") lnAccountClient_card_fieldsExchange_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv") lnAccountClient_card_fieldsExchange_vehicleInstitution = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution") lnAccountClient_card_fieldsExchange_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash") lnAccountClient_card_fieldsExchange_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number") lnAccountClient_card_fieldsExchange_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission") lnAccountClient_card_fieldsExchange_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels") lnAccountClient_card_fieldsExchange_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior") lnAccountClient_card_fieldsExchange_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior") lnAccountClient_card_fieldsExchange_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage") lnAccountClient_card_fieldsExchange_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit") lnAccountClient_card_fieldsExchange_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date") lnAccountClient_number = loJsonResponse.BoolOf("data[i].account.client_number") lnAccountConfirmation_appt = loJsonResponse.BoolOf("data[i].account.confirmation_appt") lnAccountCredit = loJsonResponse.BoolOf("data[i].account.credit") lnAccountCsi = loJsonResponse.BoolOf("data[i].account.csi") lnAccountCsi_used = loJsonResponse.BoolOf("data[i].account.csi_used") lcAccountDefault_deliveryman_user_id = loJsonResponse.StringOf("data[i].account.default_deliveryman_user_id") lnAccountDelivered_by = loJsonResponse.BoolOf("data[i].account.delivered_by") lnAccountDisable_communication_audio = loJsonResponse.BoolOf("data[i].account.disable_communication_audio") lnAccountDuplicates = loJsonResponse.BoolOf("data[i].account.duplicates") lnAccountGuest_action = loJsonResponse.BoolOf("data[i].account.guest_action") lnAccountEmail_client = loJsonResponse.BoolOf("data[i].account.email_client") lnAccountIn_turn = loJsonResponse.BoolOf("data[i].account.in_turn") lnAccountIn_turn_director_management = loJsonResponse.BoolOf("data[i].account.in_turn_director_management") lnAccountLeads_other_division = loJsonResponse.BoolOf("data[i].account.leads_other_division") lnAccountLeadxpress_optionPriority = loJsonResponse.IntOf("data[i].account.leadxpress_option.priority") lnAccountLeadxpress_optionReminderFrequency = loJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency") lnAccountLeadxpress_optionReminderRecurrence = loJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence") lnAccountLeadxpress_optionScheduleAccount = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account") lnAccountLeadxpress_optionScheduleAdvisor = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor") lnAccountLimited_audio_access = loJsonResponse.BoolOf("data[i].account.limited_audio_access") lcAccountLogo = loJsonResponse.StringOf("data[i].account.logo") lcAccountLogo_en = loJsonResponse.StringOf("data[i].account.logo_en") lnAccountMandatory_coordinate = loJsonResponse.BoolOf("data[i].account.mandatory_coordinate") lnAccountManually_status = loJsonResponse.BoolOf("data[i].account.manually_status") lcAccountMerge_rule = loJsonResponse.StringOf("data[i].account.merge_rule") lnAccountMonth_start_day = loJsonResponse.IntOf("data[i].account.month_start_day") lcAccountName = loJsonResponse.StringOf("data[i].account.name") lnAccountNiotext = loJsonResponse.BoolOf("data[i].account.niotext") lnAccountNiotext_phone = loJsonResponse.BoolOf("data[i].account.niotext_phone") lcAccountPhone = loJsonResponse.StringOf("data[i].account.phone") lnAccountPower_sport = loJsonResponse.BoolOf("data[i].account.power_sport") lnAccountProcess = loJsonResponse.BoolOf("data[i].account.process") lnAccountRecreative_special = loJsonResponse.BoolOf("data[i].account.recreative_special") lnAccountResult_date_validation = loJsonResponse.BoolOf("data[i].account.result_date_validation") lnAccountSale_accessories = loJsonResponse.BoolOf("data[i].account.sale_accessories") lnAccountSale_by_phone = loJsonResponse.BoolOf("data[i].account.sale_by_phone") lnAccountSale_date_month = loJsonResponse.BoolOf("data[i].account.sale_date_month") lnAccountSale_table_optionsAccessory_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column") lnAccountSale_table_optionsCommercial_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column") lnAccountSale_table_optionsDivision_grouped_total_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column") lnAccountSale_validation = loJsonResponse.BoolOf("data[i].account.sale_validation") lnAccountScan = loJsonResponse.BoolOf("data[i].account.scan") lnAccountStock_required_for_sale = loJsonResponse.BoolOf("data[i].account.stock_required_for_sale") lnAccountTake_over_director = loJsonResponse.BoolOf("data[i].account.take_over_director") lnAccountTrade_report = loJsonResponse.BoolOf("data[i].account.trade_report") lnAccountUnrestricted_assignment = loJsonResponse.BoolOf("data[i].account.unrestricted_assignment") lnAccountUnsubscribe = loJsonResponse.BoolOf("data[i].account.unsubscribe") lnAccountUntreated_lead = loJsonResponse.BoolOf("data[i].account.untreated_lead") lnAccountVehicle_model_text = loJsonResponse.BoolOf("data[i].account.vehicle_model_text") lnAccountVehicle_text = loJsonResponse.BoolOf("data[i].account.vehicle_text") lnAccountVerified_sale = loJsonResponse.BoolOf("data[i].account.verified_sale") lnAccountVin_decoder = loJsonResponse.BoolOf("data[i].account.vin_decoder") lcAccountWaiting_sale_date = loJsonResponse.StringOf("data[i].account.waiting_sale_date") lnAccountWaiting_sale_option = loJsonResponse.BoolOf("data[i].account.waiting_sale_option") lcAdvisor = loJsonResponse.StringOf("data[i].advisor") j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].emails") DO WHILE j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].emails[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].emails[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].emails[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].emails[j].lead_id") lcAddress = loJsonResponse.StringOf("data[i].emails[j].address") lcV_type = loJsonResponse.StringOf("data[i].emails[j].type") lnValid = loJsonResponse.BoolOf("data[i].emails[j].valid") j = j + 1 ENDDO j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].phones") DO WHILE j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].phones[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].phones[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].phones[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].phones[j].lead_id") lcExtension = loJsonResponse.StringOf("data[i].phones[j].extension") lcNumber = loJsonResponse.StringOf("data[i].phones[j].number") lcV_type = loJsonResponse.StringOf("data[i].phones[j].type") lnValid = loJsonResponse.BoolOf("data[i].phones[j].valid") lnValidated = loJsonResponse.BoolOf("data[i].phones[j].validated") lnMobile = loJsonResponse.BoolOf("data[i].phones[j].mobile") j = j + 1 ENDDO j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].vehicles") DO WHILE j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].vehicles[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].vehicles[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].vehicles[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].vehicles[j].lead_id") lcAccessories = loJsonResponse.StringOf("data[i].vehicles[j].accessories") lcAllowed_odometer = loJsonResponse.StringOf("data[i].vehicles[j].allowed_odometer") lnBalance = loJsonResponse.IntOf("data[i].vehicles[j].balance") lcBudget_max = loJsonResponse.StringOf("data[i].vehicles[j].budget_max") lcBudget_min = loJsonResponse.StringOf("data[i].vehicles[j].budget_min") lcCash_down = loJsonResponse.StringOf("data[i].vehicles[j].cash_down") lcCategory = loJsonResponse.StringOf("data[i].vehicles[j].category") lcCategory_rv = loJsonResponse.StringOf("data[i].vehicles[j].category_rv") lcClient_number = loJsonResponse.StringOf("data[i].vehicles[j].client_number") lcColor_exterior = loJsonResponse.StringOf("data[i].vehicles[j].color_exterior") lcColor_interior = loJsonResponse.StringOf("data[i].vehicles[j].color_interior") lcComment = loJsonResponse.StringOf("data[i].vehicles[j].comment") lcCondition = loJsonResponse.StringOf("data[i].vehicles[j].condition") lcEnd_contract_date = loJsonResponse.StringOf("data[i].vehicles[j].end_contract_date") lcEnd_warranty_date = loJsonResponse.StringOf("data[i].vehicles[j].end_warranty_date") lcEngine = loJsonResponse.StringOf("data[i].vehicles[j].engine") lcExtended_warranty = loJsonResponse.StringOf("data[i].vehicles[j].extended_warranty") lcFuel = loJsonResponse.StringOf("data[i].vehicles[j].fuel") lcLength_max = loJsonResponse.StringOf("data[i].vehicles[j].length_max") lcLength_min = loJsonResponse.StringOf("data[i].vehicles[j].length_min") lcLicense_plate = loJsonResponse.StringOf("data[i].vehicles[j].license_plate") lcMake = loJsonResponse.StringOf("data[i].vehicles[j].make") lcModality = loJsonResponse.StringOf("data[i].vehicles[j].modality") lcModel = loJsonResponse.StringOf("data[i].vehicles[j].model") lcOdometer = loJsonResponse.StringOf("data[i].vehicles[j].odometer") lcOffer_number = loJsonResponse.StringOf("data[i].vehicles[j].offer_number") lcV_option = loJsonResponse.StringOf("data[i].vehicles[j].option") lcOrder_number = loJsonResponse.StringOf("data[i].vehicles[j].order_number") lcPayment = loJsonResponse.StringOf("data[i].vehicles[j].payment") lcPayment_frequency = loJsonResponse.StringOf("data[i].vehicles[j].payment_frequency") lcPreparation = loJsonResponse.StringOf("data[i].vehicles[j].preparation") lcPrice = loJsonResponse.StringOf("data[i].vehicles[j].price") lcProfit = loJsonResponse.StringOf("data[i].vehicles[j].profit") lcPurchase_date = loJsonResponse.StringOf("data[i].vehicles[j].purchase_date") lcRate = loJsonResponse.StringOf("data[i].vehicles[j].rate") lcRecall = loJsonResponse.StringOf("data[i].vehicles[j].recall") lcRecorded_date = loJsonResponse.StringOf("data[i].vehicles[j].recorded_date") lcResidual = loJsonResponse.StringOf("data[i].vehicles[j].residual") lcSecurity_deposit = loJsonResponse.StringOf("data[i].vehicles[j].security_deposit") lcSleeping = loJsonResponse.StringOf("data[i].vehicles[j].sleeping") lnSold = loJsonResponse.BoolOf("data[i].vehicles[j].sold") lcSold_by = loJsonResponse.StringOf("data[i].vehicles[j].sold_by") lcSold_date = loJsonResponse.StringOf("data[i].vehicles[j].sold_date") lcStock = loJsonResponse.StringOf("data[i].vehicles[j].stock") lcStock_state = loJsonResponse.StringOf("data[i].vehicles[j].stock_state") lcTerm = loJsonResponse.StringOf("data[i].vehicles[j].term") lnTire = loJsonResponse.BoolOf("data[i].vehicles[j].tire") lcTransmission = loJsonResponse.StringOf("data[i].vehicles[j].transmission") lcTrim = loJsonResponse.StringOf("data[i].vehicles[j].trim") lcV_type = loJsonResponse.StringOf("data[i].vehicles[j].type") lcUrl = loJsonResponse.StringOf("data[i].vehicles[j].url") lcValue = loJsonResponse.StringOf("data[i].vehicles[j].value") lcVin = loJsonResponse.StringOf("data[i].vehicles[j].vin") lcWarranty = loJsonResponse.StringOf("data[i].vehicles[j].warranty") lcWeight = loJsonResponse.StringOf("data[i].vehicles[j].weight") lcYear = loJsonResponse.StringOf("data[i].vehicles[j].year") lcYear_max = loJsonResponse.StringOf("data[i].vehicles[j].year_max") lcYear_min = loJsonResponse.StringOf("data[i].vehicles[j].year_min") j = j + 1 ENDDO j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].products") DO WHILE j < lnCount_j loJsonResponse.J = j j = j + 1 ENDDO i = i + 1 ENDDO RELEASE loHttp RELEASE loJsonResponse |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.