(Delphi ActiveX) 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 for Delphi Downloads Chilkat ActiveX DLL for Delphi Chilkat non-ActiveX DLL for Delphi * The examples here use the ActiveX DLL.

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

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

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

http := TChilkatHttp.Create(Self);

http.AuthToken := 'ACCESS_TOKEN';

http.Accept := 'application/json';

strResp := http.QuickGetStr('https://crm.activix.ca/api/v2/leads/search?query=Doe');
if (http.LastMethodSuccess <> 1) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

Memo1.Lines.Add('Response Status Code: ' + IntToStr(http.LastStatus));

jsonResponse := TChilkatJsonObject.Create(Self);
jsonResponse.Load(strResp);
jsonResponse.EmitCompact := 0;
Memo1.Lines.Add(jsonResponse.Emit());

if (http.LastStatus <> 200) then
  begin
    Memo1.Lines.Add('Failed.');
    Exit;
  end;

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

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 do
  begin
    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 do
      begin
        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;

    j := 0;
    count_j := jsonResponse.SizeOfArray('data[i].phones');
    while j < count_j do
      begin
        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;

    j := 0;
    count_j := jsonResponse.SizeOfArray('data[i].vehicles');
    while j < count_j do
      begin
        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;

    j := 0;
    count_j := jsonResponse.SizeOfArray('data[i].products');
    while j < count_j do
      begin
        jsonResponse.J := j;
        j := j + 1;
      end;

    i := i + 1;
  end;
end;