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
(Lianja) 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
// This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. loHttp = createobject("CkHttp") loHttp.AuthToken = "ACCESS_TOKEN" loHttp.Accept = "application/json" lcStrResp = loHttp.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe") if (loHttp.LastMethodSuccess <> .T.) then ? loHttp.LastErrorText release loHttp return endif ? "Response Status Code: " + str(loHttp.LastStatus) loJsonResponse = createobject("CkJsonObject") loJsonResponse.Load(lcStrResp) loJsonResponse.EmitCompact = .F. ? loJsonResponse.Emit() if (loHttp.LastStatus <> 200) then ? "Failed." release loHttp release loJsonResponse return endif // Sample output... // (See the parsing code below..) // // Use this online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON // { // "data": [ // { // "id": 3387562, // "created_at": "2018-04-09T18:05:00+00:00", // "updated_at": "2018-04-09T18:07:00+00:00", // "first_name": "John", // "last_name": "Doe", // ... // "account": { // "id": 66, // ... // }, // "advisor": { // "id": 51112, // ... // }, // "emails": [ // { // "id": 3664451, // ... // }, // ... // ], // "phones": [ // { // "id": 9465546, // ... // }, // ... // ], // "vehicles": [ // { // "id": 4542214, // ... // }, // ... // ] // }, // ... // ], // "links": { // "first": "https://crm.activix.ca/api/v2/leads/search?query=John&page=1", // "last": "https://crm.activix.ca/api/v2/leads/search?query=John&page=47", // "prev": null, // "next": "https://crm.activix.ca/api/v2/leads/search?query=John&page=2" // }, // "meta": { // "current_page": 1, // "from": 1, // "last_page": 47, // "path": "https://crm.activix.ca/api/v2/leads/search", // "per_page": 25, // "to": 25, // "total": 1161 // } // } lcLinksFirst = loJsonResponse.StringOf("links.first") lcLinksLast = loJsonResponse.StringOf("links.last") lcLinksPrev = loJsonResponse.StringOf("links.prev") lcLinksNext = loJsonResponse.StringOf("links.next") lnMetaCurrent_page = loJsonResponse.IntOf("meta.current_page") lnMetaFrom = loJsonResponse.IntOf("meta.from") lnMetaLast_page = loJsonResponse.IntOf("meta.last_page") lcMetaPath = loJsonResponse.StringOf("meta.path") lnMetaPer_page = loJsonResponse.IntOf("meta.per_page") lnMetaTo = loJsonResponse.IntOf("meta.to") lnMetaTotal = loJsonResponse.IntOf("meta.total") i = 0 lnCount_i = loJsonResponse.SizeOfArray("data") do while i < lnCount_i loJsonResponse.I = i lnId = loJsonResponse.IntOf("data[i].id") lcCreated_at = loJsonResponse.StringOf("data[i].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].updated_at") lnAccount_id = loJsonResponse.IntOf("data[i].account_id") lcAddress_line1 = loJsonResponse.StringOf("data[i].address_line1") lcAddress_line2 = loJsonResponse.StringOf("data[i].address_line2") lcAppointment_date = loJsonResponse.StringOf("data[i].appointment_date") llAppt_call = loJsonResponse.BoolOf("data[i].appt_call") lcAvailable_date = loJsonResponse.StringOf("data[i].available_date") lcAverage_spending = loJsonResponse.StringOf("data[i].average_spending") lcBe_back_date = loJsonResponse.StringOf("data[i].be_back_date") lcBirth_date = loJsonResponse.StringOf("data[i].birth_date") lcBusiness = loJsonResponse.StringOf("data[i].business") lcCall_date = loJsonResponse.StringOf("data[i].call_date") lcCity = loJsonResponse.StringOf("data[i].city") lcCivility = loJsonResponse.StringOf("data[i].civility") lcCode = loJsonResponse.StringOf("data[i].code") lcCountry = loJsonResponse.StringOf("data[i].country") lcCsi_date = loJsonResponse.StringOf("data[i].csi_date") lcDelivered_by_id = loJsonResponse.StringOf("data[i].delivered_by_id") lcDelivered_date = loJsonResponse.StringOf("data[i].delivered_date") lcDelivery_date = loJsonResponse.StringOf("data[i].delivery_date") lcDivision = loJsonResponse.StringOf("data[i].division") lcEnd_service_date = loJsonResponse.StringOf("data[i].end_service_date") lcFirst_name = loJsonResponse.StringOf("data[i].first_name") lcGas = loJsonResponse.StringOf("data[i].gas") lnGender = loJsonResponse.IntOf("data[i].gender") llInvoiced = loJsonResponse.BoolOf("data[i].invoiced") lcLast_name = loJsonResponse.StringOf("data[i].last_name") lcLast_visit_date = loJsonResponse.StringOf("data[i].last_visit_date") lcLocale = loJsonResponse.StringOf("data[i].locale") lcLoyalty = loJsonResponse.StringOf("data[i].loyalty") lcNext_visit_date = loJsonResponse.StringOf("data[i].next_visit_date") lcOdometer_last_visit = loJsonResponse.StringOf("data[i].odometer_last_visit") lcOpen_work_order_date = loJsonResponse.StringOf("data[i].open_work_order_date") lcPlanned_pick_up_date = loJsonResponse.StringOf("data[i].planned_pick_up_date") lcPostal_code = loJsonResponse.StringOf("data[i].postal_code") lcPrepaid = loJsonResponse.StringOf("data[i].prepaid") llPrepared = loJsonResponse.BoolOf("data[i].prepared") lcPresented_date = loJsonResponse.StringOf("data[i].presented_date") lcPromised_date = loJsonResponse.StringOf("data[i].promised_date") lcProvince = loJsonResponse.StringOf("data[i].province") lcRating = loJsonResponse.StringOf("data[i].rating") llReached_client = loJsonResponse.BoolOf("data[i].reached_client") lcRefinanced_date = loJsonResponse.StringOf("data[i].refinanced_date") lcRepair_date = loJsonResponse.StringOf("data[i].repair_date") lcRepair_order = loJsonResponse.StringOf("data[i].repair_order") lcResult = loJsonResponse.StringOf("data[i].result") lcRoad_test_date = loJsonResponse.StringOf("data[i].road_test_date") lcSale_date = loJsonResponse.StringOf("data[i].sale_date") lcSecond_contact = loJsonResponse.StringOf("data[i].second_contact") lcSecond_contact_civility = loJsonResponse.StringOf("data[i].second_contact_civility") lcSegment = loJsonResponse.StringOf("data[i].segment") llService_cleaned = loJsonResponse.BoolOf("data[i].service_cleaned") lcService_interval_km = loJsonResponse.StringOf("data[i].service_interval_km") lcService_monthly_km = loJsonResponse.StringOf("data[i].service_monthly_km") lcService_processIntention = loJsonResponse.StringOf("data[i].service_process.intention") lcService_processTransport = loJsonResponse.StringOf("data[i].service_process.transport") lcService_processWalk_around = loJsonResponse.StringOf("data[i].service_process.walk_around") lcSex = loJsonResponse.StringOf("data[i].sex") lcSource = loJsonResponse.StringOf("data[i].source") lcStatus = loJsonResponse.StringOf("data[i].status") lcStorage = loJsonResponse.StringOf("data[i].storage") lcTake_over_date = loJsonResponse.StringOf("data[i].take_over_date") lcV_type = loJsonResponse.StringOf("data[i].type") lcUnsubscribe_all_date = loJsonResponse.StringOf("data[i].unsubscribe_all_date") lcUnsubscribe_call_date = loJsonResponse.StringOf("data[i].unsubscribe_call_date") lcUnsubscribe_email_date = loJsonResponse.StringOf("data[i].unsubscribe_email_date") lcUnsubscribe_sms_date = loJsonResponse.StringOf("data[i].unsubscribe_sms_date") lcWork_order = loJsonResponse.StringOf("data[i].work_order") lnAccountId = loJsonResponse.IntOf("data[i].account.id") lcAccountCreated_at = loJsonResponse.StringOf("data[i].account.created_at") lcAccountUpdated_at = loJsonResponse.StringOf("data[i].account.updated_at") lnAccountPartner_id = loJsonResponse.IntOf("data[i].account.partner_id") llAccountActivity_report = loJsonResponse.BoolOf("data[i].account.activity_report") llAccountCommercial = loJsonResponse.BoolOf("data[i].account.commercial") llAccountEvent = loJsonResponse.BoolOf("data[i].account.event") llAccountLeadxpress = loJsonResponse.BoolOf("data[i].account.leadxpress") llAccountLoyalty = loJsonResponse.BoolOf("data[i].account.loyalty") llAccountPhone_up = loJsonResponse.BoolOf("data[i].account.phone_up") llAccountRenewal = loJsonResponse.BoolOf("data[i].account.renewal") llAccountSale_table = loJsonResponse.BoolOf("data[i].account.sale_table") llAccountService = loJsonResponse.BoolOf("data[i].account.service") llAccountWalk_in = loJsonResponse.BoolOf("data[i].account.walk_in") llAccountWebboost = loJsonResponse.BoolOf("data[i].account.webboost") llAccountAccount_manager = loJsonResponse.BoolOf("data[i].account.account_manager") lcAccountActivation_date = loJsonResponse.StringOf("data[i].account.activation_date") llAccountActive = loJsonResponse.BoolOf("data[i].account.active") llAccountAssigned_lead = loJsonResponse.BoolOf("data[i].account.assigned_lead") llAccountAuto_renewal = loJsonResponse.BoolOf("data[i].account.auto_renewal") llAccountAuto_renewal_new = loJsonResponse.BoolOf("data[i].account.auto_renewal_new") llAccountAuto_renewal_used = loJsonResponse.BoolOf("data[i].account.auto_renewal_used") llAccountAutomation = loJsonResponse.BoolOf("data[i].account.automation") llAccountBdc_advisor = loJsonResponse.BoolOf("data[i].account.bdc_advisor") llAccountCalendar_options = loJsonResponse.BoolOf("data[i].account.calendar_options") llAccountClient_card_fieldsProcessGas = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.gas") llAccountClient_card_fieldsProcessRecorded = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded") llAccountClient_card_fieldsProcessAvailable = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.available") llAccountClient_card_fieldsProcessDiscounted = loJsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted") llAccountClient_card_fieldsCommercialProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit") llAccountClient_card_fieldsCommercialExclude = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude") llAccountClient_card_fieldsCommercialMeeting = loJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting") llAccountClient_card_fieldsPerformanceDeposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit") llAccountClient_card_fieldsPerformanceRefinanced = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced") llAccountClient_card_fieldsPerformanceDealer_tour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour") llAccountClient_card_fieldsPerformanceWalk_around = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around") llAccountClient_card_fieldsPerformanceQualification = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification") llAccountClient_card_fieldsPerformanceTwenty_four_hour = loJsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour") llAccountClient_card_fieldsGeneral_infoBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget") llAccountClient_card_fieldsGeneral_infoSector = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector") llAccountClient_card_fieldsGeneral_infoCustom_1 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1") llAccountClient_card_fieldsGeneral_infoCustom_2 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2") llAccountClient_card_fieldsGeneral_infoCustom_3 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3") llAccountClient_card_fieldsGeneral_infoCustom_4 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4") llAccountClient_card_fieldsGeneral_infoCustom_5 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5") llAccountClient_card_fieldsGeneral_infoCustom_6 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6") llAccountClient_card_fieldsGeneral_infoCustom_7 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7") llAccountClient_card_fieldsGeneral_infoCustom_8 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8") llAccountClient_card_fieldsGeneral_infoCustom_9 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9") llAccountClient_card_fieldsGeneral_infoCustom_10 = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10") llAccountClient_card_fieldsGeneral_infoCommunication_preference = loJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference") llAccountClient_card_fieldsWanted_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin") llAccountClient_card_fieldsWanted_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel") llAccountClient_card_fieldsWanted_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate") llAccountClient_card_fieldsWanted_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term") llAccountClient_card_fieldsWanted_vehicleTire = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire") llAccountClient_card_fieldsWanted_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year") llAccountClient_card_fieldsWanted_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color") llAccountClient_card_fieldsWanted_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price") llAccountClient_card_fieldsWanted_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock") llAccountClient_card_fieldsWanted_vehicleTotal = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total") llAccountClient_card_fieldsWanted_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget") llAccountClient_card_fieldsWanted_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine") llAccountClient_card_fieldsWanted_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length") llAccountClient_card_fieldsWanted_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit") llAccountClient_card_fieldsWanted_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix") llAccountClient_card_fieldsWanted_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight") llAccountClient_card_fieldsWanted_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment") llAccountClient_card_fieldsWanted_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage") llAccountClient_card_fieldsWanted_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment") llAccountClient_card_fieldsWanted_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType") llAccountClient_card_fieldsWanted_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category") llAccountClient_card_fieldsWanted_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality") llAccountClient_card_fieldsWanted_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual") llAccountClient_card_fieldsWanted_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping") llAccountClient_card_fieldsWanted_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty") llAccountClient_card_fieldsWanted_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency") llAccountClient_card_fieldsWanted_vehicleAccessories = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories") llAccountClient_card_fieldsWanted_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv") llAccountClient_card_fieldsWanted_vehiclePreparation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation") llAccountClient_card_fieldsWanted_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash") llAccountClient_card_fieldsWanted_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number") llAccountClient_card_fieldsWanted_vehicleOrder_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number") llAccountClient_card_fieldsWanted_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission") llAccountClient_card_fieldsWanted_vehicleDocumentation = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation") llAccountClient_card_fieldsWanted_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels") llAccountClient_card_fieldsWanted_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior") llAccountClient_card_fieldsWanted_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior") llAccountClient_card_fieldsWanted_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage") llAccountClient_card_fieldsWanted_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit") llAccountClient_card_fieldsWanted_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date") llAccountClient_card_fieldsExchange_vehicleVin = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin") llAccountClient_card_fieldsExchange_vehicleFuel = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel") llAccountClient_card_fieldsExchange_vehicleLink = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link") llAccountClient_card_fieldsExchange_vehicleRate = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate") llAccountClient_card_fieldsExchange_vehicleTerm = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term") llAccountClient_card_fieldsExchange_vehicleYear = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year") llAccountClient_card_fieldsExchange_vehicleColor = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color") llAccountClient_card_fieldsExchange_vehiclePrice = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price") llAccountClient_card_fieldsExchange_vehicleStock = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock") llAccountClient_card_fieldsExchange_vehicleValue = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value") llAccountClient_card_fieldsExchange_vehicleBudget = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget") llAccountClient_card_fieldsExchange_vehicleEngine = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine") llAccountClient_card_fieldsExchange_vehicleLength = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length") llAccountClient_card_fieldsExchange_vehicleProfit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit") llAccountClient_card_fieldsExchange_vehicleSuffix = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix") llAccountClient_card_fieldsExchange_vehicleWeight = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight") llAccountClient_card_fieldsExchange_vehicleBalance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance") llAccountClient_card_fieldsExchange_vehicleComment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment") llAccountClient_card_fieldsExchange_vehicleMileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage") llAccountClient_card_fieldsExchange_vehiclePayment = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment") llAccountClient_card_fieldsExchange_vehicleRenewal = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal") llAccountClient_card_fieldsExchange_vehicleSold_by = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by") llAccountClient_card_fieldsExchange_vehicleBodyType = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType") llAccountClient_card_fieldsExchange_vehicleCategory = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category") llAccountClient_card_fieldsExchange_vehicleModality = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality") llAccountClient_card_fieldsExchange_vehicleResidual = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual") llAccountClient_card_fieldsExchange_vehicleSleeping = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping") llAccountClient_card_fieldsExchange_vehicleWarranty = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty") llAccountClient_card_fieldsExchange_vehicleCondition = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition") llAccountClient_card_fieldsExchange_vehicleFrequency = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency") llAccountClient_card_fieldsExchange_vehicleIntention = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention") llAccountClient_card_fieldsExchange_vehicleRefinance = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance") llAccountClient_card_fieldsExchange_vehicleRequested = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested") llAccountClient_card_fieldsExchange_vehicleSold_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date") llAccountClient_card_fieldsExchange_vehicleCategory_rv = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv") llAccountClient_card_fieldsExchange_vehicleInstitution = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution") llAccountClient_card_fieldsExchange_vehicleInitial_cash = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash") llAccountClient_card_fieldsExchange_vehicleOffer_number = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number") llAccountClient_card_fieldsExchange_vehicleTransmission = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission") llAccountClient_card_fieldsExchange_vehicleDrivingWheels = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels") llAccountClient_card_fieldsExchange_vehicleColor_exterior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior") llAccountClient_card_fieldsExchange_vehicleColor_interior = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior") llAccountClient_card_fieldsExchange_vehicleAllowed_mileage = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage") llAccountClient_card_fieldsExchange_vehicleSecurity_deposit = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit") llAccountClient_card_fieldsExchange_vehicleEnd_contract_date = loJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date") llAccountClient_number = loJsonResponse.BoolOf("data[i].account.client_number") llAccountConfirmation_appt = loJsonResponse.BoolOf("data[i].account.confirmation_appt") llAccountCredit = loJsonResponse.BoolOf("data[i].account.credit") llAccountCsi = loJsonResponse.BoolOf("data[i].account.csi") llAccountCsi_used = loJsonResponse.BoolOf("data[i].account.csi_used") lcAccountDefault_deliveryman_user_id = loJsonResponse.StringOf("data[i].account.default_deliveryman_user_id") llAccountDelivered_by = loJsonResponse.BoolOf("data[i].account.delivered_by") llAccountDisable_communication_audio = loJsonResponse.BoolOf("data[i].account.disable_communication_audio") llAccountDuplicates = loJsonResponse.BoolOf("data[i].account.duplicates") llAccountGuest_action = loJsonResponse.BoolOf("data[i].account.guest_action") llAccountEmail_client = loJsonResponse.BoolOf("data[i].account.email_client") llAccountIn_turn = loJsonResponse.BoolOf("data[i].account.in_turn") llAccountIn_turn_director_management = loJsonResponse.BoolOf("data[i].account.in_turn_director_management") llAccountLeads_other_division = loJsonResponse.BoolOf("data[i].account.leads_other_division") lnAccountLeadxpress_optionPriority = loJsonResponse.IntOf("data[i].account.leadxpress_option.priority") lnAccountLeadxpress_optionReminderFrequency = loJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency") lnAccountLeadxpress_optionReminderRecurrence = loJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence") llAccountLeadxpress_optionScheduleAccount = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account") llAccountLeadxpress_optionScheduleAdvisor = loJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor") llAccountLimited_audio_access = loJsonResponse.BoolOf("data[i].account.limited_audio_access") lcAccountLogo = loJsonResponse.StringOf("data[i].account.logo") lcAccountLogo_en = loJsonResponse.StringOf("data[i].account.logo_en") llAccountMandatory_coordinate = loJsonResponse.BoolOf("data[i].account.mandatory_coordinate") llAccountManually_status = loJsonResponse.BoolOf("data[i].account.manually_status") lcAccountMerge_rule = loJsonResponse.StringOf("data[i].account.merge_rule") lnAccountMonth_start_day = loJsonResponse.IntOf("data[i].account.month_start_day") lcAccountName = loJsonResponse.StringOf("data[i].account.name") llAccountNiotext = loJsonResponse.BoolOf("data[i].account.niotext") llAccountNiotext_phone = loJsonResponse.BoolOf("data[i].account.niotext_phone") lcAccountPhone = loJsonResponse.StringOf("data[i].account.phone") llAccountPower_sport = loJsonResponse.BoolOf("data[i].account.power_sport") llAccountProcess = loJsonResponse.BoolOf("data[i].account.process") llAccountRecreative_special = loJsonResponse.BoolOf("data[i].account.recreative_special") llAccountResult_date_validation = loJsonResponse.BoolOf("data[i].account.result_date_validation") llAccountSale_accessories = loJsonResponse.BoolOf("data[i].account.sale_accessories") llAccountSale_by_phone = loJsonResponse.BoolOf("data[i].account.sale_by_phone") llAccountSale_date_month = loJsonResponse.BoolOf("data[i].account.sale_date_month") llAccountSale_table_optionsAccessory_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column") llAccountSale_table_optionsCommercial_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column") llAccountSale_table_optionsDivision_grouped_total_column = loJsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column") llAccountSale_validation = loJsonResponse.BoolOf("data[i].account.sale_validation") llAccountScan = loJsonResponse.BoolOf("data[i].account.scan") llAccountStock_required_for_sale = loJsonResponse.BoolOf("data[i].account.stock_required_for_sale") llAccountTake_over_director = loJsonResponse.BoolOf("data[i].account.take_over_director") llAccountTrade_report = loJsonResponse.BoolOf("data[i].account.trade_report") llAccountUnrestricted_assignment = loJsonResponse.BoolOf("data[i].account.unrestricted_assignment") llAccountUnsubscribe = loJsonResponse.BoolOf("data[i].account.unsubscribe") llAccountUntreated_lead = loJsonResponse.BoolOf("data[i].account.untreated_lead") llAccountVehicle_model_text = loJsonResponse.BoolOf("data[i].account.vehicle_model_text") llAccountVehicle_text = loJsonResponse.BoolOf("data[i].account.vehicle_text") llAccountVerified_sale = loJsonResponse.BoolOf("data[i].account.verified_sale") llAccountVin_decoder = loJsonResponse.BoolOf("data[i].account.vin_decoder") lcAccountWaiting_sale_date = loJsonResponse.StringOf("data[i].account.waiting_sale_date") llAccountWaiting_sale_option = loJsonResponse.BoolOf("data[i].account.waiting_sale_option") lcAdvisor = loJsonResponse.StringOf("data[i].advisor") j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].emails") do while j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].emails[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].emails[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].emails[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].emails[j].lead_id") lcAddress = loJsonResponse.StringOf("data[i].emails[j].address") lcV_type = loJsonResponse.StringOf("data[i].emails[j].type") llValid = loJsonResponse.BoolOf("data[i].emails[j].valid") j = j + 1 enddo j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].phones") do while j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].phones[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].phones[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].phones[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].phones[j].lead_id") lcExtension = loJsonResponse.StringOf("data[i].phones[j].extension") lcNumber = loJsonResponse.StringOf("data[i].phones[j].number") lcV_type = loJsonResponse.StringOf("data[i].phones[j].type") llValid = loJsonResponse.BoolOf("data[i].phones[j].valid") llValidated = loJsonResponse.BoolOf("data[i].phones[j].validated") llMobile = loJsonResponse.BoolOf("data[i].phones[j].mobile") j = j + 1 enddo j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].vehicles") do while j < lnCount_j loJsonResponse.J = j lnId = loJsonResponse.IntOf("data[i].vehicles[j].id") lcCreated_at = loJsonResponse.StringOf("data[i].vehicles[j].created_at") lcUpdated_at = loJsonResponse.StringOf("data[i].vehicles[j].updated_at") lnLead_id = loJsonResponse.IntOf("data[i].vehicles[j].lead_id") lcAccessories = loJsonResponse.StringOf("data[i].vehicles[j].accessories") lcAllowed_odometer = loJsonResponse.StringOf("data[i].vehicles[j].allowed_odometer") lnBalance = loJsonResponse.IntOf("data[i].vehicles[j].balance") lcBudget_max = loJsonResponse.StringOf("data[i].vehicles[j].budget_max") lcBudget_min = loJsonResponse.StringOf("data[i].vehicles[j].budget_min") lcCash_down = loJsonResponse.StringOf("data[i].vehicles[j].cash_down") lcCategory = loJsonResponse.StringOf("data[i].vehicles[j].category") lcCategory_rv = loJsonResponse.StringOf("data[i].vehicles[j].category_rv") lcClient_number = loJsonResponse.StringOf("data[i].vehicles[j].client_number") lcColor_exterior = loJsonResponse.StringOf("data[i].vehicles[j].color_exterior") lcColor_interior = loJsonResponse.StringOf("data[i].vehicles[j].color_interior") lcComment = loJsonResponse.StringOf("data[i].vehicles[j].comment") lcCondition = loJsonResponse.StringOf("data[i].vehicles[j].condition") lcEnd_contract_date = loJsonResponse.StringOf("data[i].vehicles[j].end_contract_date") lcEnd_warranty_date = loJsonResponse.StringOf("data[i].vehicles[j].end_warranty_date") lcEngine = loJsonResponse.StringOf("data[i].vehicles[j].engine") lcExtended_warranty = loJsonResponse.StringOf("data[i].vehicles[j].extended_warranty") lcFuel = loJsonResponse.StringOf("data[i].vehicles[j].fuel") lcLength_max = loJsonResponse.StringOf("data[i].vehicles[j].length_max") lcLength_min = loJsonResponse.StringOf("data[i].vehicles[j].length_min") lcLicense_plate = loJsonResponse.StringOf("data[i].vehicles[j].license_plate") lcMake = loJsonResponse.StringOf("data[i].vehicles[j].make") lcModality = loJsonResponse.StringOf("data[i].vehicles[j].modality") lcModel = loJsonResponse.StringOf("data[i].vehicles[j].model") lcOdometer = loJsonResponse.StringOf("data[i].vehicles[j].odometer") lcOffer_number = loJsonResponse.StringOf("data[i].vehicles[j].offer_number") lcV_option = loJsonResponse.StringOf("data[i].vehicles[j].option") lcOrder_number = loJsonResponse.StringOf("data[i].vehicles[j].order_number") lcPayment = loJsonResponse.StringOf("data[i].vehicles[j].payment") lcPayment_frequency = loJsonResponse.StringOf("data[i].vehicles[j].payment_frequency") lcPreparation = loJsonResponse.StringOf("data[i].vehicles[j].preparation") lcPrice = loJsonResponse.StringOf("data[i].vehicles[j].price") lcProfit = loJsonResponse.StringOf("data[i].vehicles[j].profit") lcPurchase_date = loJsonResponse.StringOf("data[i].vehicles[j].purchase_date") lcRate = loJsonResponse.StringOf("data[i].vehicles[j].rate") lcRecall = loJsonResponse.StringOf("data[i].vehicles[j].recall") lcRecorded_date = loJsonResponse.StringOf("data[i].vehicles[j].recorded_date") lcResidual = loJsonResponse.StringOf("data[i].vehicles[j].residual") lcSecurity_deposit = loJsonResponse.StringOf("data[i].vehicles[j].security_deposit") lcSleeping = loJsonResponse.StringOf("data[i].vehicles[j].sleeping") llSold = loJsonResponse.BoolOf("data[i].vehicles[j].sold") lcSold_by = loJsonResponse.StringOf("data[i].vehicles[j].sold_by") lcSold_date = loJsonResponse.StringOf("data[i].vehicles[j].sold_date") lcStock = loJsonResponse.StringOf("data[i].vehicles[j].stock") lcStock_state = loJsonResponse.StringOf("data[i].vehicles[j].stock_state") lcTerm = loJsonResponse.StringOf("data[i].vehicles[j].term") llTire = loJsonResponse.BoolOf("data[i].vehicles[j].tire") lcTransmission = loJsonResponse.StringOf("data[i].vehicles[j].transmission") lcTrim = loJsonResponse.StringOf("data[i].vehicles[j].trim") lcV_type = loJsonResponse.StringOf("data[i].vehicles[j].type") lcUrl = loJsonResponse.StringOf("data[i].vehicles[j].url") lcValue = loJsonResponse.StringOf("data[i].vehicles[j].value") lcVin = loJsonResponse.StringOf("data[i].vehicles[j].vin") lcWarranty = loJsonResponse.StringOf("data[i].vehicles[j].warranty") lcWeight = loJsonResponse.StringOf("data[i].vehicles[j].weight") lcYear = loJsonResponse.StringOf("data[i].vehicles[j].year") lcYear_max = loJsonResponse.StringOf("data[i].vehicles[j].year_max") lcYear_min = loJsonResponse.StringOf("data[i].vehicles[j].year_min") j = j + 1 enddo j = 0 lnCount_j = loJsonResponse.SizeOfArray("data[i].products") do while j < lnCount_j loJsonResponse.J = j j = j + 1 enddo i = i + 1 enddo release loHttp release loJsonResponse |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.