|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(PowerShell) Activix CRM Search for LeadsDemonstrates how to full-text search for leads, returning a JSON list of leads. For more information, see https://docs.crm.activix.ca/api/resources/lead
Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-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 } |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.