Visual FoxPro
Visual FoxPro
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 Visual FoxPro Downloads
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.
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)
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