Chilkat Examples

ChilkatHOME.NET Core C#Android™AutoItCC#C++Chilkat2-PythonCkPythonClassic ASPDataFlexDelphi ActiveXDelphi DLLGoJavaLianjaMono C#Node.jsObjective-CPHP ActiveXPHP ExtensionPerlPowerBuilderPowerShellPureBasicRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++VB.NETVBScriptVisual Basic 6.0Visual FoxProXojo Plugin

Visual FoxPro Web API Examples

Primary Categories

ABN AMRO
AWS Secrets Manager
AWS Security Token Service
AWS Translate
Activix CRM
Adyen
Alibaba Cloud OSS
Amazon Cognito
Amazon DynamoDB
Amazon MWS
Amazon Pay
Amazon Rekognition
Amazon SP-API
Amazon Voice ID
Aruba Fatturazione
Azure Maps
Azure Monitor
Azure OAuth2
Azure Storage Accounts
Backblaze S3
Banco Inter
Belgian eHealth Platform
Bitfinex v2 REST
Bluzone
BrickLink
Bunny CDN
CallRail
CardConnect
Cerved
ClickBank
Clickatell
Cloudfare
Constant Contact
DocuSign
Duo Auth MFA
ETrade
Ecwid
Egypt ITIDA
Egypt eReceipt
Etsy
Facebook
Faire
Frame.io
GeoOp
GetHarvest
Global Payments
Google People
Google Search Console
Google Translate
Google Vision
Hungary NAV Invoicing
IBM Text to Speech
Ibanity
IntakeQ
JCC Cyprus
Jira
Lightspeed
MYOB
Magento
Mailgun
Malaysia MyInvois

Mastercard
MedTunnel
MercadoLibre
MessageMedia
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
Moody's
Okta OAuth/OIDC
OneLogin OIDC
OneNote
OpenAI ChatGPT
PRODA
PayPal
Paynow.pl
Peoplevox
Populi
QuickBooks
Rabobank
Refinitiv
Royal Mail OBA
SCiS Schools Catalogue
SII Chile
SMSAPI
SOAP finkok.com
Salesforce
SendGrid
Shippo
Shopify
Shopware
Shopware 6
SimpleTexting
Square
Stripe
SugarCRM
TicketBAI
TikTok Shop
Trello
Twilio
Twitter API v2
Twitter v1
UPS
UniPin
VoiceBase
Vonage
WaTrend
Walmart v3
Wasabi
WhatsApp
WiX
WooCommerce
WordPress
Xero
Yahoo Mail
Yapily
Yousign
ZATCA
Zendesk
Zoom
_Miscellaneous_
eBay
effectconnect
hacienda.go.cr

 

 

 

(Visual FoxPro) Activix CRM Search for Leads

Demonstrates 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

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

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.