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

PowerBuilder 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

 

 

 

(PowerBuilder) Activix CRM Search for Leads

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

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

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
string ls_StrResp
oleobject loo_JsonResponse
string ls_LinksFirst
string ls_LinksLast
string ls_LinksPrev
string ls_LinksNext
integer li_MetaCurrent_page
integer li_MetaFrom
integer li_MetaLast_page
string ls_MetaPath
integer li_MetaPer_page
integer li_MetaTo
integer li_MetaTotal
integer i
integer li_Count_i
integer li_Id
string ls_Created_at
string ls_Updated_at
integer li_Account_id
string ls_Address_line1
string ls_Address_line2
string ls_Appointment_date
integer li_Appt_call
string ls_Available_date
string ls_Average_spending
string ls_Be_back_date
string ls_Birth_date
string ls_Business
string ls_Call_date
string ls_City
string ls_Civility
string ls_Code
string ls_Country
string ls_Csi_date
string ls_Delivered_by_id
string ls_Delivered_date
string ls_Delivery_date
string ls_Division
string ls_End_service_date
string ls_First_name
string ls_Gas
integer li_Gender
integer li_Invoiced
string ls_Last_name
string ls_Last_visit_date
string ls_Locale
string ls_Loyalty
string ls_Next_visit_date
string ls_Odometer_last_visit
string ls_Open_work_order_date
string ls_Planned_pick_up_date
string ls_Postal_code
string ls_Prepaid
integer li_Prepared
string ls_Presented_date
string ls_Promised_date
string ls_Province
string ls_Rating
integer li_Reached_client
string ls_Refinanced_date
string ls_Repair_date
string ls_Repair_order
string ls_Result
string ls_Road_test_date
string ls_Sale_date
string ls_Second_contact
string ls_Second_contact_civility
string ls_Segment
integer li_Service_cleaned
string ls_Service_interval_km
string ls_Service_monthly_km
string ls_Service_processIntention
string ls_Service_processTransport
string ls_Service_processWalk_around
string ls_Sex
string ls_Source
string ls_Status
string ls_Storage
string ls_Take_over_date
string ls_V_type
string ls_Unsubscribe_all_date
string ls_Unsubscribe_call_date
string ls_Unsubscribe_email_date
string ls_Unsubscribe_sms_date
string ls_Work_order
integer li_AccountId
string ls_AccountCreated_at
string ls_AccountUpdated_at
integer li_AccountPartner_id
integer li_AccountActivity_report
integer li_AccountCommercial
integer li_AccountEvent
integer li_AccountLeadxpress
integer li_AccountLoyalty
integer li_AccountPhone_up
integer li_AccountRenewal
integer li_AccountSale_table
integer li_AccountService
integer li_AccountWalk_in
integer li_AccountWebboost
integer li_AccountAccount_manager
string ls_AccountActivation_date
integer li_AccountActive
integer li_AccountAssigned_lead
integer li_AccountAuto_renewal
integer li_AccountAuto_renewal_new
integer li_AccountAuto_renewal_used
integer li_AccountAutomation
integer li_AccountBdc_advisor
integer li_AccountCalendar_options
integer li_AccountClient_card_fieldsProcessGas
integer li_AccountClient_card_fieldsProcessRecorded
integer li_AccountClient_card_fieldsProcessAvailable
integer li_AccountClient_card_fieldsProcessDiscounted
integer li_AccountClient_card_fieldsCommercialProfit
integer li_AccountClient_card_fieldsCommercialExclude
integer li_AccountClient_card_fieldsCommercialMeeting
integer li_AccountClient_card_fieldsPerformanceDeposit
integer li_AccountClient_card_fieldsPerformanceRefinanced
integer li_AccountClient_card_fieldsPerformanceDealer_tour
integer li_AccountClient_card_fieldsPerformanceWalk_around
integer li_AccountClient_card_fieldsPerformanceQualification
integer li_AccountClient_card_fieldsPerformanceTwenty_four_hour
integer li_AccountClient_card_fieldsGeneral_infoBudget
integer li_AccountClient_card_fieldsGeneral_infoSector
integer li_AccountClient_card_fieldsGeneral_infoCustom_1
integer li_AccountClient_card_fieldsGeneral_infoCustom_2
integer li_AccountClient_card_fieldsGeneral_infoCustom_3
integer li_AccountClient_card_fieldsGeneral_infoCustom_4
integer li_AccountClient_card_fieldsGeneral_infoCustom_5
integer li_AccountClient_card_fieldsGeneral_infoCustom_6
integer li_AccountClient_card_fieldsGeneral_infoCustom_7
integer li_AccountClient_card_fieldsGeneral_infoCustom_8
integer li_AccountClient_card_fieldsGeneral_infoCustom_9
integer li_AccountClient_card_fieldsGeneral_infoCustom_10
integer li_AccountClient_card_fieldsGeneral_infoCommunication_preference
integer li_AccountClient_card_fieldsWanted_vehicleVin
integer li_AccountClient_card_fieldsWanted_vehicleFuel
integer li_AccountClient_card_fieldsWanted_vehicleRate
integer li_AccountClient_card_fieldsWanted_vehicleTerm
integer li_AccountClient_card_fieldsWanted_vehicleTire
integer li_AccountClient_card_fieldsWanted_vehicleYear
integer li_AccountClient_card_fieldsWanted_vehicleColor
integer li_AccountClient_card_fieldsWanted_vehiclePrice
integer li_AccountClient_card_fieldsWanted_vehicleStock
integer li_AccountClient_card_fieldsWanted_vehicleTotal
integer li_AccountClient_card_fieldsWanted_vehicleBudget
integer li_AccountClient_card_fieldsWanted_vehicleEngine
integer li_AccountClient_card_fieldsWanted_vehicleLength
integer li_AccountClient_card_fieldsWanted_vehicleProfit
integer li_AccountClient_card_fieldsWanted_vehicleSuffix
integer li_AccountClient_card_fieldsWanted_vehicleWeight
integer li_AccountClient_card_fieldsWanted_vehicleComment
integer li_AccountClient_card_fieldsWanted_vehicleMileage
integer li_AccountClient_card_fieldsWanted_vehiclePayment
integer li_AccountClient_card_fieldsWanted_vehicleBodyType
integer li_AccountClient_card_fieldsWanted_vehicleCategory
integer li_AccountClient_card_fieldsWanted_vehicleModality
integer li_AccountClient_card_fieldsWanted_vehicleResidual
integer li_AccountClient_card_fieldsWanted_vehicleSleeping
integer li_AccountClient_card_fieldsWanted_vehicleWarranty
integer li_AccountClient_card_fieldsWanted_vehicleFrequency
integer li_AccountClient_card_fieldsWanted_vehicleAccessories
integer li_AccountClient_card_fieldsWanted_vehicleCategory_rv
integer li_AccountClient_card_fieldsWanted_vehiclePreparation
integer li_AccountClient_card_fieldsWanted_vehicleInitial_cash
integer li_AccountClient_card_fieldsWanted_vehicleOffer_number
integer li_AccountClient_card_fieldsWanted_vehicleOrder_number
integer li_AccountClient_card_fieldsWanted_vehicleTransmission
integer li_AccountClient_card_fieldsWanted_vehicleDocumentation
integer li_AccountClient_card_fieldsWanted_vehicleDrivingWheels
integer li_AccountClient_card_fieldsWanted_vehicleColor_exterior
integer li_AccountClient_card_fieldsWanted_vehicleColor_interior
integer li_AccountClient_card_fieldsWanted_vehicleAllowed_mileage
integer li_AccountClient_card_fieldsWanted_vehicleSecurity_deposit
integer li_AccountClient_card_fieldsWanted_vehicleEnd_contract_date
integer li_AccountClient_card_fieldsExchange_vehicleVin
integer li_AccountClient_card_fieldsExchange_vehicleFuel
integer li_AccountClient_card_fieldsExchange_vehicleLink
integer li_AccountClient_card_fieldsExchange_vehicleRate
integer li_AccountClient_card_fieldsExchange_vehicleTerm
integer li_AccountClient_card_fieldsExchange_vehicleYear
integer li_AccountClient_card_fieldsExchange_vehicleColor
integer li_AccountClient_card_fieldsExchange_vehiclePrice
integer li_AccountClient_card_fieldsExchange_vehicleStock
integer li_AccountClient_card_fieldsExchange_vehicleValue
integer li_AccountClient_card_fieldsExchange_vehicleBudget
integer li_AccountClient_card_fieldsExchange_vehicleEngine
integer li_AccountClient_card_fieldsExchange_vehicleLength
integer li_AccountClient_card_fieldsExchange_vehicleProfit
integer li_AccountClient_card_fieldsExchange_vehicleSuffix
integer li_AccountClient_card_fieldsExchange_vehicleWeight
integer li_AccountClient_card_fieldsExchange_vehicleBalance
integer li_AccountClient_card_fieldsExchange_vehicleComment
integer li_AccountClient_card_fieldsExchange_vehicleMileage
integer li_AccountClient_card_fieldsExchange_vehiclePayment
integer li_AccountClient_card_fieldsExchange_vehicleRenewal
integer li_AccountClient_card_fieldsExchange_vehicleSold_by
integer li_AccountClient_card_fieldsExchange_vehicleBodyType
integer li_AccountClient_card_fieldsExchange_vehicleCategory
integer li_AccountClient_card_fieldsExchange_vehicleModality
integer li_AccountClient_card_fieldsExchange_vehicleResidual
integer li_AccountClient_card_fieldsExchange_vehicleSleeping
integer li_AccountClient_card_fieldsExchange_vehicleWarranty
integer li_AccountClient_card_fieldsExchange_vehicleCondition
integer li_AccountClient_card_fieldsExchange_vehicleFrequency
integer li_AccountClient_card_fieldsExchange_vehicleIntention
integer li_AccountClient_card_fieldsExchange_vehicleRefinance
integer li_AccountClient_card_fieldsExchange_vehicleRequested
integer li_AccountClient_card_fieldsExchange_vehicleSold_date
integer li_AccountClient_card_fieldsExchange_vehicleCategory_rv
integer li_AccountClient_card_fieldsExchange_vehicleInstitution
integer li_AccountClient_card_fieldsExchange_vehicleInitial_cash
integer li_AccountClient_card_fieldsExchange_vehicleOffer_number
integer li_AccountClient_card_fieldsExchange_vehicleTransmission
integer li_AccountClient_card_fieldsExchange_vehicleDrivingWheels
integer li_AccountClient_card_fieldsExchange_vehicleColor_exterior
integer li_AccountClient_card_fieldsExchange_vehicleColor_interior
integer li_AccountClient_card_fieldsExchange_vehicleAllowed_mileage
integer li_AccountClient_card_fieldsExchange_vehicleSecurity_deposit
integer li_AccountClient_card_fieldsExchange_vehicleEnd_contract_date
integer li_AccountClient_number
integer li_AccountConfirmation_appt
integer li_AccountCredit
integer li_AccountCsi
integer li_AccountCsi_used
string ls_AccountDefault_deliveryman_user_id
integer li_AccountDelivered_by
integer li_AccountDisable_communication_audio
integer li_AccountDuplicates
integer li_AccountGuest_action
integer li_AccountEmail_client
integer li_AccountIn_turn
integer li_AccountIn_turn_director_management
integer li_AccountLeads_other_division
integer li_AccountLeadxpress_optionPriority
integer li_AccountLeadxpress_optionReminderFrequency
integer li_AccountLeadxpress_optionReminderRecurrence
integer li_AccountLeadxpress_optionScheduleAccount
integer li_AccountLeadxpress_optionScheduleAdvisor
integer li_AccountLimited_audio_access
string ls_AccountLogo
string ls_AccountLogo_en
integer li_AccountMandatory_coordinate
integer li_AccountManually_status
string ls_AccountMerge_rule
integer li_AccountMonth_start_day
string ls_AccountName
integer li_AccountNiotext
integer li_AccountNiotext_phone
string ls_AccountPhone
integer li_AccountPower_sport
integer li_AccountProcess
integer li_AccountRecreative_special
integer li_AccountResult_date_validation
integer li_AccountSale_accessories
integer li_AccountSale_by_phone
integer li_AccountSale_date_month
integer li_AccountSale_table_optionsAccessory_column
integer li_AccountSale_table_optionsCommercial_column
integer li_AccountSale_table_optionsDivision_grouped_total_column
integer li_AccountSale_validation
integer li_AccountScan
integer li_AccountStock_required_for_sale
integer li_AccountTake_over_director
integer li_AccountTrade_report
integer li_AccountUnrestricted_assignment
integer li_AccountUnsubscribe
integer li_AccountUntreated_lead
integer li_AccountVehicle_model_text
integer li_AccountVehicle_text
integer li_AccountVerified_sale
integer li_AccountVin_decoder
string ls_AccountWaiting_sale_date
integer li_AccountWaiting_sale_option
string ls_Advisor
integer j
integer li_Count_j
integer li_Lead_id
string ls_Address
integer li_Valid
string ls_Extension
string ls_Number
integer li_Validated
integer li_Mobile
string ls_Accessories
string ls_Allowed_odometer
integer li_Balance
string ls_Budget_max
string ls_Budget_min
string ls_Cash_down
string ls_Category
string ls_Category_rv
string ls_Client_number
string ls_Color_exterior
string ls_Color_interior
string ls_Comment
string ls_Condition
string ls_End_contract_date
string ls_End_warranty_date
string ls_Engine
string ls_Extended_warranty
string ls_Fuel
string ls_Length_max
string ls_Length_min
string ls_License_plate
string ls_Make
string ls_Modality
string ls_Model
string ls_Odometer
string ls_Offer_number
string ls_V_option
string ls_Order_number
string ls_Payment
string ls_Payment_frequency
string ls_Preparation
string ls_Price
string ls_Profit
string ls_Purchase_date
string ls_Rate
string ls_Recall
string ls_Recorded_date
string ls_Residual
string ls_Security_deposit
string ls_Sleeping
integer li_Sold
string ls_Sold_by
string ls_Sold_date
string ls_Stock
string ls_Stock_state
string ls_Term
integer li_Tire
string ls_Transmission
string ls_Trim
string ls_Url
string ls_Value
string ls_Vin
string ls_Warranty
string ls_Weight
string ls_Year
string ls_Year_max
string ls_Year_min

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.AuthToken = "ACCESS_TOKEN"

loo_Http.Accept = "application/json"

ls_StrResp = loo_Http.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe")
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    return
end if

Write-Debug "Response Status Code: " + string(loo_Http.LastStatus)

loo_JsonResponse = create oleobject
li_rc = loo_JsonResponse.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_JsonResponse.Load(ls_StrResp)
loo_JsonResponse.EmitCompact = 0
Write-Debug loo_JsonResponse.Emit()

if loo_Http.LastStatus <> 200 then
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_JsonResponse
    return
end if

// Sample output...
// (See the parsing code below..)
// 
// Use this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON

// {
//     "data": [
//         {
//             "id": 3387562,
//             "created_at": "2018-04-09T18:05:00+00:00",
//             "updated_at": "2018-04-09T18:07:00+00:00",
//             "first_name": "John",
//             "last_name": "Doe",
//             ...
//             "account": {
//                 "id": 66,
//                 ...
//             },
//             "advisor": {
//                 "id": 51112,
//                 ...
//             },
//             "emails": [
//                 {
//                     "id": 3664451,
//                     ...
//                 },
//                 ...
//             ],
//             "phones": [
//                 {
//                     "id": 9465546,
//                     ...
//                 },
//                 ...
//             ],
//             "vehicles": [
//                 {
//                     "id": 4542214,
//                     ...
//                 },
//                 ...
//             ]
//         },
//         ...
//     ],
//     "links": {
//         "first": "https://crm.activix.ca/api/v2/leads/search?query=John&page=1",
//         "last": "https://crm.activix.ca/api/v2/leads/search?query=John&page=47",
//         "prev": null,
//         "next": "https://crm.activix.ca/api/v2/leads/search?query=John&page=2"
//     },
//     "meta": {
//         "current_page": 1,
//         "from": 1,
//         "last_page": 47,
//         "path": "https://crm.activix.ca/api/v2/leads/search",
//         "per_page": 25,
//         "to": 25,
//         "total": 1161
//     }
// }

ls_LinksFirst = loo_JsonResponse.StringOf("links.first")
ls_LinksLast = loo_JsonResponse.StringOf("links.last")
ls_LinksPrev = loo_JsonResponse.StringOf("links.prev")
ls_LinksNext = loo_JsonResponse.StringOf("links.next")
li_MetaCurrent_page = loo_JsonResponse.IntOf("meta.current_page")
li_MetaFrom = loo_JsonResponse.IntOf("meta.from")
li_MetaLast_page = loo_JsonResponse.IntOf("meta.last_page")
ls_MetaPath = loo_JsonResponse.StringOf("meta.path")
li_MetaPer_page = loo_JsonResponse.IntOf("meta.per_page")
li_MetaTo = loo_JsonResponse.IntOf("meta.to")
li_MetaTotal = loo_JsonResponse.IntOf("meta.total")
i = 0
li_Count_i = loo_JsonResponse.SizeOfArray("data")
do while i < li_Count_i
    loo_JsonResponse.I = i
    li_Id = loo_JsonResponse.IntOf("data[i].id")
    ls_Created_at = loo_JsonResponse.StringOf("data[i].created_at")
    ls_Updated_at = loo_JsonResponse.StringOf("data[i].updated_at")
    li_Account_id = loo_JsonResponse.IntOf("data[i].account_id")
    ls_Address_line1 = loo_JsonResponse.StringOf("data[i].address_line1")
    ls_Address_line2 = loo_JsonResponse.StringOf("data[i].address_line2")
    ls_Appointment_date = loo_JsonResponse.StringOf("data[i].appointment_date")
    li_Appt_call = loo_JsonResponse.BoolOf("data[i].appt_call")
    ls_Available_date = loo_JsonResponse.StringOf("data[i].available_date")
    ls_Average_spending = loo_JsonResponse.StringOf("data[i].average_spending")
    ls_Be_back_date = loo_JsonResponse.StringOf("data[i].be_back_date")
    ls_Birth_date = loo_JsonResponse.StringOf("data[i].birth_date")
    ls_Business = loo_JsonResponse.StringOf("data[i].business")
    ls_Call_date = loo_JsonResponse.StringOf("data[i].call_date")
    ls_City = loo_JsonResponse.StringOf("data[i].city")
    ls_Civility = loo_JsonResponse.StringOf("data[i].civility")
    ls_Code = loo_JsonResponse.StringOf("data[i].code")
    ls_Country = loo_JsonResponse.StringOf("data[i].country")
    ls_Csi_date = loo_JsonResponse.StringOf("data[i].csi_date")
    ls_Delivered_by_id = loo_JsonResponse.StringOf("data[i].delivered_by_id")
    ls_Delivered_date = loo_JsonResponse.StringOf("data[i].delivered_date")
    ls_Delivery_date = loo_JsonResponse.StringOf("data[i].delivery_date")
    ls_Division = loo_JsonResponse.StringOf("data[i].division")
    ls_End_service_date = loo_JsonResponse.StringOf("data[i].end_service_date")
    ls_First_name = loo_JsonResponse.StringOf("data[i].first_name")
    ls_Gas = loo_JsonResponse.StringOf("data[i].gas")
    li_Gender = loo_JsonResponse.IntOf("data[i].gender")
    li_Invoiced = loo_JsonResponse.BoolOf("data[i].invoiced")
    ls_Last_name = loo_JsonResponse.StringOf("data[i].last_name")
    ls_Last_visit_date = loo_JsonResponse.StringOf("data[i].last_visit_date")
    ls_Locale = loo_JsonResponse.StringOf("data[i].locale")
    ls_Loyalty = loo_JsonResponse.StringOf("data[i].loyalty")
    ls_Next_visit_date = loo_JsonResponse.StringOf("data[i].next_visit_date")
    ls_Odometer_last_visit = loo_JsonResponse.StringOf("data[i].odometer_last_visit")
    ls_Open_work_order_date = loo_JsonResponse.StringOf("data[i].open_work_order_date")
    ls_Planned_pick_up_date = loo_JsonResponse.StringOf("data[i].planned_pick_up_date")
    ls_Postal_code = loo_JsonResponse.StringOf("data[i].postal_code")
    ls_Prepaid = loo_JsonResponse.StringOf("data[i].prepaid")
    li_Prepared = loo_JsonResponse.BoolOf("data[i].prepared")
    ls_Presented_date = loo_JsonResponse.StringOf("data[i].presented_date")
    ls_Promised_date = loo_JsonResponse.StringOf("data[i].promised_date")
    ls_Province = loo_JsonResponse.StringOf("data[i].province")
    ls_Rating = loo_JsonResponse.StringOf("data[i].rating")
    li_Reached_client = loo_JsonResponse.BoolOf("data[i].reached_client")
    ls_Refinanced_date = loo_JsonResponse.StringOf("data[i].refinanced_date")
    ls_Repair_date = loo_JsonResponse.StringOf("data[i].repair_date")
    ls_Repair_order = loo_JsonResponse.StringOf("data[i].repair_order")
    ls_Result = loo_JsonResponse.StringOf("data[i].result")
    ls_Road_test_date = loo_JsonResponse.StringOf("data[i].road_test_date")
    ls_Sale_date = loo_JsonResponse.StringOf("data[i].sale_date")
    ls_Second_contact = loo_JsonResponse.StringOf("data[i].second_contact")
    ls_Second_contact_civility = loo_JsonResponse.StringOf("data[i].second_contact_civility")
    ls_Segment = loo_JsonResponse.StringOf("data[i].segment")
    li_Service_cleaned = loo_JsonResponse.BoolOf("data[i].service_cleaned")
    ls_Service_interval_km = loo_JsonResponse.StringOf("data[i].service_interval_km")
    ls_Service_monthly_km = loo_JsonResponse.StringOf("data[i].service_monthly_km")
    ls_Service_processIntention = loo_JsonResponse.StringOf("data[i].service_process.intention")
    ls_Service_processTransport = loo_JsonResponse.StringOf("data[i].service_process.transport")
    ls_Service_processWalk_around = loo_JsonResponse.StringOf("data[i].service_process.walk_around")
    ls_Sex = loo_JsonResponse.StringOf("data[i].sex")
    ls_Source = loo_JsonResponse.StringOf("data[i].source")
    ls_Status = loo_JsonResponse.StringOf("data[i].status")
    ls_Storage = loo_JsonResponse.StringOf("data[i].storage")
    ls_Take_over_date = loo_JsonResponse.StringOf("data[i].take_over_date")
    ls_V_type = loo_JsonResponse.StringOf("data[i].type")
    ls_Unsubscribe_all_date = loo_JsonResponse.StringOf("data[i].unsubscribe_all_date")
    ls_Unsubscribe_call_date = loo_JsonResponse.StringOf("data[i].unsubscribe_call_date")
    ls_Unsubscribe_email_date = loo_JsonResponse.StringOf("data[i].unsubscribe_email_date")
    ls_Unsubscribe_sms_date = loo_JsonResponse.StringOf("data[i].unsubscribe_sms_date")
    ls_Work_order = loo_JsonResponse.StringOf("data[i].work_order")
    li_AccountId = loo_JsonResponse.IntOf("data[i].account.id")
    ls_AccountCreated_at = loo_JsonResponse.StringOf("data[i].account.created_at")
    ls_AccountUpdated_at = loo_JsonResponse.StringOf("data[i].account.updated_at")
    li_AccountPartner_id = loo_JsonResponse.IntOf("data[i].account.partner_id")
    li_AccountActivity_report = loo_JsonResponse.BoolOf("data[i].account.activity_report")
    li_AccountCommercial = loo_JsonResponse.BoolOf("data[i].account.commercial")
    li_AccountEvent = loo_JsonResponse.BoolOf("data[i].account.event")
    li_AccountLeadxpress = loo_JsonResponse.BoolOf("data[i].account.leadxpress")
    li_AccountLoyalty = loo_JsonResponse.BoolOf("data[i].account.loyalty")
    li_AccountPhone_up = loo_JsonResponse.BoolOf("data[i].account.phone_up")
    li_AccountRenewal = loo_JsonResponse.BoolOf("data[i].account.renewal")
    li_AccountSale_table = loo_JsonResponse.BoolOf("data[i].account.sale_table")
    li_AccountService = loo_JsonResponse.BoolOf("data[i].account.service")
    li_AccountWalk_in = loo_JsonResponse.BoolOf("data[i].account.walk_in")
    li_AccountWebboost = loo_JsonResponse.BoolOf("data[i].account.webboost")
    li_AccountAccount_manager = loo_JsonResponse.BoolOf("data[i].account.account_manager")
    ls_AccountActivation_date = loo_JsonResponse.StringOf("data[i].account.activation_date")
    li_AccountActive = loo_JsonResponse.BoolOf("data[i].account.active")
    li_AccountAssigned_lead = loo_JsonResponse.BoolOf("data[i].account.assigned_lead")
    li_AccountAuto_renewal = loo_JsonResponse.BoolOf("data[i].account.auto_renewal")
    li_AccountAuto_renewal_new = loo_JsonResponse.BoolOf("data[i].account.auto_renewal_new")
    li_AccountAuto_renewal_used = loo_JsonResponse.BoolOf("data[i].account.auto_renewal_used")
    li_AccountAutomation = loo_JsonResponse.BoolOf("data[i].account.automation")
    li_AccountBdc_advisor = loo_JsonResponse.BoolOf("data[i].account.bdc_advisor")
    li_AccountCalendar_options = loo_JsonResponse.BoolOf("data[i].account.calendar_options")
    li_AccountClient_card_fieldsProcessGas = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.gas")
    li_AccountClient_card_fieldsProcessRecorded = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded")
    li_AccountClient_card_fieldsProcessAvailable = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.available")
    li_AccountClient_card_fieldsProcessDiscounted = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted")
    li_AccountClient_card_fieldsCommercialProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit")
    li_AccountClient_card_fieldsCommercialExclude = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude")
    li_AccountClient_card_fieldsCommercialMeeting = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting")
    li_AccountClient_card_fieldsPerformanceDeposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit")
    li_AccountClient_card_fieldsPerformanceRefinanced = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced")
    li_AccountClient_card_fieldsPerformanceDealer_tour = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour")
    li_AccountClient_card_fieldsPerformanceWalk_around = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around")
    li_AccountClient_card_fieldsPerformanceQualification = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification")
    li_AccountClient_card_fieldsPerformanceTwenty_four_hour = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour")
    li_AccountClient_card_fieldsGeneral_infoBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget")
    li_AccountClient_card_fieldsGeneral_infoSector = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector")
    li_AccountClient_card_fieldsGeneral_infoCustom_1 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1")
    li_AccountClient_card_fieldsGeneral_infoCustom_2 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2")
    li_AccountClient_card_fieldsGeneral_infoCustom_3 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3")
    li_AccountClient_card_fieldsGeneral_infoCustom_4 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4")
    li_AccountClient_card_fieldsGeneral_infoCustom_5 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5")
    li_AccountClient_card_fieldsGeneral_infoCustom_6 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6")
    li_AccountClient_card_fieldsGeneral_infoCustom_7 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7")
    li_AccountClient_card_fieldsGeneral_infoCustom_8 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8")
    li_AccountClient_card_fieldsGeneral_infoCustom_9 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9")
    li_AccountClient_card_fieldsGeneral_infoCustom_10 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10")
    li_AccountClient_card_fieldsGeneral_infoCommunication_preference = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference")
    li_AccountClient_card_fieldsWanted_vehicleVin = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin")
    li_AccountClient_card_fieldsWanted_vehicleFuel = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel")
    li_AccountClient_card_fieldsWanted_vehicleRate = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate")
    li_AccountClient_card_fieldsWanted_vehicleTerm = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term")
    li_AccountClient_card_fieldsWanted_vehicleTire = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire")
    li_AccountClient_card_fieldsWanted_vehicleYear = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year")
    li_AccountClient_card_fieldsWanted_vehicleColor = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color")
    li_AccountClient_card_fieldsWanted_vehiclePrice = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price")
    li_AccountClient_card_fieldsWanted_vehicleStock = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock")
    li_AccountClient_card_fieldsWanted_vehicleTotal = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total")
    li_AccountClient_card_fieldsWanted_vehicleBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget")
    li_AccountClient_card_fieldsWanted_vehicleEngine = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine")
    li_AccountClient_card_fieldsWanted_vehicleLength = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length")
    li_AccountClient_card_fieldsWanted_vehicleProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit")
    li_AccountClient_card_fieldsWanted_vehicleSuffix = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix")
    li_AccountClient_card_fieldsWanted_vehicleWeight = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight")
    li_AccountClient_card_fieldsWanted_vehicleComment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment")
    li_AccountClient_card_fieldsWanted_vehicleMileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage")
    li_AccountClient_card_fieldsWanted_vehiclePayment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment")
    li_AccountClient_card_fieldsWanted_vehicleBodyType = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType")
    li_AccountClient_card_fieldsWanted_vehicleCategory = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category")
    li_AccountClient_card_fieldsWanted_vehicleModality = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality")
    li_AccountClient_card_fieldsWanted_vehicleResidual = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual")
    li_AccountClient_card_fieldsWanted_vehicleSleeping = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping")
    li_AccountClient_card_fieldsWanted_vehicleWarranty = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty")
    li_AccountClient_card_fieldsWanted_vehicleFrequency = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency")
    li_AccountClient_card_fieldsWanted_vehicleAccessories = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories")
    li_AccountClient_card_fieldsWanted_vehicleCategory_rv = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv")
    li_AccountClient_card_fieldsWanted_vehiclePreparation = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation")
    li_AccountClient_card_fieldsWanted_vehicleInitial_cash = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash")
    li_AccountClient_card_fieldsWanted_vehicleOffer_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number")
    li_AccountClient_card_fieldsWanted_vehicleOrder_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number")
    li_AccountClient_card_fieldsWanted_vehicleTransmission = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission")
    li_AccountClient_card_fieldsWanted_vehicleDocumentation = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation")
    li_AccountClient_card_fieldsWanted_vehicleDrivingWheels = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels")
    li_AccountClient_card_fieldsWanted_vehicleColor_exterior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior")
    li_AccountClient_card_fieldsWanted_vehicleColor_interior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior")
    li_AccountClient_card_fieldsWanted_vehicleAllowed_mileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage")
    li_AccountClient_card_fieldsWanted_vehicleSecurity_deposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit")
    li_AccountClient_card_fieldsWanted_vehicleEnd_contract_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date")
    li_AccountClient_card_fieldsExchange_vehicleVin = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin")
    li_AccountClient_card_fieldsExchange_vehicleFuel = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel")
    li_AccountClient_card_fieldsExchange_vehicleLink = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link")
    li_AccountClient_card_fieldsExchange_vehicleRate = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate")
    li_AccountClient_card_fieldsExchange_vehicleTerm = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term")
    li_AccountClient_card_fieldsExchange_vehicleYear = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year")
    li_AccountClient_card_fieldsExchange_vehicleColor = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color")
    li_AccountClient_card_fieldsExchange_vehiclePrice = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price")
    li_AccountClient_card_fieldsExchange_vehicleStock = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock")
    li_AccountClient_card_fieldsExchange_vehicleValue = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value")
    li_AccountClient_card_fieldsExchange_vehicleBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget")
    li_AccountClient_card_fieldsExchange_vehicleEngine = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine")
    li_AccountClient_card_fieldsExchange_vehicleLength = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length")
    li_AccountClient_card_fieldsExchange_vehicleProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit")
    li_AccountClient_card_fieldsExchange_vehicleSuffix = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix")
    li_AccountClient_card_fieldsExchange_vehicleWeight = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight")
    li_AccountClient_card_fieldsExchange_vehicleBalance = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance")
    li_AccountClient_card_fieldsExchange_vehicleComment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment")
    li_AccountClient_card_fieldsExchange_vehicleMileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage")
    li_AccountClient_card_fieldsExchange_vehiclePayment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment")
    li_AccountClient_card_fieldsExchange_vehicleRenewal = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal")
    li_AccountClient_card_fieldsExchange_vehicleSold_by = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by")
    li_AccountClient_card_fieldsExchange_vehicleBodyType = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType")
    li_AccountClient_card_fieldsExchange_vehicleCategory = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category")
    li_AccountClient_card_fieldsExchange_vehicleModality = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality")
    li_AccountClient_card_fieldsExchange_vehicleResidual = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual")
    li_AccountClient_card_fieldsExchange_vehicleSleeping = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping")
    li_AccountClient_card_fieldsExchange_vehicleWarranty = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty")
    li_AccountClient_card_fieldsExchange_vehicleCondition = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition")
    li_AccountClient_card_fieldsExchange_vehicleFrequency = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency")
    li_AccountClient_card_fieldsExchange_vehicleIntention = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention")
    li_AccountClient_card_fieldsExchange_vehicleRefinance = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance")
    li_AccountClient_card_fieldsExchange_vehicleRequested = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested")
    li_AccountClient_card_fieldsExchange_vehicleSold_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date")
    li_AccountClient_card_fieldsExchange_vehicleCategory_rv = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv")
    li_AccountClient_card_fieldsExchange_vehicleInstitution = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution")
    li_AccountClient_card_fieldsExchange_vehicleInitial_cash = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash")
    li_AccountClient_card_fieldsExchange_vehicleOffer_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number")
    li_AccountClient_card_fieldsExchange_vehicleTransmission = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission")
    li_AccountClient_card_fieldsExchange_vehicleDrivingWheels = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels")
    li_AccountClient_card_fieldsExchange_vehicleColor_exterior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior")
    li_AccountClient_card_fieldsExchange_vehicleColor_interior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior")
    li_AccountClient_card_fieldsExchange_vehicleAllowed_mileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage")
    li_AccountClient_card_fieldsExchange_vehicleSecurity_deposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit")
    li_AccountClient_card_fieldsExchange_vehicleEnd_contract_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date")
    li_AccountClient_number = loo_JsonResponse.BoolOf("data[i].account.client_number")
    li_AccountConfirmation_appt = loo_JsonResponse.BoolOf("data[i].account.confirmation_appt")
    li_AccountCredit = loo_JsonResponse.BoolOf("data[i].account.credit")
    li_AccountCsi = loo_JsonResponse.BoolOf("data[i].account.csi")
    li_AccountCsi_used = loo_JsonResponse.BoolOf("data[i].account.csi_used")
    ls_AccountDefault_deliveryman_user_id = loo_JsonResponse.StringOf("data[i].account.default_deliveryman_user_id")
    li_AccountDelivered_by = loo_JsonResponse.BoolOf("data[i].account.delivered_by")
    li_AccountDisable_communication_audio = loo_JsonResponse.BoolOf("data[i].account.disable_communication_audio")
    li_AccountDuplicates = loo_JsonResponse.BoolOf("data[i].account.duplicates")
    li_AccountGuest_action = loo_JsonResponse.BoolOf("data[i].account.guest_action")
    li_AccountEmail_client = loo_JsonResponse.BoolOf("data[i].account.email_client")
    li_AccountIn_turn = loo_JsonResponse.BoolOf("data[i].account.in_turn")
    li_AccountIn_turn_director_management = loo_JsonResponse.BoolOf("data[i].account.in_turn_director_management")
    li_AccountLeads_other_division = loo_JsonResponse.BoolOf("data[i].account.leads_other_division")
    li_AccountLeadxpress_optionPriority = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.priority")
    li_AccountLeadxpress_optionReminderFrequency = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency")
    li_AccountLeadxpress_optionReminderRecurrence = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence")
    li_AccountLeadxpress_optionScheduleAccount = loo_JsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account")
    li_AccountLeadxpress_optionScheduleAdvisor = loo_JsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor")
    li_AccountLimited_audio_access = loo_JsonResponse.BoolOf("data[i].account.limited_audio_access")
    ls_AccountLogo = loo_JsonResponse.StringOf("data[i].account.logo")
    ls_AccountLogo_en = loo_JsonResponse.StringOf("data[i].account.logo_en")
    li_AccountMandatory_coordinate = loo_JsonResponse.BoolOf("data[i].account.mandatory_coordinate")
    li_AccountManually_status = loo_JsonResponse.BoolOf("data[i].account.manually_status")
    ls_AccountMerge_rule = loo_JsonResponse.StringOf("data[i].account.merge_rule")
    li_AccountMonth_start_day = loo_JsonResponse.IntOf("data[i].account.month_start_day")
    ls_AccountName = loo_JsonResponse.StringOf("data[i].account.name")
    li_AccountNiotext = loo_JsonResponse.BoolOf("data[i].account.niotext")
    li_AccountNiotext_phone = loo_JsonResponse.BoolOf("data[i].account.niotext_phone")
    ls_AccountPhone = loo_JsonResponse.StringOf("data[i].account.phone")
    li_AccountPower_sport = loo_JsonResponse.BoolOf("data[i].account.power_sport")
    li_AccountProcess = loo_JsonResponse.BoolOf("data[i].account.process")
    li_AccountRecreative_special = loo_JsonResponse.BoolOf("data[i].account.recreative_special")
    li_AccountResult_date_validation = loo_JsonResponse.BoolOf("data[i].account.result_date_validation")
    li_AccountSale_accessories = loo_JsonResponse.BoolOf("data[i].account.sale_accessories")
    li_AccountSale_by_phone = loo_JsonResponse.BoolOf("data[i].account.sale_by_phone")
    li_AccountSale_date_month = loo_JsonResponse.BoolOf("data[i].account.sale_date_month")
    li_AccountSale_table_optionsAccessory_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column")
    li_AccountSale_table_optionsCommercial_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column")
    li_AccountSale_table_optionsDivision_grouped_total_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column")
    li_AccountSale_validation = loo_JsonResponse.BoolOf("data[i].account.sale_validation")
    li_AccountScan = loo_JsonResponse.BoolOf("data[i].account.scan")
    li_AccountStock_required_for_sale = loo_JsonResponse.BoolOf("data[i].account.stock_required_for_sale")
    li_AccountTake_over_director = loo_JsonResponse.BoolOf("data[i].account.take_over_director")
    li_AccountTrade_report = loo_JsonResponse.BoolOf("data[i].account.trade_report")
    li_AccountUnrestricted_assignment = loo_JsonResponse.BoolOf("data[i].account.unrestricted_assignment")
    li_AccountUnsubscribe = loo_JsonResponse.BoolOf("data[i].account.unsubscribe")
    li_AccountUntreated_lead = loo_JsonResponse.BoolOf("data[i].account.untreated_lead")
    li_AccountVehicle_model_text = loo_JsonResponse.BoolOf("data[i].account.vehicle_model_text")
    li_AccountVehicle_text = loo_JsonResponse.BoolOf("data[i].account.vehicle_text")
    li_AccountVerified_sale = loo_JsonResponse.BoolOf("data[i].account.verified_sale")
    li_AccountVin_decoder = loo_JsonResponse.BoolOf("data[i].account.vin_decoder")
    ls_AccountWaiting_sale_date = loo_JsonResponse.StringOf("data[i].account.waiting_sale_date")
    li_AccountWaiting_sale_option = loo_JsonResponse.BoolOf("data[i].account.waiting_sale_option")
    ls_Advisor = loo_JsonResponse.StringOf("data[i].advisor")
    j = 0
    li_Count_j = loo_JsonResponse.SizeOfArray("data[i].emails")
    do while j < li_Count_j
        loo_JsonResponse.J = j
        li_Id = loo_JsonResponse.IntOf("data[i].emails[j].id")
        ls_Created_at = loo_JsonResponse.StringOf("data[i].emails[j].created_at")
        ls_Updated_at = loo_JsonResponse.StringOf("data[i].emails[j].updated_at")
        li_Lead_id = loo_JsonResponse.IntOf("data[i].emails[j].lead_id")
        ls_Address = loo_JsonResponse.StringOf("data[i].emails[j].address")
        ls_V_type = loo_JsonResponse.StringOf("data[i].emails[j].type")
        li_Valid = loo_JsonResponse.BoolOf("data[i].emails[j].valid")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JsonResponse.SizeOfArray("data[i].phones")
    do while j < li_Count_j
        loo_JsonResponse.J = j
        li_Id = loo_JsonResponse.IntOf("data[i].phones[j].id")
        ls_Created_at = loo_JsonResponse.StringOf("data[i].phones[j].created_at")
        ls_Updated_at = loo_JsonResponse.StringOf("data[i].phones[j].updated_at")
        li_Lead_id = loo_JsonResponse.IntOf("data[i].phones[j].lead_id")
        ls_Extension = loo_JsonResponse.StringOf("data[i].phones[j].extension")
        ls_Number = loo_JsonResponse.StringOf("data[i].phones[j].number")
        ls_V_type = loo_JsonResponse.StringOf("data[i].phones[j].type")
        li_Valid = loo_JsonResponse.BoolOf("data[i].phones[j].valid")
        li_Validated = loo_JsonResponse.BoolOf("data[i].phones[j].validated")
        li_Mobile = loo_JsonResponse.BoolOf("data[i].phones[j].mobile")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JsonResponse.SizeOfArray("data[i].vehicles")
    do while j < li_Count_j
        loo_JsonResponse.J = j
        li_Id = loo_JsonResponse.IntOf("data[i].vehicles[j].id")
        ls_Created_at = loo_JsonResponse.StringOf("data[i].vehicles[j].created_at")
        ls_Updated_at = loo_JsonResponse.StringOf("data[i].vehicles[j].updated_at")
        li_Lead_id = loo_JsonResponse.IntOf("data[i].vehicles[j].lead_id")
        ls_Accessories = loo_JsonResponse.StringOf("data[i].vehicles[j].accessories")
        ls_Allowed_odometer = loo_JsonResponse.StringOf("data[i].vehicles[j].allowed_odometer")
        li_Balance = loo_JsonResponse.IntOf("data[i].vehicles[j].balance")
        ls_Budget_max = loo_JsonResponse.StringOf("data[i].vehicles[j].budget_max")
        ls_Budget_min = loo_JsonResponse.StringOf("data[i].vehicles[j].budget_min")
        ls_Cash_down = loo_JsonResponse.StringOf("data[i].vehicles[j].cash_down")
        ls_Category = loo_JsonResponse.StringOf("data[i].vehicles[j].category")
        ls_Category_rv = loo_JsonResponse.StringOf("data[i].vehicles[j].category_rv")
        ls_Client_number = loo_JsonResponse.StringOf("data[i].vehicles[j].client_number")
        ls_Color_exterior = loo_JsonResponse.StringOf("data[i].vehicles[j].color_exterior")
        ls_Color_interior = loo_JsonResponse.StringOf("data[i].vehicles[j].color_interior")
        ls_Comment = loo_JsonResponse.StringOf("data[i].vehicles[j].comment")
        ls_Condition = loo_JsonResponse.StringOf("data[i].vehicles[j].condition")
        ls_End_contract_date = loo_JsonResponse.StringOf("data[i].vehicles[j].end_contract_date")
        ls_End_warranty_date = loo_JsonResponse.StringOf("data[i].vehicles[j].end_warranty_date")
        ls_Engine = loo_JsonResponse.StringOf("data[i].vehicles[j].engine")
        ls_Extended_warranty = loo_JsonResponse.StringOf("data[i].vehicles[j].extended_warranty")
        ls_Fuel = loo_JsonResponse.StringOf("data[i].vehicles[j].fuel")
        ls_Length_max = loo_JsonResponse.StringOf("data[i].vehicles[j].length_max")
        ls_Length_min = loo_JsonResponse.StringOf("data[i].vehicles[j].length_min")
        ls_License_plate = loo_JsonResponse.StringOf("data[i].vehicles[j].license_plate")
        ls_Make = loo_JsonResponse.StringOf("data[i].vehicles[j].make")
        ls_Modality = loo_JsonResponse.StringOf("data[i].vehicles[j].modality")
        ls_Model = loo_JsonResponse.StringOf("data[i].vehicles[j].model")
        ls_Odometer = loo_JsonResponse.StringOf("data[i].vehicles[j].odometer")
        ls_Offer_number = loo_JsonResponse.StringOf("data[i].vehicles[j].offer_number")
        ls_V_option = loo_JsonResponse.StringOf("data[i].vehicles[j].option")
        ls_Order_number = loo_JsonResponse.StringOf("data[i].vehicles[j].order_number")
        ls_Payment = loo_JsonResponse.StringOf("data[i].vehicles[j].payment")
        ls_Payment_frequency = loo_JsonResponse.StringOf("data[i].vehicles[j].payment_frequency")
        ls_Preparation = loo_JsonResponse.StringOf("data[i].vehicles[j].preparation")
        ls_Price = loo_JsonResponse.StringOf("data[i].vehicles[j].price")
        ls_Profit = loo_JsonResponse.StringOf("data[i].vehicles[j].profit")
        ls_Purchase_date = loo_JsonResponse.StringOf("data[i].vehicles[j].purchase_date")
        ls_Rate = loo_JsonResponse.StringOf("data[i].vehicles[j].rate")
        ls_Recall = loo_JsonResponse.StringOf("data[i].vehicles[j].recall")
        ls_Recorded_date = loo_JsonResponse.StringOf("data[i].vehicles[j].recorded_date")
        ls_Residual = loo_JsonResponse.StringOf("data[i].vehicles[j].residual")
        ls_Security_deposit = loo_JsonResponse.StringOf("data[i].vehicles[j].security_deposit")
        ls_Sleeping = loo_JsonResponse.StringOf("data[i].vehicles[j].sleeping")
        li_Sold = loo_JsonResponse.BoolOf("data[i].vehicles[j].sold")
        ls_Sold_by = loo_JsonResponse.StringOf("data[i].vehicles[j].sold_by")
        ls_Sold_date = loo_JsonResponse.StringOf("data[i].vehicles[j].sold_date")
        ls_Stock = loo_JsonResponse.StringOf("data[i].vehicles[j].stock")
        ls_Stock_state = loo_JsonResponse.StringOf("data[i].vehicles[j].stock_state")
        ls_Term = loo_JsonResponse.StringOf("data[i].vehicles[j].term")
        li_Tire = loo_JsonResponse.BoolOf("data[i].vehicles[j].tire")
        ls_Transmission = loo_JsonResponse.StringOf("data[i].vehicles[j].transmission")
        ls_Trim = loo_JsonResponse.StringOf("data[i].vehicles[j].trim")
        ls_V_type = loo_JsonResponse.StringOf("data[i].vehicles[j].type")
        ls_Url = loo_JsonResponse.StringOf("data[i].vehicles[j].url")
        ls_Value = loo_JsonResponse.StringOf("data[i].vehicles[j].value")
        ls_Vin = loo_JsonResponse.StringOf("data[i].vehicles[j].vin")
        ls_Warranty = loo_JsonResponse.StringOf("data[i].vehicles[j].warranty")
        ls_Weight = loo_JsonResponse.StringOf("data[i].vehicles[j].weight")
        ls_Year = loo_JsonResponse.StringOf("data[i].vehicles[j].year")
        ls_Year_max = loo_JsonResponse.StringOf("data[i].vehicles[j].year_max")
        ls_Year_min = loo_JsonResponse.StringOf("data[i].vehicles[j].year_min")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JsonResponse.SizeOfArray("data[i].products")
    do while j < li_Count_j
        loo_JsonResponse.J = j
        j = j + 1
    loop
    i = i + 1
loop


destroy loo_Http
destroy loo_JsonResponse

 

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