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