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

DataFlex 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
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

MedTunnel
MercadoLibre
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
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

 

 

 

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

Use ChilkatAx-9.5.0-win32.pkg

Procedure Test
    Handle hoHttp
    String sStrResp
    Handle hoJsonResponse
    String sLinksFirst
    String sLinksLast
    String sLinksPrev
    String sLinksNext
    Integer iMetaCurrent_page
    Integer iMetaFrom
    Integer iMetaLast_page
    String sMetaPath
    Integer iMetaPer_page
    Integer iMetaTo
    Integer iMetaTotal
    Integer i
    Integer iCount_i
    Integer iId
    String sCreated_at
    String sUpdated_at
    Integer iAccount_id
    String sAddress_line1
    String sAddress_line2
    String sAppointment_date
    Boolean iAppt_call
    String sAvailable_date
    String sAverage_spending
    String sBe_back_date
    String sBirth_date
    String sBusiness
    String sCall_date
    String sCity
    String sCivility
    String sCode
    String sCountry
    String sCsi_date
    String sDelivered_by_id
    String sDelivered_date
    String sDelivery_date
    String sDivision
    String sEnd_service_date
    String sFirst_name
    String sGas
    Integer iGender
    Boolean iInvoiced
    String sLast_name
    String sLast_visit_date
    String sLocale
    String sLoyalty
    String sNext_visit_date
    String sOdometer_last_visit
    String sOpen_work_order_date
    String sPlanned_pick_up_date
    String sPostal_code
    String sPrepaid
    Boolean iPrepared
    String sPresented_date
    String sPromised_date
    String sProvince
    String sRating
    Boolean iReached_client
    String sRefinanced_date
    String sRepair_date
    String sRepair_order
    String sResult
    String sRoad_test_date
    String sSale_date
    String sSecond_contact
    String sSecond_contact_civility
    String sSegment
    Boolean iService_cleaned
    String sService_interval_km
    String sService_monthly_km
    String sService_processIntention
    String sService_processTransport
    String sService_processWalk_around
    String sSex
    String sSource
    String sStatus
    String sStorage
    String sTake_over_date
    String sV_type
    String sUnsubscribe_all_date
    String sUnsubscribe_call_date
    String sUnsubscribe_email_date
    String sUnsubscribe_sms_date
    String sWork_order
    Integer iAccountId
    String sAccountCreated_at
    String sAccountUpdated_at
    Integer iAccountPartner_id
    Boolean iAccountActivity_report
    Boolean iAccountCommercial
    Boolean iAccountEvent
    Boolean iAccountLeadxpress
    Boolean iAccountLoyalty
    Boolean iAccountPhone_up
    Boolean iAccountRenewal
    Boolean iAccountSale_table
    Boolean iAccountService
    Boolean iAccountWalk_in
    Boolean iAccountWebboost
    Boolean iAccountAccount_manager
    String sAccountActivation_date
    Boolean iAccountActive
    Boolean iAccountAssigned_lead
    Boolean iAccountAuto_renewal
    Boolean iAccountAuto_renewal_new
    Boolean iAccountAuto_renewal_used
    Boolean iAccountAutomation
    Boolean iAccountBdc_advisor
    Boolean iAccountCalendar_options
    Boolean iAccountClient_card_fieldsProcessGas
    Boolean iAccountClient_card_fieldsProcessRecorded
    Boolean iAccountClient_card_fieldsProcessAvailable
    Boolean iAccountClient_card_fieldsProcessDiscounted
    Boolean iAccountClient_card_fieldsCommercialProfit
    Boolean iAccountClient_card_fieldsCommercialExclude
    Boolean iAccountClient_card_fieldsCommercialMeeting
    Boolean iAccountClient_card_fieldsPerformanceDeposit
    Boolean iAccountClient_card_fieldsPerformanceRefinanced
    Boolean iAccountClient_card_fieldsPerformanceDealer_tour
    Boolean iAccountClient_card_fieldsPerformanceWalk_around
    Boolean iAccountClient_card_fieldsPerformanceQualification
    Boolean iAccountClient_card_fieldsPerformanceTwenty_four_hour
    Boolean iAccountClient_card_fieldsGeneral_infoBudget
    Boolean iAccountClient_card_fieldsGeneral_infoSector
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_1
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_2
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_3
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_4
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_5
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_6
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_7
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_8
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_9
    Boolean iAccountClient_card_fieldsGeneral_infoCustom_10
    Boolean iAccountClient_card_fieldsGeneral_infoCommunication_preference
    Boolean iAccountClient_card_fieldsWanted_vehicleVin
    Boolean iAccountClient_card_fieldsWanted_vehicleFuel
    Boolean iAccountClient_card_fieldsWanted_vehicleRate
    Boolean iAccountClient_card_fieldsWanted_vehicleTerm
    Boolean iAccountClient_card_fieldsWanted_vehicleTire
    Boolean iAccountClient_card_fieldsWanted_vehicleYear
    Boolean iAccountClient_card_fieldsWanted_vehicleColor
    Boolean iAccountClient_card_fieldsWanted_vehiclePrice
    Boolean iAccountClient_card_fieldsWanted_vehicleStock
    Boolean iAccountClient_card_fieldsWanted_vehicleTotal
    Boolean iAccountClient_card_fieldsWanted_vehicleBudget
    Boolean iAccountClient_card_fieldsWanted_vehicleEngine
    Boolean iAccountClient_card_fieldsWanted_vehicleLength
    Boolean iAccountClient_card_fieldsWanted_vehicleProfit
    Boolean iAccountClient_card_fieldsWanted_vehicleSuffix
    Boolean iAccountClient_card_fieldsWanted_vehicleWeight
    Boolean iAccountClient_card_fieldsWanted_vehicleComment
    Boolean iAccountClient_card_fieldsWanted_vehicleMileage
    Boolean iAccountClient_card_fieldsWanted_vehiclePayment
    Boolean iAccountClient_card_fieldsWanted_vehicleBodyType
    Boolean iAccountClient_card_fieldsWanted_vehicleCategory
    Boolean iAccountClient_card_fieldsWanted_vehicleModality
    Boolean iAccountClient_card_fieldsWanted_vehicleResidual
    Boolean iAccountClient_card_fieldsWanted_vehicleSleeping
    Boolean iAccountClient_card_fieldsWanted_vehicleWarranty
    Boolean iAccountClient_card_fieldsWanted_vehicleFrequency
    Boolean iAccountClient_card_fieldsWanted_vehicleAccessories
    Boolean iAccountClient_card_fieldsWanted_vehicleCategory_rv
    Boolean iAccountClient_card_fieldsWanted_vehiclePreparation
    Boolean iAccountClient_card_fieldsWanted_vehicleInitial_cash
    Boolean iAccountClient_card_fieldsWanted_vehicleOffer_number
    Boolean iAccountClient_card_fieldsWanted_vehicleOrder_number
    Boolean iAccountClient_card_fieldsWanted_vehicleTransmission
    Boolean iAccountClient_card_fieldsWanted_vehicleDocumentation
    Boolean iAccountClient_card_fieldsWanted_vehicleDrivingWheels
    Boolean iAccountClient_card_fieldsWanted_vehicleColor_exterior
    Boolean iAccountClient_card_fieldsWanted_vehicleColor_interior
    Boolean iAccountClient_card_fieldsWanted_vehicleAllowed_mileage
    Boolean iAccountClient_card_fieldsWanted_vehicleSecurity_deposit
    Boolean iAccountClient_card_fieldsWanted_vehicleEnd_contract_date
    Boolean iAccountClient_card_fieldsExchange_vehicleVin
    Boolean iAccountClient_card_fieldsExchange_vehicleFuel
    Boolean iAccountClient_card_fieldsExchange_vehicleLink
    Boolean iAccountClient_card_fieldsExchange_vehicleRate
    Boolean iAccountClient_card_fieldsExchange_vehicleTerm
    Boolean iAccountClient_card_fieldsExchange_vehicleYear
    Boolean iAccountClient_card_fieldsExchange_vehicleColor
    Boolean iAccountClient_card_fieldsExchange_vehiclePrice
    Boolean iAccountClient_card_fieldsExchange_vehicleStock
    Boolean iAccountClient_card_fieldsExchange_vehicleValue
    Boolean iAccountClient_card_fieldsExchange_vehicleBudget
    Boolean iAccountClient_card_fieldsExchange_vehicleEngine
    Boolean iAccountClient_card_fieldsExchange_vehicleLength
    Boolean iAccountClient_card_fieldsExchange_vehicleProfit
    Boolean iAccountClient_card_fieldsExchange_vehicleSuffix
    Boolean iAccountClient_card_fieldsExchange_vehicleWeight
    Boolean iAccountClient_card_fieldsExchange_vehicleBalance
    Boolean iAccountClient_card_fieldsExchange_vehicleComment
    Boolean iAccountClient_card_fieldsExchange_vehicleMileage
    Boolean iAccountClient_card_fieldsExchange_vehiclePayment
    Boolean iAccountClient_card_fieldsExchange_vehicleRenewal
    Boolean iAccountClient_card_fieldsExchange_vehicleSold_by
    Boolean iAccountClient_card_fieldsExchange_vehicleBodyType
    Boolean iAccountClient_card_fieldsExchange_vehicleCategory
    Boolean iAccountClient_card_fieldsExchange_vehicleModality
    Boolean iAccountClient_card_fieldsExchange_vehicleResidual
    Boolean iAccountClient_card_fieldsExchange_vehicleSleeping
    Boolean iAccountClient_card_fieldsExchange_vehicleWarranty
    Boolean iAccountClient_card_fieldsExchange_vehicleCondition
    Boolean iAccountClient_card_fieldsExchange_vehicleFrequency
    Boolean iAccountClient_card_fieldsExchange_vehicleIntention
    Boolean iAccountClient_card_fieldsExchange_vehicleRefinance
    Boolean iAccountClient_card_fieldsExchange_vehicleRequested
    Boolean iAccountClient_card_fieldsExchange_vehicleSold_date
    Boolean iAccountClient_card_fieldsExchange_vehicleCategory_rv
    Boolean iAccountClient_card_fieldsExchange_vehicleInstitution
    Boolean iAccountClient_card_fieldsExchange_vehicleInitial_cash
    Boolean iAccountClient_card_fieldsExchange_vehicleOffer_number
    Boolean iAccountClient_card_fieldsExchange_vehicleTransmission
    Boolean iAccountClient_card_fieldsExchange_vehicleDrivingWheels
    Boolean iAccountClient_card_fieldsExchange_vehicleColor_exterior
    Boolean iAccountClient_card_fieldsExchange_vehicleColor_interior
    Boolean iAccountClient_card_fieldsExchange_vehicleAllowed_mileage
    Boolean iAccountClient_card_fieldsExchange_vehicleSecurity_deposit
    Boolean iAccountClient_card_fieldsExchange_vehicleEnd_contract_date
    Boolean iAccountClient_number
    Boolean iAccountConfirmation_appt
    Boolean iAccountCredit
    Boolean iAccountCsi
    Boolean iAccountCsi_used
    String sAccountDefault_deliveryman_user_id
    Boolean iAccountDelivered_by
    Boolean iAccountDisable_communication_audio
    Boolean iAccountDuplicates
    Boolean iAccountGuest_action
    Boolean iAccountEmail_client
    Boolean iAccountIn_turn
    Boolean iAccountIn_turn_director_management
    Boolean iAccountLeads_other_division
    Integer iAccountLeadxpress_optionPriority
    Integer iAccountLeadxpress_optionReminderFrequency
    Integer iAccountLeadxpress_optionReminderRecurrence
    Boolean iAccountLeadxpress_optionScheduleAccount
    Boolean iAccountLeadxpress_optionScheduleAdvisor
    Boolean iAccountLimited_audio_access
    String sAccountLogo
    String sAccountLogo_en
    Boolean iAccountMandatory_coordinate
    Boolean iAccountManually_status
    String sAccountMerge_rule
    Integer iAccountMonth_start_day
    String sAccountName
    Boolean iAccountNiotext
    Boolean iAccountNiotext_phone
    String sAccountPhone
    Boolean iAccountPower_sport
    Boolean iAccountProcess
    Boolean iAccountRecreative_special
    Boolean iAccountResult_date_validation
    Boolean iAccountSale_accessories
    Boolean iAccountSale_by_phone
    Boolean iAccountSale_date_month
    Boolean iAccountSale_table_optionsAccessory_column
    Boolean iAccountSale_table_optionsCommercial_column
    Boolean iAccountSale_table_optionsDivision_grouped_total_column
    Boolean iAccountSale_validation
    Boolean iAccountScan
    Boolean iAccountStock_required_for_sale
    Boolean iAccountTake_over_director
    Boolean iAccountTrade_report
    Boolean iAccountUnrestricted_assignment
    Boolean iAccountUnsubscribe
    Boolean iAccountUntreated_lead
    Boolean iAccountVehicle_model_text
    Boolean iAccountVehicle_text
    Boolean iAccountVerified_sale
    Boolean iAccountVin_decoder
    String sAccountWaiting_sale_date
    Boolean iAccountWaiting_sale_option
    String sAdvisor
    Integer j
    Integer iCount_j
    Integer iLead_id
    String sAddress
    Boolean iValid
    String sExtension
    String sNumber
    Boolean iValidated
    Boolean iMobile
    String sAccessories
    String sAllowed_odometer
    Integer iBalance
    String sBudget_max
    String sBudget_min
    String sCash_down
    String sCategory
    String sCategory_rv
    String sClient_number
    String sColor_exterior
    String sColor_interior
    String sComment
    String sCondition
    String sEnd_contract_date
    String sEnd_warranty_date
    String sEngine
    String sExtended_warranty
    String sFuel
    String sLength_max
    String sLength_min
    String sLicense_plate
    String sMake
    String sModality
    String sModel
    String sOdometer
    String sOffer_number
    String sV_option
    String sOrder_number
    String sPayment
    String sPayment_frequency
    String sPreparation
    String sPrice
    String sProfit
    String sPurchase_date
    String sRate
    String sRecall
    String sRecorded_date
    String sResidual
    String sSecurity_deposit
    String sSleeping
    Boolean iSold
    String sSold_by
    String sSold_date
    String sStock
    String sStock_state
    String sTerm
    Boolean iTire
    String sTransmission
    String sTrim
    String sUrl
    String sValue
    String sVin
    String sWarranty
    String sWeight
    String sYear
    String sYear_max
    String sYear_min
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    Set ComAuthToken Of hoHttp To "ACCESS_TOKEN"

    Set ComAccept Of hoHttp To "application/json"

    Get ComQuickGetStr Of hoHttp "https://crm.activix.ca/api/v2/leads/search?query=Doe" To sStrResp
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComLastStatus Of hoHttp To iTemp1
    Showln "Response Status Code: " iTemp1

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonResponse
    If (Not(IsComObjectCreated(hoJsonResponse))) Begin
        Send CreateComObject of hoJsonResponse
    End
    Get ComLoad Of hoJsonResponse sStrResp To iSuccess
    Set ComEmitCompact Of hoJsonResponse To False
    Get ComEmit Of hoJsonResponse To sTemp1
    Showln sTemp1

    Get ComLastStatus Of hoHttp To iTemp1
    If (iTemp1 <> 200) Begin
        Showln "Failed."
        Procedure_Return
    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
    //     }
    // }

    Get ComStringOf Of hoJsonResponse "links.first" To sLinksFirst
    Get ComStringOf Of hoJsonResponse "links.last" To sLinksLast
    Get ComStringOf Of hoJsonResponse "links.prev" To sLinksPrev
    Get ComStringOf Of hoJsonResponse "links.next" To sLinksNext
    Get ComIntOf Of hoJsonResponse "meta.current_page" To iMetaCurrent_page
    Get ComIntOf Of hoJsonResponse "meta.from" To iMetaFrom
    Get ComIntOf Of hoJsonResponse "meta.last_page" To iMetaLast_page
    Get ComStringOf Of hoJsonResponse "meta.path" To sMetaPath
    Get ComIntOf Of hoJsonResponse "meta.per_page" To iMetaPer_page
    Get ComIntOf Of hoJsonResponse "meta.to" To iMetaTo
    Get ComIntOf Of hoJsonResponse "meta.total" To iMetaTotal
    Move 0 To i
    Get ComSizeOfArray Of hoJsonResponse "data" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJsonResponse To i
        Get ComIntOf Of hoJsonResponse "data[i].id" To iId
        Get ComStringOf Of hoJsonResponse "data[i].created_at" To sCreated_at
        Get ComStringOf Of hoJsonResponse "data[i].updated_at" To sUpdated_at
        Get ComIntOf Of hoJsonResponse "data[i].account_id" To iAccount_id
        Get ComStringOf Of hoJsonResponse "data[i].address_line1" To sAddress_line1
        Get ComStringOf Of hoJsonResponse "data[i].address_line2" To sAddress_line2
        Get ComStringOf Of hoJsonResponse "data[i].appointment_date" To sAppointment_date
        Get ComBoolOf Of hoJsonResponse "data[i].appt_call" To iAppt_call
        Get ComStringOf Of hoJsonResponse "data[i].available_date" To sAvailable_date
        Get ComStringOf Of hoJsonResponse "data[i].average_spending" To sAverage_spending
        Get ComStringOf Of hoJsonResponse "data[i].be_back_date" To sBe_back_date
        Get ComStringOf Of hoJsonResponse "data[i].birth_date" To sBirth_date
        Get ComStringOf Of hoJsonResponse "data[i].business" To sBusiness
        Get ComStringOf Of hoJsonResponse "data[i].call_date" To sCall_date
        Get ComStringOf Of hoJsonResponse "data[i].city" To sCity
        Get ComStringOf Of hoJsonResponse "data[i].civility" To sCivility
        Get ComStringOf Of hoJsonResponse "data[i].code" To sCode
        Get ComStringOf Of hoJsonResponse "data[i].country" To sCountry
        Get ComStringOf Of hoJsonResponse "data[i].csi_date" To sCsi_date
        Get ComStringOf Of hoJsonResponse "data[i].delivered_by_id" To sDelivered_by_id
        Get ComStringOf Of hoJsonResponse "data[i].delivered_date" To sDelivered_date
        Get ComStringOf Of hoJsonResponse "data[i].delivery_date" To sDelivery_date
        Get ComStringOf Of hoJsonResponse "data[i].division" To sDivision
        Get ComStringOf Of hoJsonResponse "data[i].end_service_date" To sEnd_service_date
        Get ComStringOf Of hoJsonResponse "data[i].first_name" To sFirst_name
        Get ComStringOf Of hoJsonResponse "data[i].gas" To sGas
        Get ComIntOf Of hoJsonResponse "data[i].gender" To iGender
        Get ComBoolOf Of hoJsonResponse "data[i].invoiced" To iInvoiced
        Get ComStringOf Of hoJsonResponse "data[i].last_name" To sLast_name
        Get ComStringOf Of hoJsonResponse "data[i].last_visit_date" To sLast_visit_date
        Get ComStringOf Of hoJsonResponse "data[i].locale" To sLocale
        Get ComStringOf Of hoJsonResponse "data[i].loyalty" To sLoyalty
        Get ComStringOf Of hoJsonResponse "data[i].next_visit_date" To sNext_visit_date
        Get ComStringOf Of hoJsonResponse "data[i].odometer_last_visit" To sOdometer_last_visit
        Get ComStringOf Of hoJsonResponse "data[i].open_work_order_date" To sOpen_work_order_date
        Get ComStringOf Of hoJsonResponse "data[i].planned_pick_up_date" To sPlanned_pick_up_date
        Get ComStringOf Of hoJsonResponse "data[i].postal_code" To sPostal_code
        Get ComStringOf Of hoJsonResponse "data[i].prepaid" To sPrepaid
        Get ComBoolOf Of hoJsonResponse "data[i].prepared" To iPrepared
        Get ComStringOf Of hoJsonResponse "data[i].presented_date" To sPresented_date
        Get ComStringOf Of hoJsonResponse "data[i].promised_date" To sPromised_date
        Get ComStringOf Of hoJsonResponse "data[i].province" To sProvince
        Get ComStringOf Of hoJsonResponse "data[i].rating" To sRating
        Get ComBoolOf Of hoJsonResponse "data[i].reached_client" To iReached_client
        Get ComStringOf Of hoJsonResponse "data[i].refinanced_date" To sRefinanced_date
        Get ComStringOf Of hoJsonResponse "data[i].repair_date" To sRepair_date
        Get ComStringOf Of hoJsonResponse "data[i].repair_order" To sRepair_order
        Get ComStringOf Of hoJsonResponse "data[i].result" To sResult
        Get ComStringOf Of hoJsonResponse "data[i].road_test_date" To sRoad_test_date
        Get ComStringOf Of hoJsonResponse "data[i].sale_date" To sSale_date
        Get ComStringOf Of hoJsonResponse "data[i].second_contact" To sSecond_contact
        Get ComStringOf Of hoJsonResponse "data[i].second_contact_civility" To sSecond_contact_civility
        Get ComStringOf Of hoJsonResponse "data[i].segment" To sSegment
        Get ComBoolOf Of hoJsonResponse "data[i].service_cleaned" To iService_cleaned
        Get ComStringOf Of hoJsonResponse "data[i].service_interval_km" To sService_interval_km
        Get ComStringOf Of hoJsonResponse "data[i].service_monthly_km" To sService_monthly_km
        Get ComStringOf Of hoJsonResponse "data[i].service_process.intention" To sService_processIntention
        Get ComStringOf Of hoJsonResponse "data[i].service_process.transport" To sService_processTransport
        Get ComStringOf Of hoJsonResponse "data[i].service_process.walk_around" To sService_processWalk_around
        Get ComStringOf Of hoJsonResponse "data[i].sex" To sSex
        Get ComStringOf Of hoJsonResponse "data[i].source" To sSource
        Get ComStringOf Of hoJsonResponse "data[i].status" To sStatus
        Get ComStringOf Of hoJsonResponse "data[i].storage" To sStorage
        Get ComStringOf Of hoJsonResponse "data[i].take_over_date" To sTake_over_date
        Get ComStringOf Of hoJsonResponse "data[i].type" To sV_type
        Get ComStringOf Of hoJsonResponse "data[i].unsubscribe_all_date" To sUnsubscribe_all_date
        Get ComStringOf Of hoJsonResponse "data[i].unsubscribe_call_date" To sUnsubscribe_call_date
        Get ComStringOf Of hoJsonResponse "data[i].unsubscribe_email_date" To sUnsubscribe_email_date
        Get ComStringOf Of hoJsonResponse "data[i].unsubscribe_sms_date" To sUnsubscribe_sms_date
        Get ComStringOf Of hoJsonResponse "data[i].work_order" To sWork_order
        Get ComIntOf Of hoJsonResponse "data[i].account.id" To iAccountId
        Get ComStringOf Of hoJsonResponse "data[i].account.created_at" To sAccountCreated_at
        Get ComStringOf Of hoJsonResponse "data[i].account.updated_at" To sAccountUpdated_at
        Get ComIntOf Of hoJsonResponse "data[i].account.partner_id" To iAccountPartner_id
        Get ComBoolOf Of hoJsonResponse "data[i].account.activity_report" To iAccountActivity_report
        Get ComBoolOf Of hoJsonResponse "data[i].account.commercial" To iAccountCommercial
        Get ComBoolOf Of hoJsonResponse "data[i].account.event" To iAccountEvent
        Get ComBoolOf Of hoJsonResponse "data[i].account.leadxpress" To iAccountLeadxpress
        Get ComBoolOf Of hoJsonResponse "data[i].account.loyalty" To iAccountLoyalty
        Get ComBoolOf Of hoJsonResponse "data[i].account.phone_up" To iAccountPhone_up
        Get ComBoolOf Of hoJsonResponse "data[i].account.renewal" To iAccountRenewal
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_table" To iAccountSale_table
        Get ComBoolOf Of hoJsonResponse "data[i].account.service" To iAccountService
        Get ComBoolOf Of hoJsonResponse "data[i].account.walk_in" To iAccountWalk_in
        Get ComBoolOf Of hoJsonResponse "data[i].account.webboost" To iAccountWebboost
        Get ComBoolOf Of hoJsonResponse "data[i].account.account_manager" To iAccountAccount_manager
        Get ComStringOf Of hoJsonResponse "data[i].account.activation_date" To sAccountActivation_date
        Get ComBoolOf Of hoJsonResponse "data[i].account.active" To iAccountActive
        Get ComBoolOf Of hoJsonResponse "data[i].account.assigned_lead" To iAccountAssigned_lead
        Get ComBoolOf Of hoJsonResponse "data[i].account.auto_renewal" To iAccountAuto_renewal
        Get ComBoolOf Of hoJsonResponse "data[i].account.auto_renewal_new" To iAccountAuto_renewal_new
        Get ComBoolOf Of hoJsonResponse "data[i].account.auto_renewal_used" To iAccountAuto_renewal_used
        Get ComBoolOf Of hoJsonResponse "data[i].account.automation" To iAccountAutomation
        Get ComBoolOf Of hoJsonResponse "data[i].account.bdc_advisor" To iAccountBdc_advisor
        Get ComBoolOf Of hoJsonResponse "data[i].account.calendar_options" To iAccountCalendar_options
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.process.gas" To iAccountClient_card_fieldsProcessGas
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.process.recorded" To iAccountClient_card_fieldsProcessRecorded
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.process.available" To iAccountClient_card_fieldsProcessAvailable
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.process.discounted" To iAccountClient_card_fieldsProcessDiscounted
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.commercial.profit" To iAccountClient_card_fieldsCommercialProfit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.commercial.exclude" To iAccountClient_card_fieldsCommercialExclude
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.commercial.meeting" To iAccountClient_card_fieldsCommercialMeeting
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.deposit" To iAccountClient_card_fieldsPerformanceDeposit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.refinanced" To iAccountClient_card_fieldsPerformanceRefinanced
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.dealer_tour" To iAccountClient_card_fieldsPerformanceDealer_tour
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.walk_around" To iAccountClient_card_fieldsPerformanceWalk_around
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.qualification" To iAccountClient_card_fieldsPerformanceQualification
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.performance.twenty_four_hour" To iAccountClient_card_fieldsPerformanceTwenty_four_hour
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.budget" To iAccountClient_card_fieldsGeneral_infoBudget
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.sector" To iAccountClient_card_fieldsGeneral_infoSector
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_1" To iAccountClient_card_fieldsGeneral_infoCustom_1
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_2" To iAccountClient_card_fieldsGeneral_infoCustom_2
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_3" To iAccountClient_card_fieldsGeneral_infoCustom_3
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_4" To iAccountClient_card_fieldsGeneral_infoCustom_4
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_5" To iAccountClient_card_fieldsGeneral_infoCustom_5
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_6" To iAccountClient_card_fieldsGeneral_infoCustom_6
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_7" To iAccountClient_card_fieldsGeneral_infoCustom_7
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_8" To iAccountClient_card_fieldsGeneral_infoCustom_8
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_9" To iAccountClient_card_fieldsGeneral_infoCustom_9
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.custom_10" To iAccountClient_card_fieldsGeneral_infoCustom_10
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.general_info.communication_preference" To iAccountClient_card_fieldsGeneral_infoCommunication_preference
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.vin" To iAccountClient_card_fieldsWanted_vehicleVin
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.fuel" To iAccountClient_card_fieldsWanted_vehicleFuel
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.rate" To iAccountClient_card_fieldsWanted_vehicleRate
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.term" To iAccountClient_card_fieldsWanted_vehicleTerm
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.tire" To iAccountClient_card_fieldsWanted_vehicleTire
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.year" To iAccountClient_card_fieldsWanted_vehicleYear
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.color" To iAccountClient_card_fieldsWanted_vehicleColor
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.price" To iAccountClient_card_fieldsWanted_vehiclePrice
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.stock" To iAccountClient_card_fieldsWanted_vehicleStock
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.total" To iAccountClient_card_fieldsWanted_vehicleTotal
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.budget" To iAccountClient_card_fieldsWanted_vehicleBudget
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.engine" To iAccountClient_card_fieldsWanted_vehicleEngine
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.length" To iAccountClient_card_fieldsWanted_vehicleLength
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.profit" To iAccountClient_card_fieldsWanted_vehicleProfit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.suffix" To iAccountClient_card_fieldsWanted_vehicleSuffix
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.weight" To iAccountClient_card_fieldsWanted_vehicleWeight
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.comment" To iAccountClient_card_fieldsWanted_vehicleComment
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.mileage" To iAccountClient_card_fieldsWanted_vehicleMileage
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.payment" To iAccountClient_card_fieldsWanted_vehiclePayment
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.bodyType" To iAccountClient_card_fieldsWanted_vehicleBodyType
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.category" To iAccountClient_card_fieldsWanted_vehicleCategory
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.modality" To iAccountClient_card_fieldsWanted_vehicleModality
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.residual" To iAccountClient_card_fieldsWanted_vehicleResidual
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.sleeping" To iAccountClient_card_fieldsWanted_vehicleSleeping
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.warranty" To iAccountClient_card_fieldsWanted_vehicleWarranty
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.frequency" To iAccountClient_card_fieldsWanted_vehicleFrequency
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.accessories" To iAccountClient_card_fieldsWanted_vehicleAccessories
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.category_rv" To iAccountClient_card_fieldsWanted_vehicleCategory_rv
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.preparation" To iAccountClient_card_fieldsWanted_vehiclePreparation
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.initial_cash" To iAccountClient_card_fieldsWanted_vehicleInitial_cash
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.offer_number" To iAccountClient_card_fieldsWanted_vehicleOffer_number
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.order_number" To iAccountClient_card_fieldsWanted_vehicleOrder_number
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.transmission" To iAccountClient_card_fieldsWanted_vehicleTransmission
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.documentation" To iAccountClient_card_fieldsWanted_vehicleDocumentation
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.drivingWheels" To iAccountClient_card_fieldsWanted_vehicleDrivingWheels
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.color_exterior" To iAccountClient_card_fieldsWanted_vehicleColor_exterior
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.color_interior" To iAccountClient_card_fieldsWanted_vehicleColor_interior
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.allowed_mileage" To iAccountClient_card_fieldsWanted_vehicleAllowed_mileage
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.security_deposit" To iAccountClient_card_fieldsWanted_vehicleSecurity_deposit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.wanted_vehicle.end_contract_date" To iAccountClient_card_fieldsWanted_vehicleEnd_contract_date
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.vin" To iAccountClient_card_fieldsExchange_vehicleVin
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.fuel" To iAccountClient_card_fieldsExchange_vehicleFuel
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.link" To iAccountClient_card_fieldsExchange_vehicleLink
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.rate" To iAccountClient_card_fieldsExchange_vehicleRate
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.term" To iAccountClient_card_fieldsExchange_vehicleTerm
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.year" To iAccountClient_card_fieldsExchange_vehicleYear
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.color" To iAccountClient_card_fieldsExchange_vehicleColor
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.price" To iAccountClient_card_fieldsExchange_vehiclePrice
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.stock" To iAccountClient_card_fieldsExchange_vehicleStock
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.value" To iAccountClient_card_fieldsExchange_vehicleValue
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.budget" To iAccountClient_card_fieldsExchange_vehicleBudget
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.engine" To iAccountClient_card_fieldsExchange_vehicleEngine
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.length" To iAccountClient_card_fieldsExchange_vehicleLength
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.profit" To iAccountClient_card_fieldsExchange_vehicleProfit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.suffix" To iAccountClient_card_fieldsExchange_vehicleSuffix
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.weight" To iAccountClient_card_fieldsExchange_vehicleWeight
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.balance" To iAccountClient_card_fieldsExchange_vehicleBalance
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.comment" To iAccountClient_card_fieldsExchange_vehicleComment
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.mileage" To iAccountClient_card_fieldsExchange_vehicleMileage
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.payment" To iAccountClient_card_fieldsExchange_vehiclePayment
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.renewal" To iAccountClient_card_fieldsExchange_vehicleRenewal
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.sold_by" To iAccountClient_card_fieldsExchange_vehicleSold_by
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.bodyType" To iAccountClient_card_fieldsExchange_vehicleBodyType
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.category" To iAccountClient_card_fieldsExchange_vehicleCategory
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.modality" To iAccountClient_card_fieldsExchange_vehicleModality
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.residual" To iAccountClient_card_fieldsExchange_vehicleResidual
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.sleeping" To iAccountClient_card_fieldsExchange_vehicleSleeping
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.warranty" To iAccountClient_card_fieldsExchange_vehicleWarranty
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.condition" To iAccountClient_card_fieldsExchange_vehicleCondition
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.frequency" To iAccountClient_card_fieldsExchange_vehicleFrequency
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.intention" To iAccountClient_card_fieldsExchange_vehicleIntention
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.refinance" To iAccountClient_card_fieldsExchange_vehicleRefinance
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.requested" To iAccountClient_card_fieldsExchange_vehicleRequested
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.sold_date" To iAccountClient_card_fieldsExchange_vehicleSold_date
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.category_rv" To iAccountClient_card_fieldsExchange_vehicleCategory_rv
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.institution" To iAccountClient_card_fieldsExchange_vehicleInstitution
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.initial_cash" To iAccountClient_card_fieldsExchange_vehicleInitial_cash
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.offer_number" To iAccountClient_card_fieldsExchange_vehicleOffer_number
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.transmission" To iAccountClient_card_fieldsExchange_vehicleTransmission
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.drivingWheels" To iAccountClient_card_fieldsExchange_vehicleDrivingWheels
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.color_exterior" To iAccountClient_card_fieldsExchange_vehicleColor_exterior
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.color_interior" To iAccountClient_card_fieldsExchange_vehicleColor_interior
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.allowed_mileage" To iAccountClient_card_fieldsExchange_vehicleAllowed_mileage
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.security_deposit" To iAccountClient_card_fieldsExchange_vehicleSecurity_deposit
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_card_fields.exchange_vehicle.end_contract_date" To iAccountClient_card_fieldsExchange_vehicleEnd_contract_date
        Get ComBoolOf Of hoJsonResponse "data[i].account.client_number" To iAccountClient_number
        Get ComBoolOf Of hoJsonResponse "data[i].account.confirmation_appt" To iAccountConfirmation_appt
        Get ComBoolOf Of hoJsonResponse "data[i].account.credit" To iAccountCredit
        Get ComBoolOf Of hoJsonResponse "data[i].account.csi" To iAccountCsi
        Get ComBoolOf Of hoJsonResponse "data[i].account.csi_used" To iAccountCsi_used
        Get ComStringOf Of hoJsonResponse "data[i].account.default_deliveryman_user_id" To sAccountDefault_deliveryman_user_id
        Get ComBoolOf Of hoJsonResponse "data[i].account.delivered_by" To iAccountDelivered_by
        Get ComBoolOf Of hoJsonResponse "data[i].account.disable_communication_audio" To iAccountDisable_communication_audio
        Get ComBoolOf Of hoJsonResponse "data[i].account.duplicates" To iAccountDuplicates
        Get ComBoolOf Of hoJsonResponse "data[i].account.guest_action" To iAccountGuest_action
        Get ComBoolOf Of hoJsonResponse "data[i].account.email_client" To iAccountEmail_client
        Get ComBoolOf Of hoJsonResponse "data[i].account.in_turn" To iAccountIn_turn
        Get ComBoolOf Of hoJsonResponse "data[i].account.in_turn_director_management" To iAccountIn_turn_director_management
        Get ComBoolOf Of hoJsonResponse "data[i].account.leads_other_division" To iAccountLeads_other_division
        Get ComIntOf Of hoJsonResponse "data[i].account.leadxpress_option.priority" To iAccountLeadxpress_optionPriority
        Get ComIntOf Of hoJsonResponse "data[i].account.leadxpress_option.reminder.frequency" To iAccountLeadxpress_optionReminderFrequency
        Get ComIntOf Of hoJsonResponse "data[i].account.leadxpress_option.reminder.recurrence" To iAccountLeadxpress_optionReminderRecurrence
        Get ComBoolOf Of hoJsonResponse "data[i].account.leadxpress_option.schedule.account" To iAccountLeadxpress_optionScheduleAccount
        Get ComBoolOf Of hoJsonResponse "data[i].account.leadxpress_option.schedule.advisor" To iAccountLeadxpress_optionScheduleAdvisor
        Get ComBoolOf Of hoJsonResponse "data[i].account.limited_audio_access" To iAccountLimited_audio_access
        Get ComStringOf Of hoJsonResponse "data[i].account.logo" To sAccountLogo
        Get ComStringOf Of hoJsonResponse "data[i].account.logo_en" To sAccountLogo_en
        Get ComBoolOf Of hoJsonResponse "data[i].account.mandatory_coordinate" To iAccountMandatory_coordinate
        Get ComBoolOf Of hoJsonResponse "data[i].account.manually_status" To iAccountManually_status
        Get ComStringOf Of hoJsonResponse "data[i].account.merge_rule" To sAccountMerge_rule
        Get ComIntOf Of hoJsonResponse "data[i].account.month_start_day" To iAccountMonth_start_day
        Get ComStringOf Of hoJsonResponse "data[i].account.name" To sAccountName
        Get ComBoolOf Of hoJsonResponse "data[i].account.niotext" To iAccountNiotext
        Get ComBoolOf Of hoJsonResponse "data[i].account.niotext_phone" To iAccountNiotext_phone
        Get ComStringOf Of hoJsonResponse "data[i].account.phone" To sAccountPhone
        Get ComBoolOf Of hoJsonResponse "data[i].account.power_sport" To iAccountPower_sport
        Get ComBoolOf Of hoJsonResponse "data[i].account.process" To iAccountProcess
        Get ComBoolOf Of hoJsonResponse "data[i].account.recreative_special" To iAccountRecreative_special
        Get ComBoolOf Of hoJsonResponse "data[i].account.result_date_validation" To iAccountResult_date_validation
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_accessories" To iAccountSale_accessories
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_by_phone" To iAccountSale_by_phone
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_date_month" To iAccountSale_date_month
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_table_options.accessory_column" To iAccountSale_table_optionsAccessory_column
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_table_options.commercial_column" To iAccountSale_table_optionsCommercial_column
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_table_options.division_grouped_total_column" To iAccountSale_table_optionsDivision_grouped_total_column
        Get ComBoolOf Of hoJsonResponse "data[i].account.sale_validation" To iAccountSale_validation
        Get ComBoolOf Of hoJsonResponse "data[i].account.scan" To iAccountScan
        Get ComBoolOf Of hoJsonResponse "data[i].account.stock_required_for_sale" To iAccountStock_required_for_sale
        Get ComBoolOf Of hoJsonResponse "data[i].account.take_over_director" To iAccountTake_over_director
        Get ComBoolOf Of hoJsonResponse "data[i].account.trade_report" To iAccountTrade_report
        Get ComBoolOf Of hoJsonResponse "data[i].account.unrestricted_assignment" To iAccountUnrestricted_assignment
        Get ComBoolOf Of hoJsonResponse "data[i].account.unsubscribe" To iAccountUnsubscribe
        Get ComBoolOf Of hoJsonResponse "data[i].account.untreated_lead" To iAccountUntreated_lead
        Get ComBoolOf Of hoJsonResponse "data[i].account.vehicle_model_text" To iAccountVehicle_model_text
        Get ComBoolOf Of hoJsonResponse "data[i].account.vehicle_text" To iAccountVehicle_text
        Get ComBoolOf Of hoJsonResponse "data[i].account.verified_sale" To iAccountVerified_sale
        Get ComBoolOf Of hoJsonResponse "data[i].account.vin_decoder" To iAccountVin_decoder
        Get ComStringOf Of hoJsonResponse "data[i].account.waiting_sale_date" To sAccountWaiting_sale_date
        Get ComBoolOf Of hoJsonResponse "data[i].account.waiting_sale_option" To iAccountWaiting_sale_option
        Get ComStringOf Of hoJsonResponse "data[i].advisor" To sAdvisor
        Move 0 To j
        Get ComSizeOfArray Of hoJsonResponse "data[i].emails" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJsonResponse To j
            Get ComIntOf Of hoJsonResponse "data[i].emails[j].id" To iId
            Get ComStringOf Of hoJsonResponse "data[i].emails[j].created_at" To sCreated_at
            Get ComStringOf Of hoJsonResponse "data[i].emails[j].updated_at" To sUpdated_at
            Get ComIntOf Of hoJsonResponse "data[i].emails[j].lead_id" To iLead_id
            Get ComStringOf Of hoJsonResponse "data[i].emails[j].address" To sAddress
            Get ComStringOf Of hoJsonResponse "data[i].emails[j].type" To sV_type
            Get ComBoolOf Of hoJsonResponse "data[i].emails[j].valid" To iValid
            Move j + 1 To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJsonResponse "data[i].phones" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJsonResponse To j
            Get ComIntOf Of hoJsonResponse "data[i].phones[j].id" To iId
            Get ComStringOf Of hoJsonResponse "data[i].phones[j].created_at" To sCreated_at
            Get ComStringOf Of hoJsonResponse "data[i].phones[j].updated_at" To sUpdated_at
            Get ComIntOf Of hoJsonResponse "data[i].phones[j].lead_id" To iLead_id
            Get ComStringOf Of hoJsonResponse "data[i].phones[j].extension" To sExtension
            Get ComStringOf Of hoJsonResponse "data[i].phones[j].number" To sNumber
            Get ComStringOf Of hoJsonResponse "data[i].phones[j].type" To sV_type
            Get ComBoolOf Of hoJsonResponse "data[i].phones[j].valid" To iValid
            Get ComBoolOf Of hoJsonResponse "data[i].phones[j].validated" To iValidated
            Get ComBoolOf Of hoJsonResponse "data[i].phones[j].mobile" To iMobile
            Move j + 1 To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJsonResponse "data[i].vehicles" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJsonResponse To j
            Get ComIntOf Of hoJsonResponse "data[i].vehicles[j].id" To iId
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].created_at" To sCreated_at
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].updated_at" To sUpdated_at
            Get ComIntOf Of hoJsonResponse "data[i].vehicles[j].lead_id" To iLead_id
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].accessories" To sAccessories
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].allowed_odometer" To sAllowed_odometer
            Get ComIntOf Of hoJsonResponse "data[i].vehicles[j].balance" To iBalance
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].budget_max" To sBudget_max
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].budget_min" To sBudget_min
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].cash_down" To sCash_down
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].category" To sCategory
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].category_rv" To sCategory_rv
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].client_number" To sClient_number
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].color_exterior" To sColor_exterior
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].color_interior" To sColor_interior
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].comment" To sComment
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].condition" To sCondition
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].end_contract_date" To sEnd_contract_date
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].end_warranty_date" To sEnd_warranty_date
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].engine" To sEngine
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].extended_warranty" To sExtended_warranty
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].fuel" To sFuel
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].length_max" To sLength_max
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].length_min" To sLength_min
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].license_plate" To sLicense_plate
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].make" To sMake
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].modality" To sModality
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].model" To sModel
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].odometer" To sOdometer
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].offer_number" To sOffer_number
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].option" To sV_option
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].order_number" To sOrder_number
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].payment" To sPayment
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].payment_frequency" To sPayment_frequency
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].preparation" To sPreparation
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].price" To sPrice
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].profit" To sProfit
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].purchase_date" To sPurchase_date
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].rate" To sRate
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].recall" To sRecall
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].recorded_date" To sRecorded_date
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].residual" To sResidual
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].security_deposit" To sSecurity_deposit
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].sleeping" To sSleeping
            Get ComBoolOf Of hoJsonResponse "data[i].vehicles[j].sold" To iSold
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].sold_by" To sSold_by
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].sold_date" To sSold_date
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].stock" To sStock
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].stock_state" To sStock_state
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].term" To sTerm
            Get ComBoolOf Of hoJsonResponse "data[i].vehicles[j].tire" To iTire
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].transmission" To sTransmission
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].trim" To sTrim
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].type" To sV_type
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].url" To sUrl
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].value" To sValue
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].vin" To sVin
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].warranty" To sWarranty
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].weight" To sWeight
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].year" To sYear
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].year_max" To sYear_max
            Get ComStringOf Of hoJsonResponse "data[i].vehicles[j].year_min" To sYear_min
            Move j + 1 To j
        Loop

        Move 0 To j
        Get ComSizeOfArray Of hoJsonResponse "data[i].products" To iCount_j
        While (j < iCount_j)
            Set ComJ Of hoJsonResponse To j
            Move j + 1 To j
        Loop

        Move i + 1 To i
    Loop



End_Procedure

 

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