(Visual Basic 6.0) Activix CRM Search for Leads

Demonstrates how to full-text search for leads, returning a JSON list of leads.

For more information, see https://docs.crm.activix.ca/api/resources/lead

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

Dim http As New ChilkatHttp

http.AuthToken = "ACCESS_TOKEN"

http.Accept = "application/json"

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

Debug.Print "Response Status Code: " & http.LastStatus

Dim jsonResponse As New ChilkatJsonObject
success = jsonResponse.Load(strResp)
jsonResponse.EmitCompact = 0
Debug.Print jsonResponse.Emit()

If (http.LastStatus <> 200) Then
    Debug.Print "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 Long
Dim metaFrom As Long
Dim metaLast_page As Long
Dim metaPath As String
Dim metaPer_page As Long
Dim metaTo As Long
Dim metaTotal As Long
Dim i As Long
Dim count_i As Long
Dim id As Long
Dim created_at As String
Dim updated_at As String
Dim account_id As Long
Dim address_line1 As String
Dim address_line2 As String
Dim appointment_date As String
Dim appt_call As Long
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 Long
Dim invoiced As Long
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 Long
Dim presented_date As String
Dim promised_date As String
Dim province As String
Dim rating As String
Dim reached_client As Long
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 Long
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 Long
Dim accountCreated_at As String
Dim accountUpdated_at As String
Dim accountPartner_id As Long
Dim accountActivity_report As Long
Dim accountCommercial As Long
Dim accountEvent As Long
Dim accountLeadxpress As Long
Dim accountLoyalty As Long
Dim accountPhone_up As Long
Dim accountRenewal As Long
Dim accountSale_table As Long
Dim accountService As Long
Dim accountWalk_in As Long
Dim accountWebboost As Long
Dim accountAccount_manager As Long
Dim accountActivation_date As String
Dim accountActive As Long
Dim accountAssigned_lead As Long
Dim accountAuto_renewal As Long
Dim accountAuto_renewal_new As Long
Dim accountAuto_renewal_used As Long
Dim accountAutomation As Long
Dim accountBdc_advisor As Long
Dim accountCalendar_options As Long
Dim accountClient_card_fieldsProcessGas As Long
Dim accountClient_card_fieldsProcessRecorded As Long
Dim accountClient_card_fieldsProcessAvailable As Long
Dim accountClient_card_fieldsProcessDiscounted As Long
Dim accountClient_card_fieldsCommercialProfit As Long
Dim accountClient_card_fieldsCommercialExclude As Long
Dim accountClient_card_fieldsCommercialMeeting As Long
Dim accountClient_card_fieldsPerformanceDeposit As Long
Dim accountClient_card_fieldsPerformanceRefinanced As Long
Dim accountClient_card_fieldsPerformanceDealer_tour As Long
Dim accountClient_card_fieldsPerformanceWalk_around As Long
Dim accountClient_card_fieldsPerformanceQualification As Long
Dim accountClient_card_fieldsPerformanceTwenty_four_hour As Long
Dim accountClient_card_fieldsGeneral_infoBudget As Long
Dim accountClient_card_fieldsGeneral_infoSector As Long
Dim accountClient_card_fieldsGeneral_infoCustom_1 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_2 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_3 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_4 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_5 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_6 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_7 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_8 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_9 As Long
Dim accountClient_card_fieldsGeneral_infoCustom_10 As Long
Dim accountClient_card_fieldsGeneral_infoCommunication_preference As Long
Dim accountClient_card_fieldsWanted_vehicleVin As Long
Dim accountClient_card_fieldsWanted_vehicleFuel As Long
Dim accountClient_card_fieldsWanted_vehicleRate As Long
Dim accountClient_card_fieldsWanted_vehicleTerm As Long
Dim accountClient_card_fieldsWanted_vehicleTire As Long
Dim accountClient_card_fieldsWanted_vehicleYear As Long
Dim accountClient_card_fieldsWanted_vehicleColor As Long
Dim accountClient_card_fieldsWanted_vehiclePrice As Long
Dim accountClient_card_fieldsWanted_vehicleStock As Long
Dim accountClient_card_fieldsWanted_vehicleTotal As Long
Dim accountClient_card_fieldsWanted_vehicleBudget As Long
Dim accountClient_card_fieldsWanted_vehicleEngine As Long
Dim accountClient_card_fieldsWanted_vehicleLength As Long
Dim accountClient_card_fieldsWanted_vehicleProfit As Long
Dim accountClient_card_fieldsWanted_vehicleSuffix As Long
Dim accountClient_card_fieldsWanted_vehicleWeight As Long
Dim accountClient_card_fieldsWanted_vehicleComment As Long
Dim accountClient_card_fieldsWanted_vehicleMileage As Long
Dim accountClient_card_fieldsWanted_vehiclePayment As Long
Dim accountClient_card_fieldsWanted_vehicleBodyType As Long
Dim accountClient_card_fieldsWanted_vehicleCategory As Long
Dim accountClient_card_fieldsWanted_vehicleModality As Long
Dim accountClient_card_fieldsWanted_vehicleResidual As Long
Dim accountClient_card_fieldsWanted_vehicleSleeping As Long
Dim accountClient_card_fieldsWanted_vehicleWarranty As Long
Dim accountClient_card_fieldsWanted_vehicleFrequency As Long
Dim accountClient_card_fieldsWanted_vehicleAccessories As Long
Dim accountClient_card_fieldsWanted_vehicleCategory_rv As Long
Dim accountClient_card_fieldsWanted_vehiclePreparation As Long
Dim accountClient_card_fieldsWanted_vehicleInitial_cash As Long
Dim accountClient_card_fieldsWanted_vehicleOffer_number As Long
Dim accountClient_card_fieldsWanted_vehicleOrder_number As Long
Dim accountClient_card_fieldsWanted_vehicleTransmission As Long
Dim accountClient_card_fieldsWanted_vehicleDocumentation As Long
Dim accountClient_card_fieldsWanted_vehicleDrivingWheels As Long
Dim accountClient_card_fieldsWanted_vehicleColor_exterior As Long
Dim accountClient_card_fieldsWanted_vehicleColor_interior As Long
Dim accountClient_card_fieldsWanted_vehicleAllowed_mileage As Long
Dim accountClient_card_fieldsWanted_vehicleSecurity_deposit As Long
Dim accountClient_card_fieldsWanted_vehicleEnd_contract_date As Long
Dim accountClient_card_fieldsExchange_vehicleVin As Long
Dim accountClient_card_fieldsExchange_vehicleFuel As Long
Dim accountClient_card_fieldsExchange_vehicleLink As Long
Dim accountClient_card_fieldsExchange_vehicleRate As Long
Dim accountClient_card_fieldsExchange_vehicleTerm As Long
Dim accountClient_card_fieldsExchange_vehicleYear As Long
Dim accountClient_card_fieldsExchange_vehicleColor As Long
Dim accountClient_card_fieldsExchange_vehiclePrice As Long
Dim accountClient_card_fieldsExchange_vehicleStock As Long
Dim accountClient_card_fieldsExchange_vehicleValue As Long
Dim accountClient_card_fieldsExchange_vehicleBudget As Long
Dim accountClient_card_fieldsExchange_vehicleEngine As Long
Dim accountClient_card_fieldsExchange_vehicleLength As Long
Dim accountClient_card_fieldsExchange_vehicleProfit As Long
Dim accountClient_card_fieldsExchange_vehicleSuffix As Long
Dim accountClient_card_fieldsExchange_vehicleWeight As Long
Dim accountClient_card_fieldsExchange_vehicleBalance As Long
Dim accountClient_card_fieldsExchange_vehicleComment As Long
Dim accountClient_card_fieldsExchange_vehicleMileage As Long
Dim accountClient_card_fieldsExchange_vehiclePayment As Long
Dim accountClient_card_fieldsExchange_vehicleRenewal As Long
Dim accountClient_card_fieldsExchange_vehicleSold_by As Long
Dim accountClient_card_fieldsExchange_vehicleBodyType As Long
Dim accountClient_card_fieldsExchange_vehicleCategory As Long
Dim accountClient_card_fieldsExchange_vehicleModality As Long
Dim accountClient_card_fieldsExchange_vehicleResidual As Long
Dim accountClient_card_fieldsExchange_vehicleSleeping As Long
Dim accountClient_card_fieldsExchange_vehicleWarranty As Long
Dim accountClient_card_fieldsExchange_vehicleCondition As Long
Dim accountClient_card_fieldsExchange_vehicleFrequency As Long
Dim accountClient_card_fieldsExchange_vehicleIntention As Long
Dim accountClient_card_fieldsExchange_vehicleRefinance As Long
Dim accountClient_card_fieldsExchange_vehicleRequested As Long
Dim accountClient_card_fieldsExchange_vehicleSold_date As Long
Dim accountClient_card_fieldsExchange_vehicleCategory_rv As Long
Dim accountClient_card_fieldsExchange_vehicleInstitution As Long
Dim accountClient_card_fieldsExchange_vehicleInitial_cash As Long
Dim accountClient_card_fieldsExchange_vehicleOffer_number As Long
Dim accountClient_card_fieldsExchange_vehicleTransmission As Long
Dim accountClient_card_fieldsExchange_vehicleDrivingWheels As Long
Dim accountClient_card_fieldsExchange_vehicleColor_exterior As Long
Dim accountClient_card_fieldsExchange_vehicleColor_interior As Long
Dim accountClient_card_fieldsExchange_vehicleAllowed_mileage As Long
Dim accountClient_card_fieldsExchange_vehicleSecurity_deposit As Long
Dim accountClient_card_fieldsExchange_vehicleEnd_contract_date As Long
Dim accountClient_number As Long
Dim accountConfirmation_appt As Long
Dim accountCredit As Long
Dim accountCsi As Long
Dim accountCsi_used As Long
Dim accountDefault_deliveryman_user_id As String
Dim accountDelivered_by As Long
Dim accountDisable_communication_audio As Long
Dim accountDuplicates As Long
Dim accountGuest_action As Long
Dim accountEmail_client As Long
Dim accountIn_turn As Long
Dim accountIn_turn_director_management As Long
Dim accountLeads_other_division As Long
Dim accountLeadxpress_optionPriority As Long
Dim accountLeadxpress_optionReminderFrequency As Long
Dim accountLeadxpress_optionReminderRecurrence As Long
Dim accountLeadxpress_optionScheduleAccount As Long
Dim accountLeadxpress_optionScheduleAdvisor As Long
Dim accountLimited_audio_access As Long
Dim accountLogo As String
Dim accountLogo_en As String
Dim accountMandatory_coordinate As Long
Dim accountManually_status As Long
Dim accountMerge_rule As String
Dim accountMonth_start_day As Long
Dim accountName As String
Dim accountNiotext As Long
Dim accountNiotext_phone As Long
Dim accountPhone As String
Dim accountPower_sport As Long
Dim accountProcess As Long
Dim accountRecreative_special As Long
Dim accountResult_date_validation As Long
Dim accountSale_accessories As Long
Dim accountSale_by_phone As Long
Dim accountSale_date_month As Long
Dim accountSale_table_optionsAccessory_column As Long
Dim accountSale_table_optionsCommercial_column As Long
Dim accountSale_table_optionsDivision_grouped_total_column As Long
Dim accountSale_validation As Long
Dim accountScan As Long
Dim accountStock_required_for_sale As Long
Dim accountTake_over_director As Long
Dim accountTrade_report As Long
Dim accountUnrestricted_assignment As Long
Dim accountUnsubscribe As Long
Dim accountUntreated_lead As Long
Dim accountVehicle_model_text As Long
Dim accountVehicle_text As Long
Dim accountVerified_sale As Long
Dim accountVin_decoder As Long
Dim accountWaiting_sale_date As String
Dim accountWaiting_sale_option As Long
Dim advisor As String
Dim j As Long
Dim count_j As Long
Dim lead_id As Long
Dim address As String
Dim valid As Long
Dim extension As String
Dim number As String
Dim validated As Long
Dim mobile As Long
Dim accessories As String
Dim allowed_odometer As String
Dim balance As Long
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 Long
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 Long
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")
Do 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")
    Do 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
    Loop
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].phones")
    Do 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
    Loop
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].vehicles")
    Do 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
    Loop
    j = 0
    count_j = jsonResponse.SizeOfArray("data[i].products")
    Do While j < count_j
        jsonResponse.J = j
        j = j + 1
    Loop
    i = i + 1
Loop