Chilkat Examples

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

Delphi DLL Web API Examples

Primary Categories

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

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

 

 

 

(Delphi DLL) 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 non-ActiveX DLL for Delphi

Chilkat ActiveX DLL for Delphi

* The examples here use the non-ActiveX DLL.

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

...

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

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

http := CkHttp_Create();

CkHttp_putAuthToken(http,'ACCESS_TOKEN');

CkHttp_putAccept(http,'application/json');

strResp := CkHttp__quickGetStr(http,'https://crm.activix.ca/api/v2/leads/search?query=Doe');
if (CkHttp_getLastMethodSuccess(http) <> True) then
  begin
    Memo1.Lines.Add(CkHttp__lastErrorText(http));
    Exit;
  end;

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

jsonResponse := CkJsonObject_Create();
CkJsonObject_Load(jsonResponse,strResp);
CkJsonObject_putEmitCompact(jsonResponse,False);
Memo1.Lines.Add(CkJsonObject__emit(jsonResponse));

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

    j := 0;
    count_j := CkJsonObject_SizeOfArray(jsonResponse,'data[i].phones');
    while j < count_j do
      begin
        CkJsonObject_putJ(jsonResponse,j);
        id := CkJsonObject_IntOf(jsonResponse,'data[i].phones[j].id');
        created_at := CkJsonObject__stringOf(jsonResponse,'data[i].phones[j].created_at');
        updated_at := CkJsonObject__stringOf(jsonResponse,'data[i].phones[j].updated_at');
        lead_id := CkJsonObject_IntOf(jsonResponse,'data[i].phones[j].lead_id');
        extension := CkJsonObject__stringOf(jsonResponse,'data[i].phones[j].extension');
        number := CkJsonObject__stringOf(jsonResponse,'data[i].phones[j].number');
        v_type := CkJsonObject__stringOf(jsonResponse,'data[i].phones[j].type');
        valid := CkJsonObject_BoolOf(jsonResponse,'data[i].phones[j].valid');
        validated := CkJsonObject_BoolOf(jsonResponse,'data[i].phones[j].validated');
        mobile := CkJsonObject_BoolOf(jsonResponse,'data[i].phones[j].mobile');
        j := j + 1;
      end;

    j := 0;
    count_j := CkJsonObject_SizeOfArray(jsonResponse,'data[i].vehicles');
    while j < count_j do
      begin
        CkJsonObject_putJ(jsonResponse,j);
        id := CkJsonObject_IntOf(jsonResponse,'data[i].vehicles[j].id');
        created_at := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].created_at');
        updated_at := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].updated_at');
        lead_id := CkJsonObject_IntOf(jsonResponse,'data[i].vehicles[j].lead_id');
        accessories := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].accessories');
        allowed_odometer := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].allowed_odometer');
        balance := CkJsonObject_IntOf(jsonResponse,'data[i].vehicles[j].balance');
        budget_max := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].budget_max');
        budget_min := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].budget_min');
        cash_down := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].cash_down');
        category := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].category');
        category_rv := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].category_rv');
        client_number := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].client_number');
        color_exterior := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].color_exterior');
        color_interior := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].color_interior');
        comment := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].comment');
        condition := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].condition');
        end_contract_date := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].end_contract_date');
        end_warranty_date := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].end_warranty_date');
        engine := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].engine');
        extended_warranty := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].extended_warranty');
        fuel := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].fuel');
        length_max := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].length_max');
        length_min := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].length_min');
        license_plate := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].license_plate');
        make := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].make');
        modality := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].modality');
        model := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].model');
        odometer := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].odometer');
        offer_number := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].offer_number');
        v_option := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].option');
        order_number := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].order_number');
        payment := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].payment');
        payment_frequency := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].payment_frequency');
        preparation := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].preparation');
        price := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].price');
        profit := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].profit');
        purchase_date := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].purchase_date');
        rate := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].rate');
        recall := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].recall');
        recorded_date := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].recorded_date');
        residual := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].residual');
        security_deposit := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].security_deposit');
        sleeping := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].sleeping');
        sold := CkJsonObject_BoolOf(jsonResponse,'data[i].vehicles[j].sold');
        sold_by := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].sold_by');
        sold_date := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].sold_date');
        stock := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].stock');
        stock_state := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].stock_state');
        term := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].term');
        tire := CkJsonObject_BoolOf(jsonResponse,'data[i].vehicles[j].tire');
        transmission := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].transmission');
        trim := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].trim');
        v_type := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].type');
        url := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].url');
        value := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].value');
        vin := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].vin');
        warranty := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].warranty');
        weight := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].weight');
        year := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].year');
        year_max := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].year_max');
        year_min := CkJsonObject__stringOf(jsonResponse,'data[i].vehicles[j].year_min');
        j := j + 1;
      end;

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

    i := i + 1;
  end;

CkHttp_Dispose(http);
CkJsonObject_Dispose(jsonResponse);

end;

 

© 2000-2024 Chilkat Software, Inc. All Rights Reserved.