Lianja
Lianja
Activix CRM Search for Leads
See more Activix CRM Examples
Demonstrates how to full-text search for leads, returning a JSON list of leads.Chilkat Lianja Downloads
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loHttp = createobject("CkHttp")
loHttp.AuthToken = "ACCESS_TOKEN"
loHttp.Accept = "application/json"
lcStrResp = loHttp.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe")
if (loHttp.LastMethodSuccess <> .T.) then
? loHttp.LastErrorText
release loHttp
return
endif
? "Response Status Code: " + str(loHttp.LastStatus)
loJsonResponse = createobject("CkJsonObject")
loJsonResponse.Load(lcStrResp)
loJsonResponse.EmitCompact = .F.
? loJsonResponse.Emit()
if (loHttp.LastStatus <> 200) then
? "Failed."
release loHttp
release loJsonResponse
return
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")
llAppt_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")
llInvoiced = 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")
llPrepared = 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")
llReached_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")
llService_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")
llAccountActivity_report = loJsonResponse.BoolOf("data[i].account.activity_report")
llAccountCommercial = loJsonResponse.BoolOf("data[i].account.commercial")
llAccountEvent = loJsonResponse.BoolOf("data[i].account.event")
llAccountLeadxpress = loJsonResponse.BoolOf("data[i].account.leadxpress")
llAccountLoyalty = loJsonResponse.BoolOf("data[i].account.loyalty")
llAccountPhone_up = loJsonResponse.BoolOf("data[i].account.phone_up")
llAccountRenewal = loJsonResponse.BoolOf("data[i].account.renewal")
llAccountSale_table = loJsonResponse.BoolOf("data[i].account.sale_table")
llAccountService = loJsonResponse.BoolOf("data[i].account.service")
llAccountWalk_in = loJsonResponse.BoolOf("data[i].account.walk_in")
llAccountWebboost = loJsonResponse.BoolOf("data[i].account.webboost")
llAccountAccount_manager = loJsonResponse.BoolOf("data[i].account.account_manager")
lcAccountActivation_date = loJsonResponse.StringOf("data[i].account.activation_date")
llAccountActive = loJsonResponse.BoolOf("data[i].account.active")
llAccountAssigned_lead = loJsonResponse.BoolOf("data[i].account.assigned_lead")
llAccountAuto_renewal = loJsonResponse.BoolOf("data[i].account.auto_renewal")
llAccountAuto_renewal_new = loJsonResponse.BoolOf("data[i].account.auto_renewal_new")
llAccountAuto_renewal_used = loJsonResponse.BoolOf("data[i].account.auto_renewal_used")
llAccountAutomation = loJsonResponse.BoolOf("data[i].account.automation")
llAccountBdc_advisor = loJsonResponse.BoolOf("data[i].account.bdc_advisor")
llAccountCalendar_options = loJsonResponse.BoolOf("data[i].account.calendar_options")
llAccountClient_card_fieldsProcessGas = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.gas")
llAccountClient_card_fieldsProcessRecorded = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded")
llAccountClient_card_fieldsProcessAvailable = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.available")
llAccountClient_card_fieldsProcessDiscounted = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted")
llAccountClient_card_fieldsCommercialProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit")
llAccountClient_card_fieldsCommercialExclude = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude")
llAccountClient_card_fieldsCommercialMeeting = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting")
llAccountClient_card_fieldsPerformanceDeposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit")
llAccountClient_card_fieldsPerformanceRefinanced = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced")
llAccountClient_card_fieldsPerformanceDealer_tour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour")
llAccountClient_card_fieldsPerformanceWalk_around = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around")
llAccountClient_card_fieldsPerformanceQualification = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification")
llAccountClient_card_fieldsPerformanceTwenty_four_hour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour")
llAccountClient_card_fieldsGeneral_infoBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget")
llAccountClient_card_fieldsGeneral_infoSector = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector")
llAccountClient_card_fieldsGeneral_infoCustom_1 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1")
llAccountClient_card_fieldsGeneral_infoCustom_2 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2")
llAccountClient_card_fieldsGeneral_infoCustom_3 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3")
llAccountClient_card_fieldsGeneral_infoCustom_4 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4")
llAccountClient_card_fieldsGeneral_infoCustom_5 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5")
llAccountClient_card_fieldsGeneral_infoCustom_6 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6")
llAccountClient_card_fieldsGeneral_infoCustom_7 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7")
llAccountClient_card_fieldsGeneral_infoCustom_8 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8")
llAccountClient_card_fieldsGeneral_infoCustom_9 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9")
llAccountClient_card_fieldsGeneral_infoCustom_10 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10")
llAccountClient_card_fieldsGeneral_infoCommunication_preference = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference")
llAccountClient_card_fieldsWanted_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin")
llAccountClient_card_fieldsWanted_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel")
llAccountClient_card_fieldsWanted_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate")
llAccountClient_card_fieldsWanted_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term")
llAccountClient_card_fieldsWanted_vehicleTire = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire")
llAccountClient_card_fieldsWanted_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year")
llAccountClient_card_fieldsWanted_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color")
llAccountClient_card_fieldsWanted_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price")
llAccountClient_card_fieldsWanted_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock")
llAccountClient_card_fieldsWanted_vehicleTotal = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total")
llAccountClient_card_fieldsWanted_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget")
llAccountClient_card_fieldsWanted_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine")
llAccountClient_card_fieldsWanted_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length")
llAccountClient_card_fieldsWanted_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit")
llAccountClient_card_fieldsWanted_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix")
llAccountClient_card_fieldsWanted_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight")
llAccountClient_card_fieldsWanted_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment")
llAccountClient_card_fieldsWanted_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage")
llAccountClient_card_fieldsWanted_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment")
llAccountClient_card_fieldsWanted_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType")
llAccountClient_card_fieldsWanted_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category")
llAccountClient_card_fieldsWanted_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality")
llAccountClient_card_fieldsWanted_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual")
llAccountClient_card_fieldsWanted_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping")
llAccountClient_card_fieldsWanted_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty")
llAccountClient_card_fieldsWanted_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency")
llAccountClient_card_fieldsWanted_vehicleAccessories = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories")
llAccountClient_card_fieldsWanted_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv")
llAccountClient_card_fieldsWanted_vehiclePreparation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation")
llAccountClient_card_fieldsWanted_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash")
llAccountClient_card_fieldsWanted_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number")
llAccountClient_card_fieldsWanted_vehicleOrder_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number")
llAccountClient_card_fieldsWanted_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission")
llAccountClient_card_fieldsWanted_vehicleDocumentation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation")
llAccountClient_card_fieldsWanted_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels")
llAccountClient_card_fieldsWanted_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior")
llAccountClient_card_fieldsWanted_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior")
llAccountClient_card_fieldsWanted_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage")
llAccountClient_card_fieldsWanted_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit")
llAccountClient_card_fieldsWanted_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date")
llAccountClient_card_fieldsExchange_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin")
llAccountClient_card_fieldsExchange_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel")
llAccountClient_card_fieldsExchange_vehicleLink = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link")
llAccountClient_card_fieldsExchange_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate")
llAccountClient_card_fieldsExchange_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term")
llAccountClient_card_fieldsExchange_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year")
llAccountClient_card_fieldsExchange_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color")
llAccountClient_card_fieldsExchange_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price")
llAccountClient_card_fieldsExchange_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock")
llAccountClient_card_fieldsExchange_vehicleValue = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value")
llAccountClient_card_fieldsExchange_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget")
llAccountClient_card_fieldsExchange_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine")
llAccountClient_card_fieldsExchange_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length")
llAccountClient_card_fieldsExchange_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit")
llAccountClient_card_fieldsExchange_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix")
llAccountClient_card_fieldsExchange_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight")
llAccountClient_card_fieldsExchange_vehicleBalance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance")
llAccountClient_card_fieldsExchange_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment")
llAccountClient_card_fieldsExchange_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage")
llAccountClient_card_fieldsExchange_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment")
llAccountClient_card_fieldsExchange_vehicleRenewal = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal")
llAccountClient_card_fieldsExchange_vehicleSold_by = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by")
llAccountClient_card_fieldsExchange_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType")
llAccountClient_card_fieldsExchange_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category")
llAccountClient_card_fieldsExchange_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality")
llAccountClient_card_fieldsExchange_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual")
llAccountClient_card_fieldsExchange_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping")
llAccountClient_card_fieldsExchange_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty")
llAccountClient_card_fieldsExchange_vehicleCondition = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition")
llAccountClient_card_fieldsExchange_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency")
llAccountClient_card_fieldsExchange_vehicleIntention = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention")
llAccountClient_card_fieldsExchange_vehicleRefinance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance")
llAccountClient_card_fieldsExchange_vehicleRequested = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested")
llAccountClient_card_fieldsExchange_vehicleSold_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date")
llAccountClient_card_fieldsExchange_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv")
llAccountClient_card_fieldsExchange_vehicleInstitution = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution")
llAccountClient_card_fieldsExchange_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash")
llAccountClient_card_fieldsExchange_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number")
llAccountClient_card_fieldsExchange_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission")
llAccountClient_card_fieldsExchange_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels")
llAccountClient_card_fieldsExchange_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior")
llAccountClient_card_fieldsExchange_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior")
llAccountClient_card_fieldsExchange_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage")
llAccountClient_card_fieldsExchange_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit")
llAccountClient_card_fieldsExchange_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date")
llAccountClient_number = loJsonResponse.BoolOf("data[i].account.client_number")
llAccountConfirmation_appt = loJsonResponse.BoolOf("data[i].account.confirmation_appt")
llAccountCredit = loJsonResponse.BoolOf("data[i].account.credit")
llAccountCsi = loJsonResponse.BoolOf("data[i].account.csi")
llAccountCsi_used = loJsonResponse.BoolOf("data[i].account.csi_used")
lcAccountDefault_deliveryman_user_id = loJsonResponse.StringOf("data[i].account.default_deliveryman_user_id")
llAccountDelivered_by = loJsonResponse.BoolOf("data[i].account.delivered_by")
llAccountDisable_communication_audio = loJsonResponse.BoolOf("data[i].account.disable_communication_audio")
llAccountDuplicates = loJsonResponse.BoolOf("data[i].account.duplicates")
llAccountGuest_action = loJsonResponse.BoolOf("data[i].account.guest_action")
llAccountEmail_client = loJsonResponse.BoolOf("data[i].account.email_client")
llAccountIn_turn = loJsonResponse.BoolOf("data[i].account.in_turn")
llAccountIn_turn_director_management = loJsonResponse.BoolOf("data[i].account.in_turn_director_management")
llAccountLeads_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")
llAccountLeadxpress_optionScheduleAccount = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account")
llAccountLeadxpress_optionScheduleAdvisor = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor")
llAccountLimited_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")
llAccountMandatory_coordinate = loJsonResponse.BoolOf("data[i].account.mandatory_coordinate")
llAccountManually_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")
llAccountNiotext = loJsonResponse.BoolOf("data[i].account.niotext")
llAccountNiotext_phone = loJsonResponse.BoolOf("data[i].account.niotext_phone")
lcAccountPhone = loJsonResponse.StringOf("data[i].account.phone")
llAccountPower_sport = loJsonResponse.BoolOf("data[i].account.power_sport")
llAccountProcess = loJsonResponse.BoolOf("data[i].account.process")
llAccountRecreative_special = loJsonResponse.BoolOf("data[i].account.recreative_special")
llAccountResult_date_validation = loJsonResponse.BoolOf("data[i].account.result_date_validation")
llAccountSale_accessories = loJsonResponse.BoolOf("data[i].account.sale_accessories")
llAccountSale_by_phone = loJsonResponse.BoolOf("data[i].account.sale_by_phone")
llAccountSale_date_month = loJsonResponse.BoolOf("data[i].account.sale_date_month")
llAccountSale_table_optionsAccessory_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column")
llAccountSale_table_optionsCommercial_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column")
llAccountSale_table_optionsDivision_grouped_total_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column")
llAccountSale_validation = loJsonResponse.BoolOf("data[i].account.sale_validation")
llAccountScan = loJsonResponse.BoolOf("data[i].account.scan")
llAccountStock_required_for_sale = loJsonResponse.BoolOf("data[i].account.stock_required_for_sale")
llAccountTake_over_director = loJsonResponse.BoolOf("data[i].account.take_over_director")
llAccountTrade_report = loJsonResponse.BoolOf("data[i].account.trade_report")
llAccountUnrestricted_assignment = loJsonResponse.BoolOf("data[i].account.unrestricted_assignment")
llAccountUnsubscribe = loJsonResponse.BoolOf("data[i].account.unsubscribe")
llAccountUntreated_lead = loJsonResponse.BoolOf("data[i].account.untreated_lead")
llAccountVehicle_model_text = loJsonResponse.BoolOf("data[i].account.vehicle_model_text")
llAccountVehicle_text = loJsonResponse.BoolOf("data[i].account.vehicle_text")
llAccountVerified_sale = loJsonResponse.BoolOf("data[i].account.verified_sale")
llAccountVin_decoder = loJsonResponse.BoolOf("data[i].account.vin_decoder")
lcAccountWaiting_sale_date = loJsonResponse.StringOf("data[i].account.waiting_sale_date")
llAccountWaiting_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")
llValid = 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")
llValid = loJsonResponse.BoolOf("data[i].phones[j].valid")
llValidated = loJsonResponse.BoolOf("data[i].phones[j].validated")
llMobile = 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")
llSold = 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")
llTire = 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