Sample code for 30+ languages & platforms
Xbase++

Activix CRM Search for Leads

See more Activix CRM Examples

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

Chilkat Xbase++ Downloads

Xbase++
LOCAL oHttp
LOCAL cStrResp
LOCAL oJsonResponse
LOCAL cLinksFirst
LOCAL cLinksLast
LOCAL cLinksPrev
LOCAL cLinksNext
LOCAL nMetaCurrent_page
LOCAL nMetaFrom
LOCAL nMetaLast_page
LOCAL cMetaPath
LOCAL nMetaPer_page
LOCAL nMetaTo
LOCAL nMetaTotal
LOCAL i
LOCAL nCount_i
LOCAL nId
LOCAL cCreated_at
LOCAL cUpdated_at
LOCAL nAccount_id
LOCAL cAddress_line1
LOCAL cAddress_line2
LOCAL cAppointment_date
LOCAL nAppt_call
LOCAL cAvailable_date
LOCAL cAverage_spending
LOCAL cBe_back_date
LOCAL cBirth_date
LOCAL cBusiness
LOCAL cCall_date
LOCAL cCity
LOCAL cCivility
LOCAL cCode
LOCAL cCountry
LOCAL cCsi_date
LOCAL cDelivered_by_id
LOCAL cDelivered_date
LOCAL cDelivery_date
LOCAL cDivision
LOCAL cEnd_service_date
LOCAL cFirst_name
LOCAL cGas
LOCAL nGender
LOCAL nInvoiced
LOCAL cLast_name
LOCAL cLast_visit_date
LOCAL cLocale
LOCAL cLoyalty
LOCAL cNext_visit_date
LOCAL cOdometer_last_visit
LOCAL cOpen_work_order_date
LOCAL cPlanned_pick_up_date
LOCAL cPostal_code
LOCAL cPrepaid
LOCAL nPrepared
LOCAL cPresented_date
LOCAL cPromised_date
LOCAL cProvince
LOCAL cRating
LOCAL nReached_client
LOCAL cRefinanced_date
LOCAL cRepair_date
LOCAL cRepair_order
LOCAL cResult
LOCAL cRoad_test_date
LOCAL cSale_date
LOCAL cSecond_contact
LOCAL cSecond_contact_civility
LOCAL cSegment
LOCAL nService_cleaned
LOCAL cService_interval_km
LOCAL cService_monthly_km
LOCAL cService_processIntention
LOCAL cService_processTransport
LOCAL cService_processWalk_around
LOCAL cSex
LOCAL cSource
LOCAL cStatus
LOCAL cStorage
LOCAL cTake_over_date
LOCAL cV_type
LOCAL cUnsubscribe_all_date
LOCAL cUnsubscribe_call_date
LOCAL cUnsubscribe_email_date
LOCAL cUnsubscribe_sms_date
LOCAL cWork_order
LOCAL nAccountId
LOCAL cAccountCreated_at
LOCAL cAccountUpdated_at
LOCAL nAccountPartner_id
LOCAL nAccountActivity_report
LOCAL nAccountCommercial
LOCAL nAccountEvent
LOCAL nAccountLeadxpress
LOCAL nAccountLoyalty
LOCAL nAccountPhone_up
LOCAL nAccountRenewal
LOCAL nAccountSale_table
LOCAL nAccountService
LOCAL nAccountWalk_in
LOCAL nAccountWebboost
LOCAL nAccountAccount_manager
LOCAL cAccountActivation_date
LOCAL nAccountActive
LOCAL nAccountAssigned_lead
LOCAL nAccountAuto_renewal
LOCAL nAccountAuto_renewal_new
LOCAL nAccountAuto_renewal_used
LOCAL nAccountAutomation
LOCAL nAccountBdc_advisor
LOCAL nAccountCalendar_options
LOCAL nAccountClient_card_fieldsProcessGas
LOCAL nAccountClient_card_fieldsProcessRecorded
LOCAL nAccountClient_card_fieldsProcessAvailable
LOCAL nAccountClient_card_fieldsProcessDiscounted
LOCAL nAccountClient_card_fieldsCommercialProfit
LOCAL nAccountClient_card_fieldsCommercialExclude
LOCAL nAccountClient_card_fieldsCommercialMeeting
LOCAL nAccountClient_card_fieldsPerformanceDeposit
LOCAL nAccountClient_card_fieldsPerformanceRefinanced
LOCAL nAccountClient_card_fieldsPerformanceDealer_tour
LOCAL nAccountClient_card_fieldsPerformanceWalk_around
LOCAL nAccountClient_card_fieldsPerformanceQualification
LOCAL nAccountClient_card_fieldsPerformanceTwenty_four_hour
LOCAL nAccountClient_card_fieldsGeneral_infoBudget
LOCAL nAccountClient_card_fieldsGeneral_infoSector
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_1
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_2
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_3
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_4
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_5
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_6
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_7
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_8
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_9
LOCAL nAccountClient_card_fieldsGeneral_infoCustom_10
LOCAL nAccountClient_card_fieldsGeneral_infoCommunication_preference
LOCAL nAccountClient_card_fieldsWanted_vehicleVin
LOCAL nAccountClient_card_fieldsWanted_vehicleFuel
LOCAL nAccountClient_card_fieldsWanted_vehicleRate
LOCAL nAccountClient_card_fieldsWanted_vehicleTerm
LOCAL nAccountClient_card_fieldsWanted_vehicleTire
LOCAL nAccountClient_card_fieldsWanted_vehicleYear
LOCAL nAccountClient_card_fieldsWanted_vehicleColor
LOCAL nAccountClient_card_fieldsWanted_vehiclePrice
LOCAL nAccountClient_card_fieldsWanted_vehicleStock
LOCAL nAccountClient_card_fieldsWanted_vehicleTotal
LOCAL nAccountClient_card_fieldsWanted_vehicleBudget
LOCAL nAccountClient_card_fieldsWanted_vehicleEngine
LOCAL nAccountClient_card_fieldsWanted_vehicleLength
LOCAL nAccountClient_card_fieldsWanted_vehicleProfit
LOCAL nAccountClient_card_fieldsWanted_vehicleSuffix
LOCAL nAccountClient_card_fieldsWanted_vehicleWeight
LOCAL nAccountClient_card_fieldsWanted_vehicleComment
LOCAL nAccountClient_card_fieldsWanted_vehicleMileage
LOCAL nAccountClient_card_fieldsWanted_vehiclePayment
LOCAL nAccountClient_card_fieldsWanted_vehicleBodyType
LOCAL nAccountClient_card_fieldsWanted_vehicleCategory
LOCAL nAccountClient_card_fieldsWanted_vehicleModality
LOCAL nAccountClient_card_fieldsWanted_vehicleResidual
LOCAL nAccountClient_card_fieldsWanted_vehicleSleeping
LOCAL nAccountClient_card_fieldsWanted_vehicleWarranty
LOCAL nAccountClient_card_fieldsWanted_vehicleFrequency
LOCAL nAccountClient_card_fieldsWanted_vehicleAccessories
LOCAL nAccountClient_card_fieldsWanted_vehicleCategory_rv
LOCAL nAccountClient_card_fieldsWanted_vehiclePreparation
LOCAL nAccountClient_card_fieldsWanted_vehicleInitial_cash
LOCAL nAccountClient_card_fieldsWanted_vehicleOffer_number
LOCAL nAccountClient_card_fieldsWanted_vehicleOrder_number
LOCAL nAccountClient_card_fieldsWanted_vehicleTransmission
LOCAL nAccountClient_card_fieldsWanted_vehicleDocumentation
LOCAL nAccountClient_card_fieldsWanted_vehicleDrivingWheels
LOCAL nAccountClient_card_fieldsWanted_vehicleColor_exterior
LOCAL nAccountClient_card_fieldsWanted_vehicleColor_interior
LOCAL nAccountClient_card_fieldsWanted_vehicleAllowed_mileage
LOCAL nAccountClient_card_fieldsWanted_vehicleSecurity_deposit
LOCAL nAccountClient_card_fieldsWanted_vehicleEnd_contract_date
LOCAL nAccountClient_card_fieldsExchange_vehicleVin
LOCAL nAccountClient_card_fieldsExchange_vehicleFuel
LOCAL nAccountClient_card_fieldsExchange_vehicleLink
LOCAL nAccountClient_card_fieldsExchange_vehicleRate
LOCAL nAccountClient_card_fieldsExchange_vehicleTerm
LOCAL nAccountClient_card_fieldsExchange_vehicleYear
LOCAL nAccountClient_card_fieldsExchange_vehicleColor
LOCAL nAccountClient_card_fieldsExchange_vehiclePrice
LOCAL nAccountClient_card_fieldsExchange_vehicleStock
LOCAL nAccountClient_card_fieldsExchange_vehicleValue
LOCAL nAccountClient_card_fieldsExchange_vehicleBudget
LOCAL nAccountClient_card_fieldsExchange_vehicleEngine
LOCAL nAccountClient_card_fieldsExchange_vehicleLength
LOCAL nAccountClient_card_fieldsExchange_vehicleProfit
LOCAL nAccountClient_card_fieldsExchange_vehicleSuffix
LOCAL nAccountClient_card_fieldsExchange_vehicleWeight
LOCAL nAccountClient_card_fieldsExchange_vehicleBalance
LOCAL nAccountClient_card_fieldsExchange_vehicleComment
LOCAL nAccountClient_card_fieldsExchange_vehicleMileage
LOCAL nAccountClient_card_fieldsExchange_vehiclePayment
LOCAL nAccountClient_card_fieldsExchange_vehicleRenewal
LOCAL nAccountClient_card_fieldsExchange_vehicleSold_by
LOCAL nAccountClient_card_fieldsExchange_vehicleBodyType
LOCAL nAccountClient_card_fieldsExchange_vehicleCategory
LOCAL nAccountClient_card_fieldsExchange_vehicleModality
LOCAL nAccountClient_card_fieldsExchange_vehicleResidual
LOCAL nAccountClient_card_fieldsExchange_vehicleSleeping
LOCAL nAccountClient_card_fieldsExchange_vehicleWarranty
LOCAL nAccountClient_card_fieldsExchange_vehicleCondition
LOCAL nAccountClient_card_fieldsExchange_vehicleFrequency
LOCAL nAccountClient_card_fieldsExchange_vehicleIntention
LOCAL nAccountClient_card_fieldsExchange_vehicleRefinance
LOCAL nAccountClient_card_fieldsExchange_vehicleRequested
LOCAL nAccountClient_card_fieldsExchange_vehicleSold_date
LOCAL nAccountClient_card_fieldsExchange_vehicleCategory_rv
LOCAL nAccountClient_card_fieldsExchange_vehicleInstitution
LOCAL nAccountClient_card_fieldsExchange_vehicleInitial_cash
LOCAL nAccountClient_card_fieldsExchange_vehicleOffer_number
LOCAL nAccountClient_card_fieldsExchange_vehicleTransmission
LOCAL nAccountClient_card_fieldsExchange_vehicleDrivingWheels
LOCAL nAccountClient_card_fieldsExchange_vehicleColor_exterior
LOCAL nAccountClient_card_fieldsExchange_vehicleColor_interior
LOCAL nAccountClient_card_fieldsExchange_vehicleAllowed_mileage
LOCAL nAccountClient_card_fieldsExchange_vehicleSecurity_deposit
LOCAL nAccountClient_card_fieldsExchange_vehicleEnd_contract_date
LOCAL nAccountClient_number
LOCAL nAccountConfirmation_appt
LOCAL nAccountCredit
LOCAL nAccountCsi
LOCAL nAccountCsi_used
LOCAL cAccountDefault_deliveryman_user_id
LOCAL nAccountDelivered_by
LOCAL nAccountDisable_communication_audio
LOCAL nAccountDuplicates
LOCAL nAccountGuest_action
LOCAL nAccountEmail_client
LOCAL nAccountIn_turn
LOCAL nAccountIn_turn_director_management
LOCAL nAccountLeads_other_division
LOCAL nAccountLeadxpress_optionPriority
LOCAL nAccountLeadxpress_optionReminderFrequency
LOCAL nAccountLeadxpress_optionReminderRecurrence
LOCAL nAccountLeadxpress_optionScheduleAccount
LOCAL nAccountLeadxpress_optionScheduleAdvisor
LOCAL nAccountLimited_audio_access
LOCAL cAccountLogo
LOCAL cAccountLogo_en
LOCAL nAccountMandatory_coordinate
LOCAL nAccountManually_status
LOCAL cAccountMerge_rule
LOCAL nAccountMonth_start_day
LOCAL cAccountName
LOCAL nAccountNiotext
LOCAL nAccountNiotext_phone
LOCAL cAccountPhone
LOCAL nAccountPower_sport
LOCAL nAccountProcess
LOCAL nAccountRecreative_special
LOCAL nAccountResult_date_validation
LOCAL nAccountSale_accessories
LOCAL nAccountSale_by_phone
LOCAL nAccountSale_date_month
LOCAL nAccountSale_table_optionsAccessory_column
LOCAL nAccountSale_table_optionsCommercial_column
LOCAL nAccountSale_table_optionsDivision_grouped_total_column
LOCAL nAccountSale_validation
LOCAL nAccountScan
LOCAL nAccountStock_required_for_sale
LOCAL nAccountTake_over_director
LOCAL nAccountTrade_report
LOCAL nAccountUnrestricted_assignment
LOCAL nAccountUnsubscribe
LOCAL nAccountUntreated_lead
LOCAL nAccountVehicle_model_text
LOCAL nAccountVehicle_text
LOCAL nAccountVerified_sale
LOCAL nAccountVin_decoder
LOCAL cAccountWaiting_sale_date
LOCAL nAccountWaiting_sale_option
LOCAL cAdvisor
LOCAL j
LOCAL nCount_j
LOCAL nLead_id
LOCAL cAddress
LOCAL nValid
LOCAL cExtension
LOCAL cNumber
LOCAL nValidated
LOCAL nMobile
LOCAL cAccessories
LOCAL cAllowed_odometer
LOCAL nBalance
LOCAL cBudget_max
LOCAL cBudget_min
LOCAL cCash_down
LOCAL cCategory
LOCAL cCategory_rv
LOCAL cClient_number
LOCAL cColor_exterior
LOCAL cColor_interior
LOCAL cComment
LOCAL cCondition
LOCAL cEnd_contract_date
LOCAL cEnd_warranty_date
LOCAL cEngine
LOCAL cExtended_warranty
LOCAL cFuel
LOCAL cLength_max
LOCAL cLength_min
LOCAL cLicense_plate
LOCAL cMake
LOCAL cModality
LOCAL cModel
LOCAL cOdometer
LOCAL cOffer_number
LOCAL cV_option
LOCAL cOrder_number
LOCAL cPayment
LOCAL cPayment_frequency
LOCAL cPreparation
LOCAL cPrice
LOCAL cProfit
LOCAL cPurchase_date
LOCAL cRate
LOCAL cRecall
LOCAL cRecorded_date
LOCAL cResidual
LOCAL cSecurity_deposit
LOCAL cSleeping
LOCAL nSold
LOCAL cSold_by
LOCAL cSold_date
LOCAL cStock
LOCAL cStock_state
LOCAL cTerm
LOCAL nTire
LOCAL cTransmission
LOCAL cTrim
LOCAL cUrl
LOCAL cValue
LOCAL cVin
LOCAL cWarranty
LOCAL cWeight
LOCAL cYear
LOCAL cYear_max
LOCAL cYear_min

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

oHttp := CreateObject("Chilkat.Http")

oHttp:AuthToken := "ACCESS_TOKEN"

oHttp:Accept := "application/json"

cStrResp := oHttp:QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe")
IF (oHttp:LastMethodSuccess != 1)
    ? oHttp:LastErrorText
    oHttp:destroy()
    RETURN
ENDIF

? "Response Status Code: " + Str(oHttp:LastStatus)

oJsonResponse := CreateObject("Chilkat.JsonObject")
oJsonResponse:Load(cStrResp)
oJsonResponse:EmitCompact := 0
? oJsonResponse:Emit()

IF (oHttp:LastStatus != 200)
    ? "Failed."
    oHttp:destroy()
    oJsonResponse:destroy()
    RETURN
ENDIF

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

cLinksFirst := oJsonResponse:StringOf("links.first")
cLinksLast := oJsonResponse:StringOf("links.last")
cLinksPrev := oJsonResponse:StringOf("links.prev")
cLinksNext := oJsonResponse:StringOf("links.next")
nMetaCurrent_page := oJsonResponse:IntOf("meta.current_page")
nMetaFrom := oJsonResponse:IntOf("meta.from")
nMetaLast_page := oJsonResponse:IntOf("meta.last_page")
cMetaPath := oJsonResponse:StringOf("meta.path")
nMetaPer_page := oJsonResponse:IntOf("meta.per_page")
nMetaTo := oJsonResponse:IntOf("meta.to")
nMetaTotal := oJsonResponse:IntOf("meta.total")
i := 0
nCount_i := oJsonResponse:SizeOfArray("data")
DO WHILE i < nCount_i
    oJsonResponse:I := i
    nId := oJsonResponse:IntOf("data[i].id")
    cCreated_at := oJsonResponse:StringOf("data[i].created_at")
    cUpdated_at := oJsonResponse:StringOf("data[i].updated_at")
    nAccount_id := oJsonResponse:IntOf("data[i].account_id")
    cAddress_line1 := oJsonResponse:StringOf("data[i].address_line1")
    cAddress_line2 := oJsonResponse:StringOf("data[i].address_line2")
    cAppointment_date := oJsonResponse:StringOf("data[i].appointment_date")
    nAppt_call := oJsonResponse:BoolOf("data[i].appt_call")
    cAvailable_date := oJsonResponse:StringOf("data[i].available_date")
    cAverage_spending := oJsonResponse:StringOf("data[i].average_spending")
    cBe_back_date := oJsonResponse:StringOf("data[i].be_back_date")
    cBirth_date := oJsonResponse:StringOf("data[i].birth_date")
    cBusiness := oJsonResponse:StringOf("data[i].business")
    cCall_date := oJsonResponse:StringOf("data[i].call_date")
    cCity := oJsonResponse:StringOf("data[i].city")
    cCivility := oJsonResponse:StringOf("data[i].civility")
    cCode := oJsonResponse:StringOf("data[i].code")
    cCountry := oJsonResponse:StringOf("data[i].country")
    cCsi_date := oJsonResponse:StringOf("data[i].csi_date")
    cDelivered_by_id := oJsonResponse:StringOf("data[i].delivered_by_id")
    cDelivered_date := oJsonResponse:StringOf("data[i].delivered_date")
    cDelivery_date := oJsonResponse:StringOf("data[i].delivery_date")
    cDivision := oJsonResponse:StringOf("data[i].division")
    cEnd_service_date := oJsonResponse:StringOf("data[i].end_service_date")
    cFirst_name := oJsonResponse:StringOf("data[i].first_name")
    cGas := oJsonResponse:StringOf("data[i].gas")
    nGender := oJsonResponse:IntOf("data[i].gender")
    nInvoiced := oJsonResponse:BoolOf("data[i].invoiced")
    cLast_name := oJsonResponse:StringOf("data[i].last_name")
    cLast_visit_date := oJsonResponse:StringOf("data[i].last_visit_date")
    cLocale := oJsonResponse:StringOf("data[i].locale")
    cLoyalty := oJsonResponse:StringOf("data[i].loyalty")
    cNext_visit_date := oJsonResponse:StringOf("data[i].next_visit_date")
    cOdometer_last_visit := oJsonResponse:StringOf("data[i].odometer_last_visit")
    cOpen_work_order_date := oJsonResponse:StringOf("data[i].open_work_order_date")
    cPlanned_pick_up_date := oJsonResponse:StringOf("data[i].planned_pick_up_date")
    cPostal_code := oJsonResponse:StringOf("data[i].postal_code")
    cPrepaid := oJsonResponse:StringOf("data[i].prepaid")
    nPrepared := oJsonResponse:BoolOf("data[i].prepared")
    cPresented_date := oJsonResponse:StringOf("data[i].presented_date")
    cPromised_date := oJsonResponse:StringOf("data[i].promised_date")
    cProvince := oJsonResponse:StringOf("data[i].province")
    cRating := oJsonResponse:StringOf("data[i].rating")
    nReached_client := oJsonResponse:BoolOf("data[i].reached_client")
    cRefinanced_date := oJsonResponse:StringOf("data[i].refinanced_date")
    cRepair_date := oJsonResponse:StringOf("data[i].repair_date")
    cRepair_order := oJsonResponse:StringOf("data[i].repair_order")
    cResult := oJsonResponse:StringOf("data[i].result")
    cRoad_test_date := oJsonResponse:StringOf("data[i].road_test_date")
    cSale_date := oJsonResponse:StringOf("data[i].sale_date")
    cSecond_contact := oJsonResponse:StringOf("data[i].second_contact")
    cSecond_contact_civility := oJsonResponse:StringOf("data[i].second_contact_civility")
    cSegment := oJsonResponse:StringOf("data[i].segment")
    nService_cleaned := oJsonResponse:BoolOf("data[i].service_cleaned")
    cService_interval_km := oJsonResponse:StringOf("data[i].service_interval_km")
    cService_monthly_km := oJsonResponse:StringOf("data[i].service_monthly_km")
    cService_processIntention := oJsonResponse:StringOf("data[i].service_process.intention")
    cService_processTransport := oJsonResponse:StringOf("data[i].service_process.transport")
    cService_processWalk_around := oJsonResponse:StringOf("data[i].service_process.walk_around")
    cSex := oJsonResponse:StringOf("data[i].sex")
    cSource := oJsonResponse:StringOf("data[i].source")
    cStatus := oJsonResponse:StringOf("data[i].status")
    cStorage := oJsonResponse:StringOf("data[i].storage")
    cTake_over_date := oJsonResponse:StringOf("data[i].take_over_date")
    cV_type := oJsonResponse:StringOf("data[i].type")
    cUnsubscribe_all_date := oJsonResponse:StringOf("data[i].unsubscribe_all_date")
    cUnsubscribe_call_date := oJsonResponse:StringOf("data[i].unsubscribe_call_date")
    cUnsubscribe_email_date := oJsonResponse:StringOf("data[i].unsubscribe_email_date")
    cUnsubscribe_sms_date := oJsonResponse:StringOf("data[i].unsubscribe_sms_date")
    cWork_order := oJsonResponse:StringOf("data[i].work_order")
    nAccountId := oJsonResponse:IntOf("data[i].account.id")
    cAccountCreated_at := oJsonResponse:StringOf("data[i].account.created_at")
    cAccountUpdated_at := oJsonResponse:StringOf("data[i].account.updated_at")
    nAccountPartner_id := oJsonResponse:IntOf("data[i].account.partner_id")
    nAccountActivity_report := oJsonResponse:BoolOf("data[i].account.activity_report")
    nAccountCommercial := oJsonResponse:BoolOf("data[i].account.commercial")
    nAccountEvent := oJsonResponse:BoolOf("data[i].account.event")
    nAccountLeadxpress := oJsonResponse:BoolOf("data[i].account.leadxpress")
    nAccountLoyalty := oJsonResponse:BoolOf("data[i].account.loyalty")
    nAccountPhone_up := oJsonResponse:BoolOf("data[i].account.phone_up")
    nAccountRenewal := oJsonResponse:BoolOf("data[i].account.renewal")
    nAccountSale_table := oJsonResponse:BoolOf("data[i].account.sale_table")
    nAccountService := oJsonResponse:BoolOf("data[i].account.service")
    nAccountWalk_in := oJsonResponse:BoolOf("data[i].account.walk_in")
    nAccountWebboost := oJsonResponse:BoolOf("data[i].account.webboost")
    nAccountAccount_manager := oJsonResponse:BoolOf("data[i].account.account_manager")
    cAccountActivation_date := oJsonResponse:StringOf("data[i].account.activation_date")
    nAccountActive := oJsonResponse:BoolOf("data[i].account.active")
    nAccountAssigned_lead := oJsonResponse:BoolOf("data[i].account.assigned_lead")
    nAccountAuto_renewal := oJsonResponse:BoolOf("data[i].account.auto_renewal")
    nAccountAuto_renewal_new := oJsonResponse:BoolOf("data[i].account.auto_renewal_new")
    nAccountAuto_renewal_used := oJsonResponse:BoolOf("data[i].account.auto_renewal_used")
    nAccountAutomation := oJsonResponse:BoolOf("data[i].account.automation")
    nAccountBdc_advisor := oJsonResponse:BoolOf("data[i].account.bdc_advisor")
    nAccountCalendar_options := oJsonResponse:BoolOf("data[i].account.calendar_options")
    nAccountClient_card_fieldsProcessGas := oJsonResponse:BoolOf("data[i].account.client_card_fields.process.gas")
    nAccountClient_card_fieldsProcessRecorded := oJsonResponse:BoolOf("data[i].account.client_card_fields.process.recorded")
    nAccountClient_card_fieldsProcessAvailable := oJsonResponse:BoolOf("data[i].account.client_card_fields.process.available")
    nAccountClient_card_fieldsProcessDiscounted := oJsonResponse:BoolOf("data[i].account.client_card_fields.process.discounted")
    nAccountClient_card_fieldsCommercialProfit := oJsonResponse:BoolOf("data[i].account.client_card_fields.commercial.profit")
    nAccountClient_card_fieldsCommercialExclude := oJsonResponse:BoolOf("data[i].account.client_card_fields.commercial.exclude")
    nAccountClient_card_fieldsCommercialMeeting := oJsonResponse:BoolOf("data[i].account.client_card_fields.commercial.meeting")
    nAccountClient_card_fieldsPerformanceDeposit := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.deposit")
    nAccountClient_card_fieldsPerformanceRefinanced := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.refinanced")
    nAccountClient_card_fieldsPerformanceDealer_tour := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.dealer_tour")
    nAccountClient_card_fieldsPerformanceWalk_around := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.walk_around")
    nAccountClient_card_fieldsPerformanceQualification := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.qualification")
    nAccountClient_card_fieldsPerformanceTwenty_four_hour := oJsonResponse:BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour")
    nAccountClient_card_fieldsGeneral_infoBudget := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.budget")
    nAccountClient_card_fieldsGeneral_infoSector := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.sector")
    nAccountClient_card_fieldsGeneral_infoCustom_1 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_1")
    nAccountClient_card_fieldsGeneral_infoCustom_2 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_2")
    nAccountClient_card_fieldsGeneral_infoCustom_3 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_3")
    nAccountClient_card_fieldsGeneral_infoCustom_4 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_4")
    nAccountClient_card_fieldsGeneral_infoCustom_5 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_5")
    nAccountClient_card_fieldsGeneral_infoCustom_6 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_6")
    nAccountClient_card_fieldsGeneral_infoCustom_7 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_7")
    nAccountClient_card_fieldsGeneral_infoCustom_8 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_8")
    nAccountClient_card_fieldsGeneral_infoCustom_9 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_9")
    nAccountClient_card_fieldsGeneral_infoCustom_10 := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.custom_10")
    nAccountClient_card_fieldsGeneral_infoCommunication_preference := oJsonResponse:BoolOf("data[i].account.client_card_fields.general_info.communication_preference")
    nAccountClient_card_fieldsWanted_vehicleVin := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin")
    nAccountClient_card_fieldsWanted_vehicleFuel := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel")
    nAccountClient_card_fieldsWanted_vehicleRate := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate")
    nAccountClient_card_fieldsWanted_vehicleTerm := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.term")
    nAccountClient_card_fieldsWanted_vehicleTire := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire")
    nAccountClient_card_fieldsWanted_vehicleYear := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.year")
    nAccountClient_card_fieldsWanted_vehicleColor := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.color")
    nAccountClient_card_fieldsWanted_vehiclePrice := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.price")
    nAccountClient_card_fieldsWanted_vehicleStock := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock")
    nAccountClient_card_fieldsWanted_vehicleTotal := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.total")
    nAccountClient_card_fieldsWanted_vehicleBudget := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget")
    nAccountClient_card_fieldsWanted_vehicleEngine := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine")
    nAccountClient_card_fieldsWanted_vehicleLength := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.length")
    nAccountClient_card_fieldsWanted_vehicleProfit := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit")
    nAccountClient_card_fieldsWanted_vehicleSuffix := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix")
    nAccountClient_card_fieldsWanted_vehicleWeight := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight")
    nAccountClient_card_fieldsWanted_vehicleComment := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment")
    nAccountClient_card_fieldsWanted_vehicleMileage := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage")
    nAccountClient_card_fieldsWanted_vehiclePayment := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment")
    nAccountClient_card_fieldsWanted_vehicleBodyType := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType")
    nAccountClient_card_fieldsWanted_vehicleCategory := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.category")
    nAccountClient_card_fieldsWanted_vehicleModality := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality")
    nAccountClient_card_fieldsWanted_vehicleResidual := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual")
    nAccountClient_card_fieldsWanted_vehicleSleeping := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping")
    nAccountClient_card_fieldsWanted_vehicleWarranty := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty")
    nAccountClient_card_fieldsWanted_vehicleFrequency := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency")
    nAccountClient_card_fieldsWanted_vehicleAccessories := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories")
    nAccountClient_card_fieldsWanted_vehicleCategory_rv := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv")
    nAccountClient_card_fieldsWanted_vehiclePreparation := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation")
    nAccountClient_card_fieldsWanted_vehicleInitial_cash := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash")
    nAccountClient_card_fieldsWanted_vehicleOffer_number := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number")
    nAccountClient_card_fieldsWanted_vehicleOrder_number := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number")
    nAccountClient_card_fieldsWanted_vehicleTransmission := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission")
    nAccountClient_card_fieldsWanted_vehicleDocumentation := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation")
    nAccountClient_card_fieldsWanted_vehicleDrivingWheels := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels")
    nAccountClient_card_fieldsWanted_vehicleColor_exterior := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior")
    nAccountClient_card_fieldsWanted_vehicleColor_interior := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior")
    nAccountClient_card_fieldsWanted_vehicleAllowed_mileage := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage")
    nAccountClient_card_fieldsWanted_vehicleSecurity_deposit := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit")
    nAccountClient_card_fieldsWanted_vehicleEnd_contract_date := oJsonResponse:BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date")
    nAccountClient_card_fieldsExchange_vehicleVin := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin")
    nAccountClient_card_fieldsExchange_vehicleFuel := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel")
    nAccountClient_card_fieldsExchange_vehicleLink := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.link")
    nAccountClient_card_fieldsExchange_vehicleRate := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate")
    nAccountClient_card_fieldsExchange_vehicleTerm := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.term")
    nAccountClient_card_fieldsExchange_vehicleYear := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.year")
    nAccountClient_card_fieldsExchange_vehicleColor := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.color")
    nAccountClient_card_fieldsExchange_vehiclePrice := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.price")
    nAccountClient_card_fieldsExchange_vehicleStock := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock")
    nAccountClient_card_fieldsExchange_vehicleValue := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.value")
    nAccountClient_card_fieldsExchange_vehicleBudget := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget")
    nAccountClient_card_fieldsExchange_vehicleEngine := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine")
    nAccountClient_card_fieldsExchange_vehicleLength := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.length")
    nAccountClient_card_fieldsExchange_vehicleProfit := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit")
    nAccountClient_card_fieldsExchange_vehicleSuffix := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix")
    nAccountClient_card_fieldsExchange_vehicleWeight := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight")
    nAccountClient_card_fieldsExchange_vehicleBalance := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance")
    nAccountClient_card_fieldsExchange_vehicleComment := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment")
    nAccountClient_card_fieldsExchange_vehicleMileage := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage")
    nAccountClient_card_fieldsExchange_vehiclePayment := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment")
    nAccountClient_card_fieldsExchange_vehicleRenewal := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal")
    nAccountClient_card_fieldsExchange_vehicleSold_by := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by")
    nAccountClient_card_fieldsExchange_vehicleBodyType := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType")
    nAccountClient_card_fieldsExchange_vehicleCategory := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.category")
    nAccountClient_card_fieldsExchange_vehicleModality := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality")
    nAccountClient_card_fieldsExchange_vehicleResidual := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual")
    nAccountClient_card_fieldsExchange_vehicleSleeping := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping")
    nAccountClient_card_fieldsExchange_vehicleWarranty := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty")
    nAccountClient_card_fieldsExchange_vehicleCondition := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition")
    nAccountClient_card_fieldsExchange_vehicleFrequency := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency")
    nAccountClient_card_fieldsExchange_vehicleIntention := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention")
    nAccountClient_card_fieldsExchange_vehicleRefinance := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance")
    nAccountClient_card_fieldsExchange_vehicleRequested := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested")
    nAccountClient_card_fieldsExchange_vehicleSold_date := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date")
    nAccountClient_card_fieldsExchange_vehicleCategory_rv := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv")
    nAccountClient_card_fieldsExchange_vehicleInstitution := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution")
    nAccountClient_card_fieldsExchange_vehicleInitial_cash := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash")
    nAccountClient_card_fieldsExchange_vehicleOffer_number := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number")
    nAccountClient_card_fieldsExchange_vehicleTransmission := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission")
    nAccountClient_card_fieldsExchange_vehicleDrivingWheels := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels")
    nAccountClient_card_fieldsExchange_vehicleColor_exterior := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior")
    nAccountClient_card_fieldsExchange_vehicleColor_interior := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior")
    nAccountClient_card_fieldsExchange_vehicleAllowed_mileage := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage")
    nAccountClient_card_fieldsExchange_vehicleSecurity_deposit := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit")
    nAccountClient_card_fieldsExchange_vehicleEnd_contract_date := oJsonResponse:BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date")
    nAccountClient_number := oJsonResponse:BoolOf("data[i].account.client_number")
    nAccountConfirmation_appt := oJsonResponse:BoolOf("data[i].account.confirmation_appt")
    nAccountCredit := oJsonResponse:BoolOf("data[i].account.credit")
    nAccountCsi := oJsonResponse:BoolOf("data[i].account.csi")
    nAccountCsi_used := oJsonResponse:BoolOf("data[i].account.csi_used")
    cAccountDefault_deliveryman_user_id := oJsonResponse:StringOf("data[i].account.default_deliveryman_user_id")
    nAccountDelivered_by := oJsonResponse:BoolOf("data[i].account.delivered_by")
    nAccountDisable_communication_audio := oJsonResponse:BoolOf("data[i].account.disable_communication_audio")
    nAccountDuplicates := oJsonResponse:BoolOf("data[i].account.duplicates")
    nAccountGuest_action := oJsonResponse:BoolOf("data[i].account.guest_action")
    nAccountEmail_client := oJsonResponse:BoolOf("data[i].account.email_client")
    nAccountIn_turn := oJsonResponse:BoolOf("data[i].account.in_turn")
    nAccountIn_turn_director_management := oJsonResponse:BoolOf("data[i].account.in_turn_director_management")
    nAccountLeads_other_division := oJsonResponse:BoolOf("data[i].account.leads_other_division")
    nAccountLeadxpress_optionPriority := oJsonResponse:IntOf("data[i].account.leadxpress_option.priority")
    nAccountLeadxpress_optionReminderFrequency := oJsonResponse:IntOf("data[i].account.leadxpress_option.reminder.frequency")
    nAccountLeadxpress_optionReminderRecurrence := oJsonResponse:IntOf("data[i].account.leadxpress_option.reminder.recurrence")
    nAccountLeadxpress_optionScheduleAccount := oJsonResponse:BoolOf("data[i].account.leadxpress_option.schedule.account")
    nAccountLeadxpress_optionScheduleAdvisor := oJsonResponse:BoolOf("data[i].account.leadxpress_option.schedule.advisor")
    nAccountLimited_audio_access := oJsonResponse:BoolOf("data[i].account.limited_audio_access")
    cAccountLogo := oJsonResponse:StringOf("data[i].account.logo")
    cAccountLogo_en := oJsonResponse:StringOf("data[i].account.logo_en")
    nAccountMandatory_coordinate := oJsonResponse:BoolOf("data[i].account.mandatory_coordinate")
    nAccountManually_status := oJsonResponse:BoolOf("data[i].account.manually_status")
    cAccountMerge_rule := oJsonResponse:StringOf("data[i].account.merge_rule")
    nAccountMonth_start_day := oJsonResponse:IntOf("data[i].account.month_start_day")
    cAccountName := oJsonResponse:StringOf("data[i].account.name")
    nAccountNiotext := oJsonResponse:BoolOf("data[i].account.niotext")
    nAccountNiotext_phone := oJsonResponse:BoolOf("data[i].account.niotext_phone")
    cAccountPhone := oJsonResponse:StringOf("data[i].account.phone")
    nAccountPower_sport := oJsonResponse:BoolOf("data[i].account.power_sport")
    nAccountProcess := oJsonResponse:BoolOf("data[i].account.process")
    nAccountRecreative_special := oJsonResponse:BoolOf("data[i].account.recreative_special")
    nAccountResult_date_validation := oJsonResponse:BoolOf("data[i].account.result_date_validation")
    nAccountSale_accessories := oJsonResponse:BoolOf("data[i].account.sale_accessories")
    nAccountSale_by_phone := oJsonResponse:BoolOf("data[i].account.sale_by_phone")
    nAccountSale_date_month := oJsonResponse:BoolOf("data[i].account.sale_date_month")
    nAccountSale_table_optionsAccessory_column := oJsonResponse:BoolOf("data[i].account.sale_table_options.accessory_column")
    nAccountSale_table_optionsCommercial_column := oJsonResponse:BoolOf("data[i].account.sale_table_options.commercial_column")
    nAccountSale_table_optionsDivision_grouped_total_column := oJsonResponse:BoolOf("data[i].account.sale_table_options.division_grouped_total_column")
    nAccountSale_validation := oJsonResponse:BoolOf("data[i].account.sale_validation")
    nAccountScan := oJsonResponse:BoolOf("data[i].account.scan")
    nAccountStock_required_for_sale := oJsonResponse:BoolOf("data[i].account.stock_required_for_sale")
    nAccountTake_over_director := oJsonResponse:BoolOf("data[i].account.take_over_director")
    nAccountTrade_report := oJsonResponse:BoolOf("data[i].account.trade_report")
    nAccountUnrestricted_assignment := oJsonResponse:BoolOf("data[i].account.unrestricted_assignment")
    nAccountUnsubscribe := oJsonResponse:BoolOf("data[i].account.unsubscribe")
    nAccountUntreated_lead := oJsonResponse:BoolOf("data[i].account.untreated_lead")
    nAccountVehicle_model_text := oJsonResponse:BoolOf("data[i].account.vehicle_model_text")
    nAccountVehicle_text := oJsonResponse:BoolOf("data[i].account.vehicle_text")
    nAccountVerified_sale := oJsonResponse:BoolOf("data[i].account.verified_sale")
    nAccountVin_decoder := oJsonResponse:BoolOf("data[i].account.vin_decoder")
    cAccountWaiting_sale_date := oJsonResponse:StringOf("data[i].account.waiting_sale_date")
    nAccountWaiting_sale_option := oJsonResponse:BoolOf("data[i].account.waiting_sale_option")
    cAdvisor := oJsonResponse:StringOf("data[i].advisor")
    j := 0
    nCount_j := oJsonResponse:SizeOfArray("data[i].emails")
    DO WHILE j < nCount_j
        oJsonResponse:J := j
        nId := oJsonResponse:IntOf("data[i].emails[j].id")
        cCreated_at := oJsonResponse:StringOf("data[i].emails[j].created_at")
        cUpdated_at := oJsonResponse:StringOf("data[i].emails[j].updated_at")
        nLead_id := oJsonResponse:IntOf("data[i].emails[j].lead_id")
        cAddress := oJsonResponse:StringOf("data[i].emails[j].address")
        cV_type := oJsonResponse:StringOf("data[i].emails[j].type")
        nValid := oJsonResponse:BoolOf("data[i].emails[j].valid")
        j := j + 1
    ENDDO
    j := 0
    nCount_j := oJsonResponse:SizeOfArray("data[i].phones")
    DO WHILE j < nCount_j
        oJsonResponse:J := j
        nId := oJsonResponse:IntOf("data[i].phones[j].id")
        cCreated_at := oJsonResponse:StringOf("data[i].phones[j].created_at")
        cUpdated_at := oJsonResponse:StringOf("data[i].phones[j].updated_at")
        nLead_id := oJsonResponse:IntOf("data[i].phones[j].lead_id")
        cExtension := oJsonResponse:StringOf("data[i].phones[j].extension")
        cNumber := oJsonResponse:StringOf("data[i].phones[j].number")
        cV_type := oJsonResponse:StringOf("data[i].phones[j].type")
        nValid := oJsonResponse:BoolOf("data[i].phones[j].valid")
        nValidated := oJsonResponse:BoolOf("data[i].phones[j].validated")
        nMobile := oJsonResponse:BoolOf("data[i].phones[j].mobile")
        j := j + 1
    ENDDO
    j := 0
    nCount_j := oJsonResponse:SizeOfArray("data[i].vehicles")
    DO WHILE j < nCount_j
        oJsonResponse:J := j
        nId := oJsonResponse:IntOf("data[i].vehicles[j].id")
        cCreated_at := oJsonResponse:StringOf("data[i].vehicles[j].created_at")
        cUpdated_at := oJsonResponse:StringOf("data[i].vehicles[j].updated_at")
        nLead_id := oJsonResponse:IntOf("data[i].vehicles[j].lead_id")
        cAccessories := oJsonResponse:StringOf("data[i].vehicles[j].accessories")
        cAllowed_odometer := oJsonResponse:StringOf("data[i].vehicles[j].allowed_odometer")
        nBalance := oJsonResponse:IntOf("data[i].vehicles[j].balance")
        cBudget_max := oJsonResponse:StringOf("data[i].vehicles[j].budget_max")
        cBudget_min := oJsonResponse:StringOf("data[i].vehicles[j].budget_min")
        cCash_down := oJsonResponse:StringOf("data[i].vehicles[j].cash_down")
        cCategory := oJsonResponse:StringOf("data[i].vehicles[j].category")
        cCategory_rv := oJsonResponse:StringOf("data[i].vehicles[j].category_rv")
        cClient_number := oJsonResponse:StringOf("data[i].vehicles[j].client_number")
        cColor_exterior := oJsonResponse:StringOf("data[i].vehicles[j].color_exterior")
        cColor_interior := oJsonResponse:StringOf("data[i].vehicles[j].color_interior")
        cComment := oJsonResponse:StringOf("data[i].vehicles[j].comment")
        cCondition := oJsonResponse:StringOf("data[i].vehicles[j].condition")
        cEnd_contract_date := oJsonResponse:StringOf("data[i].vehicles[j].end_contract_date")
        cEnd_warranty_date := oJsonResponse:StringOf("data[i].vehicles[j].end_warranty_date")
        cEngine := oJsonResponse:StringOf("data[i].vehicles[j].engine")
        cExtended_warranty := oJsonResponse:StringOf("data[i].vehicles[j].extended_warranty")
        cFuel := oJsonResponse:StringOf("data[i].vehicles[j].fuel")
        cLength_max := oJsonResponse:StringOf("data[i].vehicles[j].length_max")
        cLength_min := oJsonResponse:StringOf("data[i].vehicles[j].length_min")
        cLicense_plate := oJsonResponse:StringOf("data[i].vehicles[j].license_plate")
        cMake := oJsonResponse:StringOf("data[i].vehicles[j].make")
        cModality := oJsonResponse:StringOf("data[i].vehicles[j].modality")
        cModel := oJsonResponse:StringOf("data[i].vehicles[j].model")
        cOdometer := oJsonResponse:StringOf("data[i].vehicles[j].odometer")
        cOffer_number := oJsonResponse:StringOf("data[i].vehicles[j].offer_number")
        cV_option := oJsonResponse:StringOf("data[i].vehicles[j].option")
        cOrder_number := oJsonResponse:StringOf("data[i].vehicles[j].order_number")
        cPayment := oJsonResponse:StringOf("data[i].vehicles[j].payment")
        cPayment_frequency := oJsonResponse:StringOf("data[i].vehicles[j].payment_frequency")
        cPreparation := oJsonResponse:StringOf("data[i].vehicles[j].preparation")
        cPrice := oJsonResponse:StringOf("data[i].vehicles[j].price")
        cProfit := oJsonResponse:StringOf("data[i].vehicles[j].profit")
        cPurchase_date := oJsonResponse:StringOf("data[i].vehicles[j].purchase_date")
        cRate := oJsonResponse:StringOf("data[i].vehicles[j].rate")
        cRecall := oJsonResponse:StringOf("data[i].vehicles[j].recall")
        cRecorded_date := oJsonResponse:StringOf("data[i].vehicles[j].recorded_date")
        cResidual := oJsonResponse:StringOf("data[i].vehicles[j].residual")
        cSecurity_deposit := oJsonResponse:StringOf("data[i].vehicles[j].security_deposit")
        cSleeping := oJsonResponse:StringOf("data[i].vehicles[j].sleeping")
        nSold := oJsonResponse:BoolOf("data[i].vehicles[j].sold")
        cSold_by := oJsonResponse:StringOf("data[i].vehicles[j].sold_by")
        cSold_date := oJsonResponse:StringOf("data[i].vehicles[j].sold_date")
        cStock := oJsonResponse:StringOf("data[i].vehicles[j].stock")
        cStock_state := oJsonResponse:StringOf("data[i].vehicles[j].stock_state")
        cTerm := oJsonResponse:StringOf("data[i].vehicles[j].term")
        nTire := oJsonResponse:BoolOf("data[i].vehicles[j].tire")
        cTransmission := oJsonResponse:StringOf("data[i].vehicles[j].transmission")
        cTrim := oJsonResponse:StringOf("data[i].vehicles[j].trim")
        cV_type := oJsonResponse:StringOf("data[i].vehicles[j].type")
        cUrl := oJsonResponse:StringOf("data[i].vehicles[j].url")
        cValue := oJsonResponse:StringOf("data[i].vehicles[j].value")
        cVin := oJsonResponse:StringOf("data[i].vehicles[j].vin")
        cWarranty := oJsonResponse:StringOf("data[i].vehicles[j].warranty")
        cWeight := oJsonResponse:StringOf("data[i].vehicles[j].weight")
        cYear := oJsonResponse:StringOf("data[i].vehicles[j].year")
        cYear_max := oJsonResponse:StringOf("data[i].vehicles[j].year_max")
        cYear_min := oJsonResponse:StringOf("data[i].vehicles[j].year_min")
        j := j + 1
    ENDDO
    j := 0
    nCount_j := oJsonResponse:SizeOfArray("data[i].products")
    DO WHILE j < nCount_j
        oJsonResponse:J := j
        j := j + 1
    ENDDO
    i := i + 1
ENDDO

oHttp:destroy()
oJsonResponse:destroy()