Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Web API Examples

Primary Categories

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

MedTunnel
MercadoLibre
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
Moody's
Okta OAuth/OIDC
OneLogin OIDC
OneNote
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
UniPin
VoiceBase
Vonage
Walmart
Walmart v3
Wasabi
WhatsApp
WiX
WooCommerce
WordPress
Xero
Yahoo Mail
Yousign
Zoom
_Miscellaneous_
eBay
effectconnect
hacienda.go.cr

 

 

 

(Excel) 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

Download Excel Class Modules

Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.AuthToken = "ACCESS_TOKEN"

http.Accept = "application/json"


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

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

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
Dim success As Boolean
success = jsonResponse.Load(strResp)
jsonResponse.EmitCompact = False
Debug.Print jsonResponse.Emit()

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

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

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

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

 

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