(VB.NET) 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 .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

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

Dim http As New Chilkat.Http

http.AuthToken = "ACCESS_TOKEN"

http.Accept = "application/json"


Dim strResp As String = http.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe")
If (http.LastMethodSuccess <> True) Then
    Debug.WriteLine(http.LastErrorText)
    Exit Sub
End If


Debug.WriteLine("Response Status Code: " & http.LastStatus)

Dim jsonResponse As New Chilkat.JsonObject
jsonResponse.Load(strResp)
jsonResponse.EmitCompact = False
Debug.WriteLine(jsonResponse.Emit())

If (http.LastStatus <> 200) Then
    Debug.WriteLine("Failed.")
    Exit Sub
End If


' 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
'     }
' }

Dim linksFirst As String
Dim linksLast As String
Dim linksPrev As String
Dim linksNext As String
Dim metaCurrent_page As Integer
Dim metaFrom As Integer
Dim metaLast_page As Integer
Dim metaPath As String
Dim metaPer_page As Integer
Dim metaTo As Integer
Dim metaTotal As Integer
Dim i As Integer
Dim count_i As Integer
Dim id As Integer
Dim created_at As String
Dim updated_at As String
Dim account_id As Integer
Dim address_line1 As String
Dim address_line2 As String
Dim appointment_date As String
Dim appt_call As Boolean
Dim available_date As String
Dim average_spending As String
Dim be_back_date As String
Dim birth_date As String
Dim business As String
Dim call_date As String
Dim city As String
Dim civility As String
Dim code As String
Dim country As String
Dim csi_date As String
Dim delivered_by_id As String
Dim delivered_date As String
Dim delivery_date As String
Dim division As String
Dim end_service_date As String
Dim first_name As String
Dim gas As String
Dim gender As Integer
Dim invoiced As Boolean
Dim last_name As String
Dim last_visit_date As String
Dim locale As String
Dim loyalty As String
Dim next_visit_date As String
Dim odometer_last_visit As String
Dim open_work_order_date As String
Dim planned_pick_up_date As String
Dim postal_code As String
Dim prepaid As String
Dim prepared As Boolean
Dim presented_date As String
Dim promised_date As String
Dim province As String
Dim rating As String
Dim reached_client As Boolean
Dim refinanced_date As String
Dim repair_date As String
Dim repair_order As String
Dim result As String
Dim road_test_date As String
Dim sale_date As String
Dim second_contact As String
Dim second_contact_civility As String
Dim segment As String
Dim service_cleaned As Boolean
Dim service_interval_km As String
Dim service_monthly_km As String
Dim service_processIntention As String
Dim service_processTransport As String
Dim service_processWalk_around As String
Dim sex As String
Dim source As String
Dim status As String
Dim storage As String
Dim take_over_date As String
Dim v_type As String
Dim unsubscribe_all_date As String
Dim unsubscribe_call_date As String
Dim unsubscribe_email_date As String
Dim unsubscribe_sms_date As String
Dim work_order As String
Dim accountId As Integer
Dim accountCreated_at As String
Dim accountUpdated_at As String
Dim accountPartner_id As Integer
Dim accountActivity_report As Boolean
Dim accountCommercial As Boolean
Dim accountEvent As Boolean
Dim accountLeadxpress As Boolean
Dim accountLoyalty As Boolean
Dim accountPhone_up As Boolean
Dim accountRenewal As Boolean
Dim accountSale_table As Boolean
Dim accountService As Boolean
Dim accountWalk_in As Boolean
Dim accountWebboost As Boolean
Dim accountAccount_manager As Boolean
Dim accountActivation_date As String
Dim accountActive As Boolean
Dim accountAssigned_lead As Boolean
Dim accountAuto_renewal As Boolean
Dim accountAuto_renewal_new As Boolean
Dim accountAuto_renewal_used As Boolean
Dim accountAutomation As Boolean
Dim accountBdc_advisor As Boolean
Dim accountCalendar_options As Boolean
Dim accountClient_card_fieldsProcessGas As Boolean
Dim accountClient_card_fieldsProcessRecorded As Boolean
Dim accountClient_card_fieldsProcessAvailable As Boolean
Dim accountClient_card_fieldsProcessDiscounted As Boolean
Dim accountClient_card_fieldsCommercialProfit As Boolean
Dim accountClient_card_fieldsCommercialExclude As Boolean
Dim accountClient_card_fieldsCommercialMeeting As Boolean
Dim accountClient_card_fieldsPerformanceDeposit As Boolean
Dim accountClient_card_fieldsPerformanceRefinanced As Boolean
Dim accountClient_card_fieldsPerformanceDealer_tour As Boolean
Dim accountClient_card_fieldsPerformanceWalk_around As Boolean
Dim accountClient_card_fieldsPerformanceQualification As Boolean
Dim accountClient_card_fieldsPerformanceTwenty_four_hour As Boolean
Dim accountClient_card_fieldsGeneral_infoBudget As Boolean
Dim accountClient_card_fieldsGeneral_infoSector As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_1 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_2 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_3 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_4 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_5 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_6 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_7 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_8 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_9 As Boolean
Dim accountClient_card_fieldsGeneral_infoCustom_10 As Boolean
Dim accountClient_card_fieldsGeneral_infoCommunication_preference As Boolean
Dim accountClient_card_fieldsWanted_vehicleVin As Boolean
Dim accountClient_card_fieldsWanted_vehicleFuel As Boolean
Dim accountClient_card_fieldsWanted_vehicleRate As Boolean
Dim accountClient_card_fieldsWanted_vehicleTerm As Boolean
Dim accountClient_card_fieldsWanted_vehicleTire As Boolean
Dim accountClient_card_fieldsWanted_vehicleYear As Boolean
Dim accountClient_card_fieldsWanted_vehicleColor As Boolean
Dim accountClient_card_fieldsWanted_vehiclePrice As Boolean
Dim accountClient_card_fieldsWanted_vehicleStock As Boolean
Dim accountClient_card_fieldsWanted_vehicleTotal As Boolean
Dim accountClient_card_fieldsWanted_vehicleBudget As Boolean
Dim accountClient_card_fieldsWanted_vehicleEngine As Boolean
Dim accountClient_card_fieldsWanted_vehicleLength As Boolean
Dim accountClient_card_fieldsWanted_vehicleProfit As Boolean
Dim accountClient_card_fieldsWanted_vehicleSuffix As Boolean
Dim accountClient_card_fieldsWanted_vehicleWeight As Boolean
Dim accountClient_card_fieldsWanted_vehicleComment As Boolean
Dim accountClient_card_fieldsWanted_vehicleMileage As Boolean
Dim accountClient_card_fieldsWanted_vehiclePayment As Boolean
Dim accountClient_card_fieldsWanted_vehicleBodyType As Boolean
Dim accountClient_card_fieldsWanted_vehicleCategory As Boolean
Dim accountClient_card_fieldsWanted_vehicleModality As Boolean
Dim accountClient_card_fieldsWanted_vehicleResidual As Boolean
Dim accountClient_card_fieldsWanted_vehicleSleeping As Boolean
Dim accountClient_card_fieldsWanted_vehicleWarranty As Boolean
Dim accountClient_card_fieldsWanted_vehicleFrequency As Boolean
Dim accountClient_card_fieldsWanted_vehicleAccessories As Boolean
Dim accountClient_card_fieldsWanted_vehicleCategory_rv As Boolean
Dim accountClient_card_fieldsWanted_vehiclePreparation As Boolean
Dim accountClient_card_fieldsWanted_vehicleInitial_cash As Boolean
Dim accountClient_card_fieldsWanted_vehicleOffer_number As Boolean
Dim accountClient_card_fieldsWanted_vehicleOrder_number As Boolean
Dim accountClient_card_fieldsWanted_vehicleTransmission As Boolean
Dim accountClient_card_fieldsWanted_vehicleDocumentation As Boolean
Dim accountClient_card_fieldsWanted_vehicleDrivingWheels As Boolean
Dim accountClient_card_fieldsWanted_vehicleColor_exterior As Boolean
Dim accountClient_card_fieldsWanted_vehicleColor_interior As Boolean
Dim accountClient_card_fieldsWanted_vehicleAllowed_mileage As Boolean
Dim accountClient_card_fieldsWanted_vehicleSecurity_deposit As Boolean
Dim accountClient_card_fieldsWanted_vehicleEnd_contract_date As Boolean
Dim accountClient_card_fieldsExchange_vehicleVin As Boolean
Dim accountClient_card_fieldsExchange_vehicleFuel As Boolean
Dim accountClient_card_fieldsExchange_vehicleLink As Boolean
Dim accountClient_card_fieldsExchange_vehicleRate As Boolean
Dim accountClient_card_fieldsExchange_vehicleTerm As Boolean
Dim accountClient_card_fieldsExchange_vehicleYear As Boolean
Dim accountClient_card_fieldsExchange_vehicleColor As Boolean
Dim accountClient_card_fieldsExchange_vehiclePrice As Boolean
Dim accountClient_card_fieldsExchange_vehicleStock As Boolean
Dim accountClient_card_fieldsExchange_vehicleValue As Boolean
Dim accountClient_card_fieldsExchange_vehicleBudget As Boolean
Dim accountClient_card_fieldsExchange_vehicleEngine As Boolean
Dim accountClient_card_fieldsExchange_vehicleLength As Boolean
Dim accountClient_card_fieldsExchange_vehicleProfit As Boolean
Dim accountClient_card_fieldsExchange_vehicleSuffix As Boolean
Dim accountClient_card_fieldsExchange_vehicleWeight As Boolean
Dim accountClient_card_fieldsExchange_vehicleBalance As Boolean
Dim accountClient_card_fieldsExchange_vehicleComment As Boolean
Dim accountClient_card_fieldsExchange_vehicleMileage As Boolean
Dim accountClient_card_fieldsExchange_vehiclePayment As Boolean
Dim accountClient_card_fieldsExchange_vehicleRenewal As Boolean
Dim accountClient_card_fieldsExchange_vehicleSold_by As Boolean
Dim accountClient_card_fieldsExchange_vehicleBodyType As Boolean
Dim accountClient_card_fieldsExchange_vehicleCategory As Boolean
Dim accountClient_card_fieldsExchange_vehicleModality As Boolean
Dim accountClient_card_fieldsExchange_vehicleResidual As Boolean
Dim accountClient_card_fieldsExchange_vehicleSleeping As Boolean
Dim accountClient_card_fieldsExchange_vehicleWarranty As Boolean
Dim accountClient_card_fieldsExchange_vehicleCondition As Boolean
Dim accountClient_card_fieldsExchange_vehicleFrequency As Boolean
Dim accountClient_card_fieldsExchange_vehicleIntention As Boolean
Dim accountClient_card_fieldsExchange_vehicleRefinance As Boolean
Dim accountClient_card_fieldsExchange_vehicleRequested As Boolean
Dim accountClient_card_fieldsExchange_vehicleSold_date As Boolean
Dim accountClient_card_fieldsExchange_vehicleCategory_rv As Boolean
Dim accountClient_card_fieldsExchange_vehicleInstitution As Boolean
Dim accountClient_card_fieldsExchange_vehicleInitial_cash As Boolean
Dim accountClient_card_fieldsExchange_vehicleOffer_number As Boolean
Dim accountClient_card_fieldsExchange_vehicleTransmission As Boolean
Dim accountClient_card_fieldsExchange_vehicleDrivingWheels As Boolean
Dim accountClient_card_fieldsExchange_vehicleColor_exterior As Boolean
Dim accountClient_card_fieldsExchange_vehicleColor_interior As Boolean
Dim accountClient_card_fieldsExchange_vehicleAllowed_mileage As Boolean
Dim accountClient_card_fieldsExchange_vehicleSecurity_deposit As Boolean
Dim accountClient_card_fieldsExchange_vehicleEnd_contract_date As Boolean
Dim accountClient_number As Boolean
Dim accountConfirmation_appt As Boolean
Dim accountCredit As Boolean
Dim accountCsi As Boolean
Dim accountCsi_used As Boolean
Dim accountDefault_deliveryman_user_id As String
Dim accountDelivered_by As Boolean
Dim accountDisable_communication_audio As Boolean
Dim accountDuplicates As Boolean
Dim accountGuest_action As Boolean
Dim accountEmail_client As Boolean
Dim accountIn_turn As Boolean
Dim accountIn_turn_director_management As Boolean
Dim accountLeads_other_division As Boolean
Dim accountLeadxpress_optionPriority As Integer
Dim accountLeadxpress_optionReminderFrequency As Integer
Dim accountLeadxpress_optionReminderRecurrence As Integer
Dim accountLeadxpress_optionScheduleAccount As Boolean
Dim accountLeadxpress_optionScheduleAdvisor As Boolean
Dim accountLimited_audio_access As Boolean
Dim accountLogo As String
Dim accountLogo_en As String
Dim accountMandatory_coordinate As Boolean
Dim accountManually_status As Boolean
Dim accountMerge_rule As String
Dim accountMonth_start_day As Integer
Dim accountName As String
Dim accountNiotext As Boolean
Dim accountNiotext_phone As Boolean
Dim accountPhone As String
Dim accountPower_sport As Boolean
Dim accountProcess As Boolean
Dim accountRecreative_special As Boolean
Dim accountResult_date_validation As Boolean
Dim accountSale_accessories As Boolean
Dim accountSale_by_phone As Boolean
Dim accountSale_date_month As Boolean
Dim accountSale_table_optionsAccessory_column As Boolean
Dim accountSale_table_optionsCommercial_column As Boolean
Dim accountSale_table_optionsDivision_grouped_total_column As Boolean
Dim accountSale_validation As Boolean
Dim accountScan As Boolean
Dim accountStock_required_for_sale As Boolean
Dim accountTake_over_director As Boolean
Dim accountTrade_report As Boolean
Dim accountUnrestricted_assignment As Boolean
Dim accountUnsubscribe As Boolean
Dim accountUntreated_lead As Boolean
Dim accountVehicle_model_text As Boolean
Dim accountVehicle_text As Boolean
Dim accountVerified_sale As Boolean
Dim accountVin_decoder As Boolean
Dim accountWaiting_sale_date As String
Dim accountWaiting_sale_option As Boolean
Dim advisor As String
Dim j As Integer
Dim count_j As Integer
Dim lead_id As Integer
Dim address As String
Dim valid As Boolean
Dim extension As String
Dim number As String
Dim validated As Boolean
Dim mobile As Boolean
Dim accessories As String
Dim allowed_odometer As String
Dim balance As Integer
Dim budget_max As String
Dim budget_min As String
Dim cash_down As String
Dim category As String
Dim category_rv As String
Dim client_number As String
Dim color_exterior As String
Dim color_interior As String
Dim comment As String
Dim condition As String
Dim end_contract_date As String
Dim end_warranty_date As String
Dim engine As String
Dim extended_warranty As String
Dim fuel As String
Dim length_max As String
Dim length_min As String
Dim license_plate As String
Dim make As String
Dim modality As String
Dim model As String
Dim odometer As String
Dim offer_number As String
Dim v_option As String
Dim order_number As String
Dim payment As String
Dim payment_frequency As String
Dim preparation As String
Dim price As String
Dim profit As String
Dim purchase_date As String
Dim rate As String
Dim recall As String
Dim recorded_date As String
Dim residual As String
Dim security_deposit As String
Dim sleeping As String
Dim sold As Boolean
Dim sold_by As String
Dim sold_date As String
Dim stock As String
Dim stock_state As String
Dim term As String
Dim tire As Boolean
Dim transmission As String
Dim trim As String
Dim url As String
Dim value As String
Dim vin As String
Dim warranty As String
Dim weight As String
Dim year As String
Dim year_max As String
Dim year_min As String

linksFirst = jsonResponse.StringOf("links.first")
linksLast = jsonResponse.StringOf("links.last")
linksPrev = jsonResponse.StringOf("links.prev")
linksNext = jsonResponse.StringOf("links.next")
metaCurrent_page = jsonResponse.IntOf("meta.current_page")
metaFrom = jsonResponse.IntOf("meta.from")
metaLast_page = jsonResponse.IntOf("meta.last_page")
metaPath = jsonResponse.StringOf("meta.path")
metaPer_page = jsonResponse.IntOf("meta.per_page")
metaTo = jsonResponse.IntOf("meta.to")
metaTotal = jsonResponse.IntOf("meta.total")
i = 0
count_i = jsonResponse.SizeOfArray("data")
While i < count_i
    jsonResponse.I = i
    id = jsonResponse.IntOf("data[i].id")
    created_at = jsonResponse.StringOf("data[i].created_at")
    updated_at = jsonResponse.StringOf("data[i].updated_at")
    account_id = jsonResponse.IntOf("data[i].account_id")
    address_line1 = jsonResponse.StringOf("data[i].address_line1")
    address_line2 = jsonResponse.StringOf("data[i].address_line2")
    appointment_date = jsonResponse.StringOf("data[i].appointment_date")
    appt_call = jsonResponse.BoolOf("data[i].appt_call")
    available_date = jsonResponse.StringOf("data[i].available_date")
    average_spending = jsonResponse.StringOf("data[i].average_spending")
    be_back_date = jsonResponse.StringOf("data[i].be_back_date")
    birth_date = jsonResponse.StringOf("data[i].birth_date")
    business = jsonResponse.StringOf("data[i].business")
    call_date = jsonResponse.StringOf("data[i].call_date")
    city = jsonResponse.StringOf("data[i].city")
    civility = jsonResponse.StringOf("data[i].civility")
    code = jsonResponse.StringOf("data[i].code")
    country = jsonResponse.StringOf("data[i].country")
    csi_date = jsonResponse.StringOf("data[i].csi_date")
    delivered_by_id = jsonResponse.StringOf("data[i].delivered_by_id")
    delivered_date = jsonResponse.StringOf("data[i].delivered_date")
    delivery_date = jsonResponse.StringOf("data[i].delivery_date")
    division = jsonResponse.StringOf("data[i].division")
    end_service_date = jsonResponse.StringOf("data[i].end_service_date")
    first_name = jsonResponse.StringOf("data[i].first_name")
    gas = jsonResponse.StringOf("data[i].gas")
    gender = jsonResponse.IntOf("data[i].gender")
    invoiced = jsonResponse.BoolOf("data[i].invoiced")
    last_name = jsonResponse.StringOf("data[i].last_name")
    last_visit_date = jsonResponse.StringOf("data[i].last_visit_date")
    locale = jsonResponse.StringOf("data[i].locale")
    loyalty = jsonResponse.StringOf("data[i].loyalty")
    next_visit_date = jsonResponse.StringOf("data[i].next_visit_date")
    odometer_last_visit = jsonResponse.StringOf("data[i].odometer_last_visit")
    open_work_order_date = jsonResponse.StringOf("data[i].open_work_order_date")
    planned_pick_up_date = jsonResponse.StringOf("data[i].planned_pick_up_date")
    postal_code = jsonResponse.StringOf("data[i].postal_code")
    prepaid = jsonResponse.StringOf("data[i].prepaid")
    prepared = jsonResponse.BoolOf("data[i].prepared")
    presented_date = jsonResponse.StringOf("data[i].presented_date")
    promised_date = jsonResponse.StringOf("data[i].promised_date")
    province = jsonResponse.StringOf("data[i].province")
    rating = jsonResponse.StringOf("data[i].rating")
    reached_client = jsonResponse.BoolOf("data[i].reached_client")
    refinanced_date = jsonResponse.StringOf("data[i].refinanced_date")
    repair_date = jsonResponse.StringOf("data[i].repair_date")
    repair_order = jsonResponse.StringOf("data[i].repair_order")
    result = jsonResponse.StringOf("data[i].result")
    road_test_date = jsonResponse.StringOf("data[i].road_test_date")
    sale_date = jsonResponse.StringOf("data[i].sale_date")
    second_contact = jsonResponse.StringOf("data[i].second_contact")
    second_contact_civility = jsonResponse.StringOf("data[i].second_contact_civility")
    segment = jsonResponse.StringOf("data[i].segment")
    service_cleaned = jsonResponse.BoolOf("data[i].service_cleaned")
    service_interval_km = jsonResponse.StringOf("data[i].service_interval_km")
    service_monthly_km = jsonResponse.StringOf("data[i].service_monthly_km")
    service_processIntention = jsonResponse.StringOf("data[i].service_process.intention")
    service_processTransport = jsonResponse.StringOf("data[i].service_process.transport")
    service_processWalk_around = jsonResponse.StringOf("data[i].service_process.walk_around")
    sex = jsonResponse.StringOf("data[i].sex")
    source = jsonResponse.StringOf("data[i].source")
    status = jsonResponse.StringOf("data[i].status")
    storage = jsonResponse.StringOf("data[i].storage")
    take_over_date = jsonResponse.StringOf("data[i].take_over_date")
    v_type = jsonResponse.StringOf("data[i].type")
    unsubscribe_all_date = jsonResponse.StringOf("data[i].unsubscribe_all_date")
    unsubscribe_call_date = jsonResponse.StringOf("data[i].unsubscribe_call_date")
    unsubscribe_email_date = jsonResponse.StringOf("data[i].unsubscribe_email_date")
    unsubscribe_sms_date = jsonResponse.StringOf("data[i].unsubscribe_sms_date")
    work_order = jsonResponse.StringOf("data[i].work_order")
    accountId = jsonResponse.IntOf("data[i].account.id")
    accountCreated_at = jsonResponse.StringOf("data[i].account.created_at")
    accountUpdated_at = jsonResponse.StringOf("data[i].account.updated_at")
    accountPartner_id = jsonResponse.IntOf("data[i].account.partner_id")
    accountActivity_report = jsonResponse.BoolOf("data[i].account.activity_report")
    accountCommercial = jsonResponse.BoolOf("data[i].account.commercial")
    accountEvent = jsonResponse.BoolOf("data[i].account.event")
    accountLeadxpress = jsonResponse.BoolOf("data[i].account.leadxpress")
    accountLoyalty = jsonResponse.BoolOf("data[i].account.loyalty")
    accountPhone_up = jsonResponse.BoolOf("data[i].account.phone_up")
    accountRenewal = jsonResponse.BoolOf("data[i].account.renewal")
    accountSale_table = jsonResponse.BoolOf("data[i].account.sale_table")
    accountService = jsonResponse.BoolOf("data[i].account.service")
    accountWalk_in = jsonResponse.BoolOf("data[i].account.walk_in")
    accountWebboost = jsonResponse.BoolOf("data[i].account.webboost")
    accountAccount_manager = jsonResponse.BoolOf("data[i].account.account_manager")
    accountActivation_date = jsonResponse.StringOf("data[i].account.activation_date")
    accountActive = jsonResponse.BoolOf("data[i].account.active")
    accountAssigned_lead = jsonResponse.BoolOf("data[i].account.assigned_lead")
    accountAuto_renewal = jsonResponse.BoolOf("data[i].account.auto_renewal")
    accountAuto_renewal_new = jsonResponse.BoolOf("data[i].account.auto_renewal_new")
    accountAuto_renewal_used = jsonResponse.BoolOf("data[i].account.auto_renewal_used")
    accountAutomation = jsonResponse.BoolOf("data[i].account.automation")
    accountBdc_advisor = jsonResponse.BoolOf("data[i].account.bdc_advisor")
    accountCalendar_options = jsonResponse.BoolOf("data[i].account.calendar_options")
    accountClient_card_fieldsProcessGas = jsonResponse.BoolOf("data[i].account.client_card_fields.process.gas")
    accountClient_card_fieldsProcessRecorded = jsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded")
    accountClient_card_fieldsProcessAvailable = jsonResponse.BoolOf("data[i].account.client_card_fields.process.available")
    accountClient_card_fieldsProcessDiscounted = jsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted")
    accountClient_card_fieldsCommercialProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit")
    accountClient_card_fieldsCommercialExclude = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude")
    accountClient_card_fieldsCommercialMeeting = jsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting")
    accountClient_card_fieldsPerformanceDeposit = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit")
    accountClient_card_fieldsPerformanceRefinanced = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced")
    accountClient_card_fieldsPerformanceDealer_tour = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour")
    accountClient_card_fieldsPerformanceWalk_around = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around")
    accountClient_card_fieldsPerformanceQualification = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification")
    accountClient_card_fieldsPerformanceTwenty_four_hour = jsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour")
    accountClient_card_fieldsGeneral_infoBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget")
    accountClient_card_fieldsGeneral_infoSector = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector")
    accountClient_card_fieldsGeneral_infoCustom_1 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1")
    accountClient_card_fieldsGeneral_infoCustom_2 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2")
    accountClient_card_fieldsGeneral_infoCustom_3 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3")
    accountClient_card_fieldsGeneral_infoCustom_4 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4")
    accountClient_card_fieldsGeneral_infoCustom_5 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5")
    accountClient_card_fieldsGeneral_infoCustom_6 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6")
    accountClient_card_fieldsGeneral_infoCustom_7 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7")
    accountClient_card_fieldsGeneral_infoCustom_8 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8")
    accountClient_card_fieldsGeneral_infoCustom_9 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9")
    accountClient_card_fieldsGeneral_infoCustom_10 = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10")
    accountClient_card_fieldsGeneral_infoCommunication_preference = jsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference")
    accountClient_card_fieldsWanted_vehicleVin = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin")
    accountClient_card_fieldsWanted_vehicleFuel = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel")
    accountClient_card_fieldsWanted_vehicleRate = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate")
    accountClient_card_fieldsWanted_vehicleTerm = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term")
    accountClient_card_fieldsWanted_vehicleTire = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire")
    accountClient_card_fieldsWanted_vehicleYear = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year")
    accountClient_card_fieldsWanted_vehicleColor = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color")
    accountClient_card_fieldsWanted_vehiclePrice = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price")
    accountClient_card_fieldsWanted_vehicleStock = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock")
    accountClient_card_fieldsWanted_vehicleTotal = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total")
    accountClient_card_fieldsWanted_vehicleBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget")
    accountClient_card_fieldsWanted_vehicleEngine = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine")
    accountClient_card_fieldsWanted_vehicleLength = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length")
    accountClient_card_fieldsWanted_vehicleProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit")
    accountClient_card_fieldsWanted_vehicleSuffix = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix")
    accountClient_card_fieldsWanted_vehicleWeight = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight")
    accountClient_card_fieldsWanted_vehicleComment = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment")
    accountClient_card_fieldsWanted_vehicleMileage = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage")
    accountClient_card_fieldsWanted_vehiclePayment = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment")
    accountClient_card_fieldsWanted_vehicleBodyType = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType")
    accountClient_card_fieldsWanted_vehicleCategory = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category")
    accountClient_card_fieldsWanted_vehicleModality = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality")
    accountClient_card_fieldsWanted_vehicleResidual = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual")
    accountClient_card_fieldsWanted_vehicleSleeping = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping")
    accountClient_card_fieldsWanted_vehicleWarranty = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty")
    accountClient_card_fieldsWanted_vehicleFrequency = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency")
    accountClient_card_fieldsWanted_vehicleAccessories = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories")
    accountClient_card_fieldsWanted_vehicleCategory_rv = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv")
    accountClient_card_fieldsWanted_vehiclePreparation = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation")
    accountClient_card_fieldsWanted_vehicleInitial_cash = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash")
    accountClient_card_fieldsWanted_vehicleOffer_number = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number")
    accountClient_card_fieldsWanted_vehicleOrder_number = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number")
    accountClient_card_fieldsWanted_vehicleTransmission = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission")
    accountClient_card_fieldsWanted_vehicleDocumentation = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation")
    accountClient_card_fieldsWanted_vehicleDrivingWheels = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels")
    accountClient_card_fieldsWanted_vehicleColor_exterior = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior")
    accountClient_card_fieldsWanted_vehicleColor_interior = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior")
    accountClient_card_fieldsWanted_vehicleAllowed_mileage = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage")
    accountClient_card_fieldsWanted_vehicleSecurity_deposit = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit")
    accountClient_card_fieldsWanted_vehicleEnd_contract_date = jsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date")
    accountClient_card_fieldsExchange_vehicleVin = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin")
    accountClient_card_fieldsExchange_vehicleFuel = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel")
    accountClient_card_fieldsExchange_vehicleLink = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link")
    accountClient_card_fieldsExchange_vehicleRate = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate")
    accountClient_card_fieldsExchange_vehicleTerm = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term")
    accountClient_card_fieldsExchange_vehicleYear = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year")
    accountClient_card_fieldsExchange_vehicleColor = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color")
    accountClient_card_fieldsExchange_vehiclePrice = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price")
    accountClient_card_fieldsExchange_vehicleStock = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock")
    accountClient_card_fieldsExchange_vehicleValue = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value")
    accountClient_card_fieldsExchange_vehicleBudget = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget")
    accountClient_card_fieldsExchange_vehicleEngine = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine")
    accountClient_card_fieldsExchange_vehicleLength = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length")
    accountClient_card_fieldsExchange_vehicleProfit = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit")
    accountClient_card_fieldsExchange_vehicleSuffix = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix")
    accountClient_card_fieldsExchange_vehicleWeight = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight")
    accountClient_card_fieldsExchange_vehicleBalance = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance")
    accountClient_card_fieldsExchange_vehicleComment = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment")
    accountClient_card_fieldsExchange_vehicleMileage = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage")
    accountClient_card_fieldsExchange_vehiclePayment = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment")
    accountClient_card_fieldsExchange_vehicleRenewal = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal")
    accountClient_card_fieldsExchange_vehicleSold_by = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by")
    accountClient_card_fieldsExchange_vehicleBodyType = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType")
    accountClient_card_fieldsExchange_vehicleCategory = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category")
    accountClient_card_fieldsExchange_vehicleModality = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality")
    accountClient_card_fieldsExchange_vehicleResidual = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual")
    accountClient_card_fieldsExchange_vehicleSleeping = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping")
    accountClient_card_fieldsExchange_vehicleWarranty = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty")
    accountClient_card_fieldsExchange_vehicleCondition = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition")
    accountClient_card_fieldsExchange_vehicleFrequency = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency")
    accountClient_card_fieldsExchange_vehicleIntention = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention")
    accountClient_card_fieldsExchange_vehicleRefinance = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance")
    accountClient_card_fieldsExchange_vehicleRequested = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested")
    accountClient_card_fieldsExchange_vehicleSold_date = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date")
    accountClient_card_fieldsExchange_vehicleCategory_rv = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv")
    accountClient_card_fieldsExchange_vehicleInstitution = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution")
    accountClient_card_fieldsExchange_vehicleInitial_cash = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash")
    accountClient_card_fieldsExchange_vehicleOffer_number = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number")
    accountClient_card_fieldsExchange_vehicleTransmission = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission")
    accountClient_card_fieldsExchange_vehicleDrivingWheels = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels")
    accountClient_card_fieldsExchange_vehicleColor_exterior = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior")
    accountClient_card_fieldsExchange_vehicleColor_interior = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior")
    accountClient_card_fieldsExchange_vehicleAllowed_mileage = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage")
    accountClient_card_fieldsExchange_vehicleSecurity_deposit = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit")
    accountClient_card_fieldsExchange_vehicleEnd_contract_date = jsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date")
    accountClient_number = jsonResponse.BoolOf("data[i].account.client_number")
    accountConfirmation_appt = jsonResponse.BoolOf("data[i].account.confirmation_appt")
    accountCredit = jsonResponse.BoolOf("data[i].account.credit")
    accountCsi = jsonResponse.BoolOf("data[i].account.csi")
    accountCsi_used = jsonResponse.BoolOf("data[i].account.csi_used")
    accountDefault_deliveryman_user_id = jsonResponse.StringOf("data[i].account.default_deliveryman_user_id")
    accountDelivered_by = jsonResponse.BoolOf("data[i].account.delivered_by")
    accountDisable_communication_audio = jsonResponse.BoolOf("data[i].account.disable_communication_audio")
    accountDuplicates = jsonResponse.BoolOf("data[i].account.duplicates")
    accountGuest_action = jsonResponse.BoolOf("data[i].account.guest_action")
    accountEmail_client = jsonResponse.BoolOf("data[i].account.email_client")
    accountIn_turn = jsonResponse.BoolOf("data[i].account.in_turn")
    accountIn_turn_director_management = jsonResponse.BoolOf("data[i].account.in_turn_director_management")
    accountLeads_other_division = jsonResponse.BoolOf("data[i].account.leads_other_division")
    accountLeadxpress_optionPriority = jsonResponse.IntOf("data[i].account.leadxpress_option.priority")
    accountLeadxpress_optionReminderFrequency = jsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency")
    accountLeadxpress_optionReminderRecurrence = jsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence")
    accountLeadxpress_optionScheduleAccount = jsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account")
    accountLeadxpress_optionScheduleAdvisor = jsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor")
    accountLimited_audio_access = jsonResponse.BoolOf("data[i].account.limited_audio_access")
    accountLogo = jsonResponse.StringOf("data[i].account.logo")
    accountLogo_en = jsonResponse.StringOf("data[i].account.logo_en")
    accountMandatory_coordinate = jsonResponse.BoolOf("data[i].account.mandatory_coordinate")
    accountManually_status = jsonResponse.BoolOf("data[i].account.manually_status")
    accountMerge_rule = jsonResponse.StringOf("data[i].account.merge_rule")
    accountMonth_start_day = jsonResponse.IntOf("data[i].account.month_start_day")
    accountName = jsonResponse.StringOf("data[i].account.name")
    accountNiotext = jsonResponse.BoolOf("data[i].account.niotext")
    accountNiotext_phone = jsonResponse.BoolOf("data[i].account.niotext_phone")
    accountPhone = jsonResponse.StringOf("data[i].account.phone")
    accountPower_sport = jsonResponse.BoolOf("data[i].account.power_sport")
    accountProcess = jsonResponse.BoolOf("data[i].account.process")
    accountRecreative_special = jsonResponse.BoolOf("data[i].account.recreative_special")
    accountResult_date_validation = jsonResponse.BoolOf("data[i].account.result_date_validation")
    accountSale_accessories = jsonResponse.BoolOf("data[i].account.sale_accessories")
    accountSale_by_phone = jsonResponse.BoolOf("data[i].account.sale_by_phone")
    accountSale_date_month = jsonResponse.BoolOf("data[i].account.sale_date_month")
    accountSale_table_optionsAccessory_column = jsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column")
    accountSale_table_optionsCommercial_column = jsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column")
    accountSale_table_optionsDivision_grouped_total_column = jsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column")
    accountSale_validation = jsonResponse.BoolOf("data[i].account.sale_validation")
    accountScan = jsonResponse.BoolOf("data[i].account.scan")
    accountStock_required_for_sale = jsonResponse.BoolOf("data[i].account.stock_required_for_sale")
    accountTake_over_director = jsonResponse.BoolOf("data[i].account.take_over_director")
    accountTrade_report = jsonResponse.BoolOf("data[i].account.trade_report")
    accountUnrestricted_assignment = jsonResponse.BoolOf("data[i].account.unrestricted_assignment")
    accountUnsubscribe = jsonResponse.BoolOf("data[i].account.unsubscribe")
    accountUntreated_lead = jsonResponse.BoolOf("data[i].account.untreated_lead")
    accountVehicle_model_text = jsonResponse.BoolOf("data[i].account.vehicle_model_text")
    accountVehicle_text = jsonResponse.BoolOf("data[i].account.vehicle_text")
    accountVerified_sale = jsonResponse.BoolOf("data[i].account.verified_sale")
    accountVin_decoder = jsonResponse.BoolOf("data[i].account.vin_decoder")
    accountWaiting_sale_date = jsonResponse.StringOf("data[i].account.waiting_sale_date")
    accountWaiting_sale_option = jsonResponse.BoolOf("data[i].account.waiting_sale_option")
    advisor = jsonResponse.StringOf("data[i].advisor")
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].emails")
    While j < count_j
        jsonResponse.J = j
        id = jsonResponse.IntOf("data[i].emails[j].id")
        created_at = jsonResponse.StringOf("data[i].emails[j].created_at")
        updated_at = jsonResponse.StringOf("data[i].emails[j].updated_at")
        lead_id = jsonResponse.IntOf("data[i].emails[j].lead_id")
        address = jsonResponse.StringOf("data[i].emails[j].address")
        v_type = jsonResponse.StringOf("data[i].emails[j].type")
        valid = jsonResponse.BoolOf("data[i].emails[j].valid")
        j = j + 1
    End While
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].phones")
    While j < count_j
        jsonResponse.J = j
        id = jsonResponse.IntOf("data[i].phones[j].id")
        created_at = jsonResponse.StringOf("data[i].phones[j].created_at")
        updated_at = jsonResponse.StringOf("data[i].phones[j].updated_at")
        lead_id = jsonResponse.IntOf("data[i].phones[j].lead_id")
        extension = jsonResponse.StringOf("data[i].phones[j].extension")
        number = jsonResponse.StringOf("data[i].phones[j].number")
        v_type = jsonResponse.StringOf("data[i].phones[j].type")
        valid = jsonResponse.BoolOf("data[i].phones[j].valid")
        validated = jsonResponse.BoolOf("data[i].phones[j].validated")
        mobile = jsonResponse.BoolOf("data[i].phones[j].mobile")
        j = j + 1
    End While
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].vehicles")
    While j < count_j
        jsonResponse.J = j
        id = jsonResponse.IntOf("data[i].vehicles[j].id")
        created_at = jsonResponse.StringOf("data[i].vehicles[j].created_at")
        updated_at = jsonResponse.StringOf("data[i].vehicles[j].updated_at")
        lead_id = jsonResponse.IntOf("data[i].vehicles[j].lead_id")
        accessories = jsonResponse.StringOf("data[i].vehicles[j].accessories")
        allowed_odometer = jsonResponse.StringOf("data[i].vehicles[j].allowed_odometer")
        balance = jsonResponse.IntOf("data[i].vehicles[j].balance")
        budget_max = jsonResponse.StringOf("data[i].vehicles[j].budget_max")
        budget_min = jsonResponse.StringOf("data[i].vehicles[j].budget_min")
        cash_down = jsonResponse.StringOf("data[i].vehicles[j].cash_down")
        category = jsonResponse.StringOf("data[i].vehicles[j].category")
        category_rv = jsonResponse.StringOf("data[i].vehicles[j].category_rv")
        client_number = jsonResponse.StringOf("data[i].vehicles[j].client_number")
        color_exterior = jsonResponse.StringOf("data[i].vehicles[j].color_exterior")
        color_interior = jsonResponse.StringOf("data[i].vehicles[j].color_interior")
        comment = jsonResponse.StringOf("data[i].vehicles[j].comment")
        condition = jsonResponse.StringOf("data[i].vehicles[j].condition")
        end_contract_date = jsonResponse.StringOf("data[i].vehicles[j].end_contract_date")
        end_warranty_date = jsonResponse.StringOf("data[i].vehicles[j].end_warranty_date")
        engine = jsonResponse.StringOf("data[i].vehicles[j].engine")
        extended_warranty = jsonResponse.StringOf("data[i].vehicles[j].extended_warranty")
        fuel = jsonResponse.StringOf("data[i].vehicles[j].fuel")
        length_max = jsonResponse.StringOf("data[i].vehicles[j].length_max")
        length_min = jsonResponse.StringOf("data[i].vehicles[j].length_min")
        license_plate = jsonResponse.StringOf("data[i].vehicles[j].license_plate")
        make = jsonResponse.StringOf("data[i].vehicles[j].make")
        modality = jsonResponse.StringOf("data[i].vehicles[j].modality")
        model = jsonResponse.StringOf("data[i].vehicles[j].model")
        odometer = jsonResponse.StringOf("data[i].vehicles[j].odometer")
        offer_number = jsonResponse.StringOf("data[i].vehicles[j].offer_number")
        v_option = jsonResponse.StringOf("data[i].vehicles[j].option")
        order_number = jsonResponse.StringOf("data[i].vehicles[j].order_number")
        payment = jsonResponse.StringOf("data[i].vehicles[j].payment")
        payment_frequency = jsonResponse.StringOf("data[i].vehicles[j].payment_frequency")
        preparation = jsonResponse.StringOf("data[i].vehicles[j].preparation")
        price = jsonResponse.StringOf("data[i].vehicles[j].price")
        profit = jsonResponse.StringOf("data[i].vehicles[j].profit")
        purchase_date = jsonResponse.StringOf("data[i].vehicles[j].purchase_date")
        rate = jsonResponse.StringOf("data[i].vehicles[j].rate")
        recall = jsonResponse.StringOf("data[i].vehicles[j].recall")
        recorded_date = jsonResponse.StringOf("data[i].vehicles[j].recorded_date")
        residual = jsonResponse.StringOf("data[i].vehicles[j].residual")
        security_deposit = jsonResponse.StringOf("data[i].vehicles[j].security_deposit")
        sleeping = jsonResponse.StringOf("data[i].vehicles[j].sleeping")
        sold = jsonResponse.BoolOf("data[i].vehicles[j].sold")
        sold_by = jsonResponse.StringOf("data[i].vehicles[j].sold_by")
        sold_date = jsonResponse.StringOf("data[i].vehicles[j].sold_date")
        stock = jsonResponse.StringOf("data[i].vehicles[j].stock")
        stock_state = jsonResponse.StringOf("data[i].vehicles[j].stock_state")
        term = jsonResponse.StringOf("data[i].vehicles[j].term")
        tire = jsonResponse.BoolOf("data[i].vehicles[j].tire")
        transmission = jsonResponse.StringOf("data[i].vehicles[j].transmission")
        trim = jsonResponse.StringOf("data[i].vehicles[j].trim")
        v_type = jsonResponse.StringOf("data[i].vehicles[j].type")
        url = jsonResponse.StringOf("data[i].vehicles[j].url")
        value = jsonResponse.StringOf("data[i].vehicles[j].value")
        vin = jsonResponse.StringOf("data[i].vehicles[j].vin")
        warranty = jsonResponse.StringOf("data[i].vehicles[j].warranty")
        weight = jsonResponse.StringOf("data[i].vehicles[j].weight")
        year = jsonResponse.StringOf("data[i].vehicles[j].year")
        year_max = jsonResponse.StringOf("data[i].vehicles[j].year_max")
        year_min = jsonResponse.StringOf("data[i].vehicles[j].year_min")
        j = j + 1
    End While
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].products")
    While j < count_j
        jsonResponse.J = j
        j = j + 1
    End While
    i = i + 1
End While