Sample code for 30+ languages & platforms
AutoIt

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 AutoIt Downloads

AutoIt
; This example requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.

$oHttp = ObjCreate("Chilkat.Http")

$oHttp.AuthToken = "ACCESS_TOKEN"

$oHttp.Accept = "application/json"

Local $strResp = $oHttp.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe")
If ($oHttp.LastMethodSuccess <> True) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

ConsoleWrite("Response Status Code: " & $oHttp.LastStatus & @CRLF)

$oJsonResponse = ObjCreate("Chilkat.JsonObject")
$oJsonResponse.Load($strResp)
$oJsonResponse.EmitCompact = False
ConsoleWrite($oJsonResponse.Emit() & @CRLF)

If ($oHttp.LastStatus <> 200) Then
    ConsoleWrite("Failed." & @CRLF)
    Exit
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
;     }
; }

Local $sLinksFirst
Local $sLinksLast
Local $sLinksPrev
Local $sLinksNext
Local $iMetaCurrent_page
Local $iMetaFrom
Local $iMetaLast_page
Local $sMetaPath
Local $iMetaPer_page
Local $iMetaTo
Local $iMetaTotal
Local $i
Local $iCount_i
Local $id
Local $sCreated_at
Local $sUpdated_at
Local $iAccount_id
Local $sAddress_line1
Local $sAddress_line2
Local $sAppointment_date
Local $bAppt_call
Local $sAvailable_date
Local $sAverage_spending
Local $sBe_back_date
Local $sBirth_date
Local $sBusiness
Local $sCall_date
Local $sCity
Local $sCivility
Local $sCode
Local $sCountry
Local $sCsi_date
Local $sDelivered_by_id
Local $sDelivered_date
Local $sDelivery_date
Local $sDivision
Local $sEnd_service_date
Local $sFirst_name
Local $sGas
Local $iGender
Local $bInvoiced
Local $sLast_name
Local $sLast_visit_date
Local $sLocale
Local $sLoyalty
Local $sNext_visit_date
Local $sOdometer_last_visit
Local $sOpen_work_order_date
Local $sPlanned_pick_up_date
Local $sPostal_code
Local $sPrepaid
Local $bPrepared
Local $sPresented_date
Local $sPromised_date
Local $sProvince
Local $sRating
Local $bReached_client
Local $sRefinanced_date
Local $sRepair_date
Local $sRepair_order
Local $sResult
Local $sRoad_test_date
Local $sale_date
Local $second_contact
Local $second_contact_civility
Local $segment
Local $bService_cleaned
Local $service_interval_km
Local $service_monthly_km
Local $service_processIntention
Local $service_processTransport
Local $service_processWalk_around
Local $sex
Local $source
Local $status
Local $storage
Local $sTake_over_date
Local $sV_type
Local $sUnsubscribe_all_date
Local $sUnsubscribe_call_date
Local $sUnsubscribe_email_date
Local $sUnsubscribe_sms_date
Local $sWork_order
Local $iAccountId
Local $sAccountCreated_at
Local $sAccountUpdated_at
Local $iAccountPartner_id
Local $bAccountActivity_report
Local $bAccountCommercial
Local $bAccountEvent
Local $bAccountLeadxpress
Local $bAccountLoyalty
Local $bAccountPhone_up
Local $bAccountRenewal
Local $bAccountSale_table
Local $bAccountService
Local $bAccountWalk_in
Local $bAccountWebboost
Local $bAccountAccount_manager
Local $sAccountActivation_date
Local $bAccountActive
Local $bAccountAssigned_lead
Local $bAccountAuto_renewal
Local $bAccountAuto_renewal_new
Local $bAccountAuto_renewal_used
Local $bAccountAutomation
Local $bAccountBdc_advisor
Local $bAccountCalendar_options
Local $bAccountClient_card_fieldsProcessGas
Local $bAccountClient_card_fieldsProcessRecorded
Local $bAccountClient_card_fieldsProcessAvailable
Local $bAccountClient_card_fieldsProcessDiscounted
Local $bAccountClient_card_fieldsCommercialProfit
Local $bAccountClient_card_fieldsCommercialExclude
Local $bAccountClient_card_fieldsCommercialMeeting
Local $bAccountClient_card_fieldsPerformanceDeposit
Local $bAccountClient_card_fieldsPerformanceRefinanced
Local $bAccountClient_card_fieldsPerformanceDealer_tour
Local $bAccountClient_card_fieldsPerformanceWalk_around
Local $bAccountClient_card_fieldsPerformanceQualification
Local $bAccountClient_card_fieldsPerformanceTwenty_four_hour
Local $bAccountClient_card_fieldsGeneral_infoBudget
Local $bAccountClient_card_fieldsGeneral_infoSector
Local $bAccountClient_card_fieldsGeneral_infoCustom_1
Local $bAccountClient_card_fieldsGeneral_infoCustom_2
Local $bAccountClient_card_fieldsGeneral_infoCustom_3
Local $bAccountClient_card_fieldsGeneral_infoCustom_4
Local $bAccountClient_card_fieldsGeneral_infoCustom_5
Local $bAccountClient_card_fieldsGeneral_infoCustom_6
Local $bAccountClient_card_fieldsGeneral_infoCustom_7
Local $bAccountClient_card_fieldsGeneral_infoCustom_8
Local $bAccountClient_card_fieldsGeneral_infoCustom_9
Local $bAccountClient_card_fieldsGeneral_infoCustom_10
Local $bAccountClient_card_fieldsGeneral_infoCommunication_preference
Local $bAccountClient_card_fieldsWanted_vehicleVin
Local $bAccountClient_card_fieldsWanted_vehicleFuel
Local $bAccountClient_card_fieldsWanted_vehicleRate
Local $bAccountClient_card_fieldsWanted_vehicleTerm
Local $bAccountClient_card_fieldsWanted_vehicleTire
Local $bAccountClient_card_fieldsWanted_vehicleYear
Local $bAccountClient_card_fieldsWanted_vehicleColor
Local $bAccountClient_card_fieldsWanted_vehiclePrice
Local $bAccountClient_card_fieldsWanted_vehicleStock
Local $bAccountClient_card_fieldsWanted_vehicleTotal
Local $bAccountClient_card_fieldsWanted_vehicleBudget
Local $bAccountClient_card_fieldsWanted_vehicleEngine
Local $bAccountClient_card_fieldsWanted_vehicleLength
Local $bAccountClient_card_fieldsWanted_vehicleProfit
Local $bAccountClient_card_fieldsWanted_vehicleSuffix
Local $bAccountClient_card_fieldsWanted_vehicleWeight
Local $bAccountClient_card_fieldsWanted_vehicleComment
Local $bAccountClient_card_fieldsWanted_vehicleMileage
Local $bAccountClient_card_fieldsWanted_vehiclePayment
Local $bAccountClient_card_fieldsWanted_vehicleBodyType
Local $bAccountClient_card_fieldsWanted_vehicleCategory
Local $bAccountClient_card_fieldsWanted_vehicleModality
Local $bAccountClient_card_fieldsWanted_vehicleResidual
Local $bAccountClient_card_fieldsWanted_vehicleSleeping
Local $bAccountClient_card_fieldsWanted_vehicleWarranty
Local $bAccountClient_card_fieldsWanted_vehicleFrequency
Local $bAccountClient_card_fieldsWanted_vehicleAccessories
Local $bAccountClient_card_fieldsWanted_vehicleCategory_rv
Local $bAccountClient_card_fieldsWanted_vehiclePreparation
Local $bAccountClient_card_fieldsWanted_vehicleInitial_cash
Local $bAccountClient_card_fieldsWanted_vehicleOffer_number
Local $bAccountClient_card_fieldsWanted_vehicleOrder_number
Local $bAccountClient_card_fieldsWanted_vehicleTransmission
Local $bAccountClient_card_fieldsWanted_vehicleDocumentation
Local $bAccountClient_card_fieldsWanted_vehicleDrivingWheels
Local $bAccountClient_card_fieldsWanted_vehicleColor_exterior
Local $bAccountClient_card_fieldsWanted_vehicleColor_interior
Local $bAccountClient_card_fieldsWanted_vehicleAllowed_mileage
Local $bAccountClient_card_fieldsWanted_vehicleSecurity_deposit
Local $bAccountClient_card_fieldsWanted_vehicleEnd_contract_date
Local $bAccountClient_card_fieldsExchange_vehicleVin
Local $bAccountClient_card_fieldsExchange_vehicleFuel
Local $bAccountClient_card_fieldsExchange_vehicleLink
Local $bAccountClient_card_fieldsExchange_vehicleRate
Local $bAccountClient_card_fieldsExchange_vehicleTerm
Local $bAccountClient_card_fieldsExchange_vehicleYear
Local $bAccountClient_card_fieldsExchange_vehicleColor
Local $bAccountClient_card_fieldsExchange_vehiclePrice
Local $bAccountClient_card_fieldsExchange_vehicleStock
Local $bAccountClient_card_fieldsExchange_vehicleValue
Local $bAccountClient_card_fieldsExchange_vehicleBudget
Local $bAccountClient_card_fieldsExchange_vehicleEngine
Local $bAccountClient_card_fieldsExchange_vehicleLength
Local $bAccountClient_card_fieldsExchange_vehicleProfit
Local $bAccountClient_card_fieldsExchange_vehicleSuffix
Local $bAccountClient_card_fieldsExchange_vehicleWeight
Local $bAccountClient_card_fieldsExchange_vehicleBalance
Local $bAccountClient_card_fieldsExchange_vehicleComment
Local $bAccountClient_card_fieldsExchange_vehicleMileage
Local $bAccountClient_card_fieldsExchange_vehiclePayment
Local $bAccountClient_card_fieldsExchange_vehicleRenewal
Local $bAccountClient_card_fieldsExchange_vehicleSold_by
Local $bAccountClient_card_fieldsExchange_vehicleBodyType
Local $bAccountClient_card_fieldsExchange_vehicleCategory
Local $bAccountClient_card_fieldsExchange_vehicleModality
Local $bAccountClient_card_fieldsExchange_vehicleResidual
Local $bAccountClient_card_fieldsExchange_vehicleSleeping
Local $bAccountClient_card_fieldsExchange_vehicleWarranty
Local $bAccountClient_card_fieldsExchange_vehicleCondition
Local $bAccountClient_card_fieldsExchange_vehicleFrequency
Local $bAccountClient_card_fieldsExchange_vehicleIntention
Local $bAccountClient_card_fieldsExchange_vehicleRefinance
Local $bAccountClient_card_fieldsExchange_vehicleRequested
Local $bAccountClient_card_fieldsExchange_vehicleSold_date
Local $bAccountClient_card_fieldsExchange_vehicleCategory_rv
Local $bAccountClient_card_fieldsExchange_vehicleInstitution
Local $bAccountClient_card_fieldsExchange_vehicleInitial_cash
Local $bAccountClient_card_fieldsExchange_vehicleOffer_number
Local $bAccountClient_card_fieldsExchange_vehicleTransmission
Local $bAccountClient_card_fieldsExchange_vehicleDrivingWheels
Local $bAccountClient_card_fieldsExchange_vehicleColor_exterior
Local $bAccountClient_card_fieldsExchange_vehicleColor_interior
Local $bAccountClient_card_fieldsExchange_vehicleAllowed_mileage
Local $bAccountClient_card_fieldsExchange_vehicleSecurity_deposit
Local $bAccountClient_card_fieldsExchange_vehicleEnd_contract_date
Local $bAccountClient_number
Local $bAccountConfirmation_appt
Local $bAccountCredit
Local $bAccountCsi
Local $bAccountCsi_used
Local $sAccountDefault_deliveryman_user_id
Local $bAccountDelivered_by
Local $bAccountDisable_communication_audio
Local $bAccountDuplicates
Local $bAccountGuest_action
Local $bAccountEmail_client
Local $bAccountIn_turn
Local $bAccountIn_turn_director_management
Local $bAccountLeads_other_division
Local $iAccountLeadxpress_optionPriority
Local $iAccountLeadxpress_optionReminderFrequency
Local $iAccountLeadxpress_optionReminderRecurrence
Local $bAccountLeadxpress_optionScheduleAccount
Local $bAccountLeadxpress_optionScheduleAdvisor
Local $bAccountLimited_audio_access
Local $sAccountLogo
Local $sAccountLogo_en
Local $bAccountMandatory_coordinate
Local $bAccountManually_status
Local $sAccountMerge_rule
Local $iAccountMonth_start_day
Local $sAccountName
Local $bAccountNiotext
Local $bAccountNiotext_phone
Local $sAccountPhone
Local $bAccountPower_sport
Local $bAccountProcess
Local $bAccountRecreative_special
Local $bAccountResult_date_validation
Local $bAccountSale_accessories
Local $bAccountSale_by_phone
Local $bAccountSale_date_month
Local $bAccountSale_table_optionsAccessory_column
Local $bAccountSale_table_optionsCommercial_column
Local $bAccountSale_table_optionsDivision_grouped_total_column
Local $bAccountSale_validation
Local $bAccountScan
Local $bAccountStock_required_for_sale
Local $bAccountTake_over_director
Local $bAccountTrade_report
Local $bAccountUnrestricted_assignment
Local $bAccountUnsubscribe
Local $bAccountUntreated_lead
Local $bAccountVehicle_model_text
Local $bAccountVehicle_text
Local $bAccountVerified_sale
Local $bAccountVin_decoder
Local $sAccountWaiting_sale_date
Local $bAccountWaiting_sale_option
Local $sAdvisor
Local $iJ
Local $iCount_j
Local $iLead_id
Local $sAddress
Local $bValid
Local $sExtension
Local $sNumber
Local $bValidated
Local $bMobile
Local $sAccessories
Local $sAllowed_odometer
Local $iBalance
Local $sBudget_max
Local $sBudget_min
Local $sCash_down
Local $sCategory
Local $sCategory_rv
Local $sClient_number
Local $sColor_exterior
Local $sColor_interior
Local $sComment
Local $sCondition
Local $sEnd_contract_date
Local $sEnd_warranty_date
Local $sEngine
Local $sExtended_warranty
Local $sFuel
Local $sLength_max
Local $sLength_min
Local $sLicense_plate
Local $sMake
Local $sModality
Local $sModel
Local $sOdometer
Local $sOffer_number
Local $sV_option
Local $sOrder_number
Local $sPayment
Local $sPayment_frequency
Local $sPreparation
Local $sPrice
Local $sProfit
Local $sPurchase_date
Local $sRate
Local $sRecall
Local $sRecorded_date
Local $sResidual
Local $security_deposit
Local $sleeping
Local $bSold
Local $sold_by
Local $sold_date
Local $stock
Local $stock_state
Local $sTerm
Local $bTire
Local $sTransmission
Local $sTrim
Local $sUrl
Local $sValue
Local $sVin
Local $sWarranty
Local $sWeight
Local $sYear
Local $sYear_max
Local $sYear_min

$sLinksFirst = $oJsonResponse.StringOf("links.first")
$sLinksLast = $oJsonResponse.StringOf("links.last")
$sLinksPrev = $oJsonResponse.StringOf("links.prev")
$sLinksNext = $oJsonResponse.StringOf("links.next")
$iMetaCurrent_page = $oJsonResponse.IntOf("meta.current_page")
$iMetaFrom = $oJsonResponse.IntOf("meta.from")
$iMetaLast_page = $oJsonResponse.IntOf("meta.last_page")
$sMetaPath = $oJsonResponse.StringOf("meta.path")
$iMetaPer_page = $oJsonResponse.IntOf("meta.per_page")
$iMetaTo = $oJsonResponse.IntOf("meta.to")
$iMetaTotal = $oJsonResponse.IntOf("meta.total")
$i = 0
$iCount_i = $oJsonResponse.SizeOfArray("data")
While $i < $iCount_i
    $oJsonResponse.I = $i
    $id = $oJsonResponse.IntOf("data[i].id")
    $sCreated_at = $oJsonResponse.StringOf("data[i].created_at")
    $sUpdated_at = $oJsonResponse.StringOf("data[i].updated_at")
    $iAccount_id = $oJsonResponse.IntOf("data[i].account_id")
    $sAddress_line1 = $oJsonResponse.StringOf("data[i].address_line1")
    $sAddress_line2 = $oJsonResponse.StringOf("data[i].address_line2")
    $sAppointment_date = $oJsonResponse.StringOf("data[i].appointment_date")
    $bAppt_call = $oJsonResponse.BoolOf("data[i].appt_call")
    $sAvailable_date = $oJsonResponse.StringOf("data[i].available_date")
    $sAverage_spending = $oJsonResponse.StringOf("data[i].average_spending")
    $sBe_back_date = $oJsonResponse.StringOf("data[i].be_back_date")
    $sBirth_date = $oJsonResponse.StringOf("data[i].birth_date")
    $sBusiness = $oJsonResponse.StringOf("data[i].business")
    $sCall_date = $oJsonResponse.StringOf("data[i].call_date")
    $sCity = $oJsonResponse.StringOf("data[i].city")
    $sCivility = $oJsonResponse.StringOf("data[i].civility")
    $sCode = $oJsonResponse.StringOf("data[i].code")
    $sCountry = $oJsonResponse.StringOf("data[i].country")
    $sCsi_date = $oJsonResponse.StringOf("data[i].csi_date")
    $sDelivered_by_id = $oJsonResponse.StringOf("data[i].delivered_by_id")
    $sDelivered_date = $oJsonResponse.StringOf("data[i].delivered_date")
    $sDelivery_date = $oJsonResponse.StringOf("data[i].delivery_date")
    $sDivision = $oJsonResponse.StringOf("data[i].division")
    $sEnd_service_date = $oJsonResponse.StringOf("data[i].end_service_date")
    $sFirst_name = $oJsonResponse.StringOf("data[i].first_name")
    $sGas = $oJsonResponse.StringOf("data[i].gas")
    $iGender = $oJsonResponse.IntOf("data[i].gender")
    $bInvoiced = $oJsonResponse.BoolOf("data[i].invoiced")
    $sLast_name = $oJsonResponse.StringOf("data[i].last_name")
    $sLast_visit_date = $oJsonResponse.StringOf("data[i].last_visit_date")
    $sLocale = $oJsonResponse.StringOf("data[i].locale")
    $sLoyalty = $oJsonResponse.StringOf("data[i].loyalty")
    $sNext_visit_date = $oJsonResponse.StringOf("data[i].next_visit_date")
    $sOdometer_last_visit = $oJsonResponse.StringOf("data[i].odometer_last_visit")
    $sOpen_work_order_date = $oJsonResponse.StringOf("data[i].open_work_order_date")
    $sPlanned_pick_up_date = $oJsonResponse.StringOf("data[i].planned_pick_up_date")
    $sPostal_code = $oJsonResponse.StringOf("data[i].postal_code")
    $sPrepaid = $oJsonResponse.StringOf("data[i].prepaid")
    $bPrepared = $oJsonResponse.BoolOf("data[i].prepared")
    $sPresented_date = $oJsonResponse.StringOf("data[i].presented_date")
    $sPromised_date = $oJsonResponse.StringOf("data[i].promised_date")
    $sProvince = $oJsonResponse.StringOf("data[i].province")
    $sRating = $oJsonResponse.StringOf("data[i].rating")
    $bReached_client = $oJsonResponse.BoolOf("data[i].reached_client")
    $sRefinanced_date = $oJsonResponse.StringOf("data[i].refinanced_date")
    $sRepair_date = $oJsonResponse.StringOf("data[i].repair_date")
    $sRepair_order = $oJsonResponse.StringOf("data[i].repair_order")
    $sResult = $oJsonResponse.StringOf("data[i].result")
    $sRoad_test_date = $oJsonResponse.StringOf("data[i].road_test_date")
    $sale_date = $oJsonResponse.StringOf("data[i].sale_date")
    $second_contact = $oJsonResponse.StringOf("data[i].second_contact")
    $second_contact_civility = $oJsonResponse.StringOf("data[i].second_contact_civility")
    $segment = $oJsonResponse.StringOf("data[i].segment")
    $bService_cleaned = $oJsonResponse.BoolOf("data[i].service_cleaned")
    $service_interval_km = $oJsonResponse.StringOf("data[i].service_interval_km")
    $service_monthly_km = $oJsonResponse.StringOf("data[i].service_monthly_km")
    $service_processIntention = $oJsonResponse.StringOf("data[i].service_process.intention")
    $service_processTransport = $oJsonResponse.StringOf("data[i].service_process.transport")
    $service_processWalk_around = $oJsonResponse.StringOf("data[i].service_process.walk_around")
    $sex = $oJsonResponse.StringOf("data[i].sex")
    $source = $oJsonResponse.StringOf("data[i].source")
    $status = $oJsonResponse.StringOf("data[i].status")
    $storage = $oJsonResponse.StringOf("data[i].storage")
    $sTake_over_date = $oJsonResponse.StringOf("data[i].take_over_date")
    $sV_type = $oJsonResponse.StringOf("data[i].type")
    $sUnsubscribe_all_date = $oJsonResponse.StringOf("data[i].unsubscribe_all_date")
    $sUnsubscribe_call_date = $oJsonResponse.StringOf("data[i].unsubscribe_call_date")
    $sUnsubscribe_email_date = $oJsonResponse.StringOf("data[i].unsubscribe_email_date")
    $sUnsubscribe_sms_date = $oJsonResponse.StringOf("data[i].unsubscribe_sms_date")
    $sWork_order = $oJsonResponse.StringOf("data[i].work_order")
    $iAccountId = $oJsonResponse.IntOf("data[i].account.id")
    $sAccountCreated_at = $oJsonResponse.StringOf("data[i].account.created_at")
    $sAccountUpdated_at = $oJsonResponse.StringOf("data[i].account.updated_at")
    $iAccountPartner_id = $oJsonResponse.IntOf("data[i].account.partner_id")
    $bAccountActivity_report = $oJsonResponse.BoolOf("data[i].account.activity_report")
    $bAccountCommercial = $oJsonResponse.BoolOf("data[i].account.commercial")
    $bAccountEvent = $oJsonResponse.BoolOf("data[i].account.event")
    $bAccountLeadxpress = $oJsonResponse.BoolOf("data[i].account.leadxpress")
    $bAccountLoyalty = $oJsonResponse.BoolOf("data[i].account.loyalty")
    $bAccountPhone_up = $oJsonResponse.BoolOf("data[i].account.phone_up")
    $bAccountRenewal = $oJsonResponse.BoolOf("data[i].account.renewal")
    $bAccountSale_table = $oJsonResponse.BoolOf("data[i].account.sale_table")
    $bAccountService = $oJsonResponse.BoolOf("data[i].account.service")
    $bAccountWalk_in = $oJsonResponse.BoolOf("data[i].account.walk_in")
    $bAccountWebboost = $oJsonResponse.BoolOf("data[i].account.webboost")
    $bAccountAccount_manager = $oJsonResponse.BoolOf("data[i].account.account_manager")
    $sAccountActivation_date = $oJsonResponse.StringOf("data[i].account.activation_date")
    $bAccountActive = $oJsonResponse.BoolOf("data[i].account.active")
    $bAccountAssigned_lead = $oJsonResponse.BoolOf("data[i].account.assigned_lead")
    $bAccountAuto_renewal = $oJsonResponse.BoolOf("data[i].account.auto_renewal")
    $bAccountAuto_renewal_new = $oJsonResponse.BoolOf("data[i].account.auto_renewal_new")
    $bAccountAuto_renewal_used = $oJsonResponse.BoolOf("data[i].account.auto_renewal_used")
    $bAccountAutomation = $oJsonResponse.BoolOf("data[i].account.automation")
    $bAccountBdc_advisor = $oJsonResponse.BoolOf("data[i].account.bdc_advisor")
    $bAccountCalendar_options = $oJsonResponse.BoolOf("data[i].account.calendar_options")
    $bAccountClient_card_fieldsProcessGas = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.gas")
    $bAccountClient_card_fieldsProcessRecorded = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded")
    $bAccountClient_card_fieldsProcessAvailable = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.available")
    $bAccountClient_card_fieldsProcessDiscounted = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted")
    $bAccountClient_card_fieldsCommercialProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit")
    $bAccountClient_card_fieldsCommercialExclude = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude")
    $bAccountClient_card_fieldsCommercialMeeting = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting")
    $bAccountClient_card_fieldsPerformanceDeposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit")
    $bAccountClient_card_fieldsPerformanceRefinanced = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced")
    $bAccountClient_card_fieldsPerformanceDealer_tour = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour")
    $bAccountClient_card_fieldsPerformanceWalk_around = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around")
    $bAccountClient_card_fieldsPerformanceQualification = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification")
    $bAccountClient_card_fieldsPerformanceTwenty_four_hour = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour")
    $bAccountClient_card_fieldsGeneral_infoBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget")
    $bAccountClient_card_fieldsGeneral_infoSector = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector")
    $bAccountClient_card_fieldsGeneral_infoCustom_1 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1")
    $bAccountClient_card_fieldsGeneral_infoCustom_2 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2")
    $bAccountClient_card_fieldsGeneral_infoCustom_3 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3")
    $bAccountClient_card_fieldsGeneral_infoCustom_4 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4")
    $bAccountClient_card_fieldsGeneral_infoCustom_5 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5")
    $bAccountClient_card_fieldsGeneral_infoCustom_6 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6")
    $bAccountClient_card_fieldsGeneral_infoCustom_7 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7")
    $bAccountClient_card_fieldsGeneral_infoCustom_8 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8")
    $bAccountClient_card_fieldsGeneral_infoCustom_9 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9")
    $bAccountClient_card_fieldsGeneral_infoCustom_10 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10")
    $bAccountClient_card_fieldsGeneral_infoCommunication_preference = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference")
    $bAccountClient_card_fieldsWanted_vehicleVin = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin")
    $bAccountClient_card_fieldsWanted_vehicleFuel = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel")
    $bAccountClient_card_fieldsWanted_vehicleRate = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate")
    $bAccountClient_card_fieldsWanted_vehicleTerm = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term")
    $bAccountClient_card_fieldsWanted_vehicleTire = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire")
    $bAccountClient_card_fieldsWanted_vehicleYear = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year")
    $bAccountClient_card_fieldsWanted_vehicleColor = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color")
    $bAccountClient_card_fieldsWanted_vehiclePrice = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price")
    $bAccountClient_card_fieldsWanted_vehicleStock = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock")
    $bAccountClient_card_fieldsWanted_vehicleTotal = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total")
    $bAccountClient_card_fieldsWanted_vehicleBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget")
    $bAccountClient_card_fieldsWanted_vehicleEngine = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine")
    $bAccountClient_card_fieldsWanted_vehicleLength = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length")
    $bAccountClient_card_fieldsWanted_vehicleProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit")
    $bAccountClient_card_fieldsWanted_vehicleSuffix = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix")
    $bAccountClient_card_fieldsWanted_vehicleWeight = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight")
    $bAccountClient_card_fieldsWanted_vehicleComment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment")
    $bAccountClient_card_fieldsWanted_vehicleMileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage")
    $bAccountClient_card_fieldsWanted_vehiclePayment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment")
    $bAccountClient_card_fieldsWanted_vehicleBodyType = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType")
    $bAccountClient_card_fieldsWanted_vehicleCategory = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category")
    $bAccountClient_card_fieldsWanted_vehicleModality = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality")
    $bAccountClient_card_fieldsWanted_vehicleResidual = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual")
    $bAccountClient_card_fieldsWanted_vehicleSleeping = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping")
    $bAccountClient_card_fieldsWanted_vehicleWarranty = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty")
    $bAccountClient_card_fieldsWanted_vehicleFrequency = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency")
    $bAccountClient_card_fieldsWanted_vehicleAccessories = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories")
    $bAccountClient_card_fieldsWanted_vehicleCategory_rv = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv")
    $bAccountClient_card_fieldsWanted_vehiclePreparation = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation")
    $bAccountClient_card_fieldsWanted_vehicleInitial_cash = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash")
    $bAccountClient_card_fieldsWanted_vehicleOffer_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number")
    $bAccountClient_card_fieldsWanted_vehicleOrder_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number")
    $bAccountClient_card_fieldsWanted_vehicleTransmission = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission")
    $bAccountClient_card_fieldsWanted_vehicleDocumentation = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation")
    $bAccountClient_card_fieldsWanted_vehicleDrivingWheels = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels")
    $bAccountClient_card_fieldsWanted_vehicleColor_exterior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior")
    $bAccountClient_card_fieldsWanted_vehicleColor_interior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior")
    $bAccountClient_card_fieldsWanted_vehicleAllowed_mileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage")
    $bAccountClient_card_fieldsWanted_vehicleSecurity_deposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit")
    $bAccountClient_card_fieldsWanted_vehicleEnd_contract_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date")
    $bAccountClient_card_fieldsExchange_vehicleVin = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin")
    $bAccountClient_card_fieldsExchange_vehicleFuel = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel")
    $bAccountClient_card_fieldsExchange_vehicleLink = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link")
    $bAccountClient_card_fieldsExchange_vehicleRate = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate")
    $bAccountClient_card_fieldsExchange_vehicleTerm = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term")
    $bAccountClient_card_fieldsExchange_vehicleYear = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year")
    $bAccountClient_card_fieldsExchange_vehicleColor = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color")
    $bAccountClient_card_fieldsExchange_vehiclePrice = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price")
    $bAccountClient_card_fieldsExchange_vehicleStock = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock")
    $bAccountClient_card_fieldsExchange_vehicleValue = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value")
    $bAccountClient_card_fieldsExchange_vehicleBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget")
    $bAccountClient_card_fieldsExchange_vehicleEngine = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine")
    $bAccountClient_card_fieldsExchange_vehicleLength = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length")
    $bAccountClient_card_fieldsExchange_vehicleProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit")
    $bAccountClient_card_fieldsExchange_vehicleSuffix = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix")
    $bAccountClient_card_fieldsExchange_vehicleWeight = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight")
    $bAccountClient_card_fieldsExchange_vehicleBalance = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance")
    $bAccountClient_card_fieldsExchange_vehicleComment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment")
    $bAccountClient_card_fieldsExchange_vehicleMileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage")
    $bAccountClient_card_fieldsExchange_vehiclePayment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment")
    $bAccountClient_card_fieldsExchange_vehicleRenewal = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal")
    $bAccountClient_card_fieldsExchange_vehicleSold_by = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by")
    $bAccountClient_card_fieldsExchange_vehicleBodyType = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType")
    $bAccountClient_card_fieldsExchange_vehicleCategory = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category")
    $bAccountClient_card_fieldsExchange_vehicleModality = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality")
    $bAccountClient_card_fieldsExchange_vehicleResidual = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual")
    $bAccountClient_card_fieldsExchange_vehicleSleeping = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping")
    $bAccountClient_card_fieldsExchange_vehicleWarranty = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty")
    $bAccountClient_card_fieldsExchange_vehicleCondition = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition")
    $bAccountClient_card_fieldsExchange_vehicleFrequency = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency")
    $bAccountClient_card_fieldsExchange_vehicleIntention = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention")
    $bAccountClient_card_fieldsExchange_vehicleRefinance = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance")
    $bAccountClient_card_fieldsExchange_vehicleRequested = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested")
    $bAccountClient_card_fieldsExchange_vehicleSold_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date")
    $bAccountClient_card_fieldsExchange_vehicleCategory_rv = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv")
    $bAccountClient_card_fieldsExchange_vehicleInstitution = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution")
    $bAccountClient_card_fieldsExchange_vehicleInitial_cash = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash")
    $bAccountClient_card_fieldsExchange_vehicleOffer_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number")
    $bAccountClient_card_fieldsExchange_vehicleTransmission = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission")
    $bAccountClient_card_fieldsExchange_vehicleDrivingWheels = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels")
    $bAccountClient_card_fieldsExchange_vehicleColor_exterior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior")
    $bAccountClient_card_fieldsExchange_vehicleColor_interior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior")
    $bAccountClient_card_fieldsExchange_vehicleAllowed_mileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage")
    $bAccountClient_card_fieldsExchange_vehicleSecurity_deposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit")
    $bAccountClient_card_fieldsExchange_vehicleEnd_contract_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date")
    $bAccountClient_number = $oJsonResponse.BoolOf("data[i].account.client_number")
    $bAccountConfirmation_appt = $oJsonResponse.BoolOf("data[i].account.confirmation_appt")
    $bAccountCredit = $oJsonResponse.BoolOf("data[i].account.credit")
    $bAccountCsi = $oJsonResponse.BoolOf("data[i].account.csi")
    $bAccountCsi_used = $oJsonResponse.BoolOf("data[i].account.csi_used")
    $sAccountDefault_deliveryman_user_id = $oJsonResponse.StringOf("data[i].account.default_deliveryman_user_id")
    $bAccountDelivered_by = $oJsonResponse.BoolOf("data[i].account.delivered_by")
    $bAccountDisable_communication_audio = $oJsonResponse.BoolOf("data[i].account.disable_communication_audio")
    $bAccountDuplicates = $oJsonResponse.BoolOf("data[i].account.duplicates")
    $bAccountGuest_action = $oJsonResponse.BoolOf("data[i].account.guest_action")
    $bAccountEmail_client = $oJsonResponse.BoolOf("data[i].account.email_client")
    $bAccountIn_turn = $oJsonResponse.BoolOf("data[i].account.in_turn")
    $bAccountIn_turn_director_management = $oJsonResponse.BoolOf("data[i].account.in_turn_director_management")
    $bAccountLeads_other_division = $oJsonResponse.BoolOf("data[i].account.leads_other_division")
    $iAccountLeadxpress_optionPriority = $oJsonResponse.IntOf("data[i].account.leadxpress_option.priority")
    $iAccountLeadxpress_optionReminderFrequency = $oJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency")
    $iAccountLeadxpress_optionReminderRecurrence = $oJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence")
    $bAccountLeadxpress_optionScheduleAccount = $oJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account")
    $bAccountLeadxpress_optionScheduleAdvisor = $oJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor")
    $bAccountLimited_audio_access = $oJsonResponse.BoolOf("data[i].account.limited_audio_access")
    $sAccountLogo = $oJsonResponse.StringOf("data[i].account.logo")
    $sAccountLogo_en = $oJsonResponse.StringOf("data[i].account.logo_en")
    $bAccountMandatory_coordinate = $oJsonResponse.BoolOf("data[i].account.mandatory_coordinate")
    $bAccountManually_status = $oJsonResponse.BoolOf("data[i].account.manually_status")
    $sAccountMerge_rule = $oJsonResponse.StringOf("data[i].account.merge_rule")
    $iAccountMonth_start_day = $oJsonResponse.IntOf("data[i].account.month_start_day")
    $sAccountName = $oJsonResponse.StringOf("data[i].account.name")
    $bAccountNiotext = $oJsonResponse.BoolOf("data[i].account.niotext")
    $bAccountNiotext_phone = $oJsonResponse.BoolOf("data[i].account.niotext_phone")
    $sAccountPhone = $oJsonResponse.StringOf("data[i].account.phone")
    $bAccountPower_sport = $oJsonResponse.BoolOf("data[i].account.power_sport")
    $bAccountProcess = $oJsonResponse.BoolOf("data[i].account.process")
    $bAccountRecreative_special = $oJsonResponse.BoolOf("data[i].account.recreative_special")
    $bAccountResult_date_validation = $oJsonResponse.BoolOf("data[i].account.result_date_validation")
    $bAccountSale_accessories = $oJsonResponse.BoolOf("data[i].account.sale_accessories")
    $bAccountSale_by_phone = $oJsonResponse.BoolOf("data[i].account.sale_by_phone")
    $bAccountSale_date_month = $oJsonResponse.BoolOf("data[i].account.sale_date_month")
    $bAccountSale_table_optionsAccessory_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column")
    $bAccountSale_table_optionsCommercial_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column")
    $bAccountSale_table_optionsDivision_grouped_total_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column")
    $bAccountSale_validation = $oJsonResponse.BoolOf("data[i].account.sale_validation")
    $bAccountScan = $oJsonResponse.BoolOf("data[i].account.scan")
    $bAccountStock_required_for_sale = $oJsonResponse.BoolOf("data[i].account.stock_required_for_sale")
    $bAccountTake_over_director = $oJsonResponse.BoolOf("data[i].account.take_over_director")
    $bAccountTrade_report = $oJsonResponse.BoolOf("data[i].account.trade_report")
    $bAccountUnrestricted_assignment = $oJsonResponse.BoolOf("data[i].account.unrestricted_assignment")
    $bAccountUnsubscribe = $oJsonResponse.BoolOf("data[i].account.unsubscribe")
    $bAccountUntreated_lead = $oJsonResponse.BoolOf("data[i].account.untreated_lead")
    $bAccountVehicle_model_text = $oJsonResponse.BoolOf("data[i].account.vehicle_model_text")
    $bAccountVehicle_text = $oJsonResponse.BoolOf("data[i].account.vehicle_text")
    $bAccountVerified_sale = $oJsonResponse.BoolOf("data[i].account.verified_sale")
    $bAccountVin_decoder = $oJsonResponse.BoolOf("data[i].account.vin_decoder")
    $sAccountWaiting_sale_date = $oJsonResponse.StringOf("data[i].account.waiting_sale_date")
    $bAccountWaiting_sale_option = $oJsonResponse.BoolOf("data[i].account.waiting_sale_option")
    $sAdvisor = $oJsonResponse.StringOf("data[i].advisor")
    $iJ = 0
    $iCount_j = $oJsonResponse.SizeOfArray("data[i].emails")
    While $iJ < $iCount_j
        $oJsonResponse.J = $iJ
        $id = $oJsonResponse.IntOf("data[i].emails[j].id")
        $sCreated_at = $oJsonResponse.StringOf("data[i].emails[j].created_at")
        $sUpdated_at = $oJsonResponse.StringOf("data[i].emails[j].updated_at")
        $iLead_id = $oJsonResponse.IntOf("data[i].emails[j].lead_id")
        $sAddress = $oJsonResponse.StringOf("data[i].emails[j].address")
        $sV_type = $oJsonResponse.StringOf("data[i].emails[j].type")
        $bValid = $oJsonResponse.BoolOf("data[i].emails[j].valid")
        $iJ = $iJ + 1
    Wend
    $iJ = 0
    $iCount_j = $oJsonResponse.SizeOfArray("data[i].phones")
    While $iJ < $iCount_j
        $oJsonResponse.J = $iJ
        $id = $oJsonResponse.IntOf("data[i].phones[j].id")
        $sCreated_at = $oJsonResponse.StringOf("data[i].phones[j].created_at")
        $sUpdated_at = $oJsonResponse.StringOf("data[i].phones[j].updated_at")
        $iLead_id = $oJsonResponse.IntOf("data[i].phones[j].lead_id")
        $sExtension = $oJsonResponse.StringOf("data[i].phones[j].extension")
        $sNumber = $oJsonResponse.StringOf("data[i].phones[j].number")
        $sV_type = $oJsonResponse.StringOf("data[i].phones[j].type")
        $bValid = $oJsonResponse.BoolOf("data[i].phones[j].valid")
        $bValidated = $oJsonResponse.BoolOf("data[i].phones[j].validated")
        $bMobile = $oJsonResponse.BoolOf("data[i].phones[j].mobile")
        $iJ = $iJ + 1
    Wend
    $iJ = 0
    $iCount_j = $oJsonResponse.SizeOfArray("data[i].vehicles")
    While $iJ < $iCount_j
        $oJsonResponse.J = $iJ
        $id = $oJsonResponse.IntOf("data[i].vehicles[j].id")
        $sCreated_at = $oJsonResponse.StringOf("data[i].vehicles[j].created_at")
        $sUpdated_at = $oJsonResponse.StringOf("data[i].vehicles[j].updated_at")
        $iLead_id = $oJsonResponse.IntOf("data[i].vehicles[j].lead_id")
        $sAccessories = $oJsonResponse.StringOf("data[i].vehicles[j].accessories")
        $sAllowed_odometer = $oJsonResponse.StringOf("data[i].vehicles[j].allowed_odometer")
        $iBalance = $oJsonResponse.IntOf("data[i].vehicles[j].balance")
        $sBudget_max = $oJsonResponse.StringOf("data[i].vehicles[j].budget_max")
        $sBudget_min = $oJsonResponse.StringOf("data[i].vehicles[j].budget_min")
        $sCash_down = $oJsonResponse.StringOf("data[i].vehicles[j].cash_down")
        $sCategory = $oJsonResponse.StringOf("data[i].vehicles[j].category")
        $sCategory_rv = $oJsonResponse.StringOf("data[i].vehicles[j].category_rv")
        $sClient_number = $oJsonResponse.StringOf("data[i].vehicles[j].client_number")
        $sColor_exterior = $oJsonResponse.StringOf("data[i].vehicles[j].color_exterior")
        $sColor_interior = $oJsonResponse.StringOf("data[i].vehicles[j].color_interior")
        $sComment = $oJsonResponse.StringOf("data[i].vehicles[j].comment")
        $sCondition = $oJsonResponse.StringOf("data[i].vehicles[j].condition")
        $sEnd_contract_date = $oJsonResponse.StringOf("data[i].vehicles[j].end_contract_date")
        $sEnd_warranty_date = $oJsonResponse.StringOf("data[i].vehicles[j].end_warranty_date")
        $sEngine = $oJsonResponse.StringOf("data[i].vehicles[j].engine")
        $sExtended_warranty = $oJsonResponse.StringOf("data[i].vehicles[j].extended_warranty")
        $sFuel = $oJsonResponse.StringOf("data[i].vehicles[j].fuel")
        $sLength_max = $oJsonResponse.StringOf("data[i].vehicles[j].length_max")
        $sLength_min = $oJsonResponse.StringOf("data[i].vehicles[j].length_min")
        $sLicense_plate = $oJsonResponse.StringOf("data[i].vehicles[j].license_plate")
        $sMake = $oJsonResponse.StringOf("data[i].vehicles[j].make")
        $sModality = $oJsonResponse.StringOf("data[i].vehicles[j].modality")
        $sModel = $oJsonResponse.StringOf("data[i].vehicles[j].model")
        $sOdometer = $oJsonResponse.StringOf("data[i].vehicles[j].odometer")
        $sOffer_number = $oJsonResponse.StringOf("data[i].vehicles[j].offer_number")
        $sV_option = $oJsonResponse.StringOf("data[i].vehicles[j].option")
        $sOrder_number = $oJsonResponse.StringOf("data[i].vehicles[j].order_number")
        $sPayment = $oJsonResponse.StringOf("data[i].vehicles[j].payment")
        $sPayment_frequency = $oJsonResponse.StringOf("data[i].vehicles[j].payment_frequency")
        $sPreparation = $oJsonResponse.StringOf("data[i].vehicles[j].preparation")
        $sPrice = $oJsonResponse.StringOf("data[i].vehicles[j].price")
        $sProfit = $oJsonResponse.StringOf("data[i].vehicles[j].profit")
        $sPurchase_date = $oJsonResponse.StringOf("data[i].vehicles[j].purchase_date")
        $sRate = $oJsonResponse.StringOf("data[i].vehicles[j].rate")
        $sRecall = $oJsonResponse.StringOf("data[i].vehicles[j].recall")
        $sRecorded_date = $oJsonResponse.StringOf("data[i].vehicles[j].recorded_date")
        $sResidual = $oJsonResponse.StringOf("data[i].vehicles[j].residual")
        $security_deposit = $oJsonResponse.StringOf("data[i].vehicles[j].security_deposit")
        $sleeping = $oJsonResponse.StringOf("data[i].vehicles[j].sleeping")
        $bSold = $oJsonResponse.BoolOf("data[i].vehicles[j].sold")
        $sold_by = $oJsonResponse.StringOf("data[i].vehicles[j].sold_by")
        $sold_date = $oJsonResponse.StringOf("data[i].vehicles[j].sold_date")
        $stock = $oJsonResponse.StringOf("data[i].vehicles[j].stock")
        $stock_state = $oJsonResponse.StringOf("data[i].vehicles[j].stock_state")
        $sTerm = $oJsonResponse.StringOf("data[i].vehicles[j].term")
        $bTire = $oJsonResponse.BoolOf("data[i].vehicles[j].tire")
        $sTransmission = $oJsonResponse.StringOf("data[i].vehicles[j].transmission")
        $sTrim = $oJsonResponse.StringOf("data[i].vehicles[j].trim")
        $sV_type = $oJsonResponse.StringOf("data[i].vehicles[j].type")
        $sUrl = $oJsonResponse.StringOf("data[i].vehicles[j].url")
        $sValue = $oJsonResponse.StringOf("data[i].vehicles[j].value")
        $sVin = $oJsonResponse.StringOf("data[i].vehicles[j].vin")
        $sWarranty = $oJsonResponse.StringOf("data[i].vehicles[j].warranty")
        $sWeight = $oJsonResponse.StringOf("data[i].vehicles[j].weight")
        $sYear = $oJsonResponse.StringOf("data[i].vehicles[j].year")
        $sYear_max = $oJsonResponse.StringOf("data[i].vehicles[j].year_max")
        $sYear_min = $oJsonResponse.StringOf("data[i].vehicles[j].year_min")
        $iJ = $iJ + 1
    Wend
    $iJ = 0
    $iCount_j = $oJsonResponse.SizeOfArray("data[i].products")
    While $iJ < $iCount_j
        $oJsonResponse.J = $iJ
        $iJ = $iJ + 1
    Wend
    $i = $i + 1
Wend