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