|
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
(PowerBuilder) 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
integer li_rc oleobject loo_Http string ls_StrResp oleobject loo_JsonResponse string ls_LinksFirst string ls_LinksLast string ls_LinksPrev string ls_LinksNext integer li_MetaCurrent_page integer li_MetaFrom integer li_MetaLast_page string ls_MetaPath integer li_MetaPer_page integer li_MetaTo integer li_MetaTotal integer i integer li_Count_i integer li_Id string ls_Created_at string ls_Updated_at integer li_Account_id string ls_Address_line1 string ls_Address_line2 string ls_Appointment_date integer li_Appt_call string ls_Available_date string ls_Average_spending string ls_Be_back_date string ls_Birth_date string ls_Business string ls_Call_date string ls_City string ls_Civility string ls_Code string ls_Country string ls_Csi_date string ls_Delivered_by_id string ls_Delivered_date string ls_Delivery_date string ls_Division string ls_End_service_date string ls_First_name string ls_Gas integer li_Gender integer li_Invoiced string ls_Last_name string ls_Last_visit_date string ls_Locale string ls_Loyalty string ls_Next_visit_date string ls_Odometer_last_visit string ls_Open_work_order_date string ls_Planned_pick_up_date string ls_Postal_code string ls_Prepaid integer li_Prepared string ls_Presented_date string ls_Promised_date string ls_Province string ls_Rating integer li_Reached_client string ls_Refinanced_date string ls_Repair_date string ls_Repair_order string ls_Result string ls_Road_test_date string ls_Sale_date string ls_Second_contact string ls_Second_contact_civility string ls_Segment integer li_Service_cleaned string ls_Service_interval_km string ls_Service_monthly_km string ls_Service_processIntention string ls_Service_processTransport string ls_Service_processWalk_around string ls_Sex string ls_Source string ls_Status string ls_Storage string ls_Take_over_date string ls_V_type string ls_Unsubscribe_all_date string ls_Unsubscribe_call_date string ls_Unsubscribe_email_date string ls_Unsubscribe_sms_date string ls_Work_order integer li_AccountId string ls_AccountCreated_at string ls_AccountUpdated_at integer li_AccountPartner_id integer li_AccountActivity_report integer li_AccountCommercial integer li_AccountEvent integer li_AccountLeadxpress integer li_AccountLoyalty integer li_AccountPhone_up integer li_AccountRenewal integer li_AccountSale_table integer li_AccountService integer li_AccountWalk_in integer li_AccountWebboost integer li_AccountAccount_manager string ls_AccountActivation_date integer li_AccountActive integer li_AccountAssigned_lead integer li_AccountAuto_renewal integer li_AccountAuto_renewal_new integer li_AccountAuto_renewal_used integer li_AccountAutomation integer li_AccountBdc_advisor integer li_AccountCalendar_options integer li_AccountClient_card_fieldsProcessGas integer li_AccountClient_card_fieldsProcessRecorded integer li_AccountClient_card_fieldsProcessAvailable integer li_AccountClient_card_fieldsProcessDiscounted integer li_AccountClient_card_fieldsCommercialProfit integer li_AccountClient_card_fieldsCommercialExclude integer li_AccountClient_card_fieldsCommercialMeeting integer li_AccountClient_card_fieldsPerformanceDeposit integer li_AccountClient_card_fieldsPerformanceRefinanced integer li_AccountClient_card_fieldsPerformanceDealer_tour integer li_AccountClient_card_fieldsPerformanceWalk_around integer li_AccountClient_card_fieldsPerformanceQualification integer li_AccountClient_card_fieldsPerformanceTwenty_four_hour integer li_AccountClient_card_fieldsGeneral_infoBudget integer li_AccountClient_card_fieldsGeneral_infoSector integer li_AccountClient_card_fieldsGeneral_infoCustom_1 integer li_AccountClient_card_fieldsGeneral_infoCustom_2 integer li_AccountClient_card_fieldsGeneral_infoCustom_3 integer li_AccountClient_card_fieldsGeneral_infoCustom_4 integer li_AccountClient_card_fieldsGeneral_infoCustom_5 integer li_AccountClient_card_fieldsGeneral_infoCustom_6 integer li_AccountClient_card_fieldsGeneral_infoCustom_7 integer li_AccountClient_card_fieldsGeneral_infoCustom_8 integer li_AccountClient_card_fieldsGeneral_infoCustom_9 integer li_AccountClient_card_fieldsGeneral_infoCustom_10 integer li_AccountClient_card_fieldsGeneral_infoCommunication_preference integer li_AccountClient_card_fieldsWanted_vehicleVin integer li_AccountClient_card_fieldsWanted_vehicleFuel integer li_AccountClient_card_fieldsWanted_vehicleRate integer li_AccountClient_card_fieldsWanted_vehicleTerm integer li_AccountClient_card_fieldsWanted_vehicleTire integer li_AccountClient_card_fieldsWanted_vehicleYear integer li_AccountClient_card_fieldsWanted_vehicleColor integer li_AccountClient_card_fieldsWanted_vehiclePrice integer li_AccountClient_card_fieldsWanted_vehicleStock integer li_AccountClient_card_fieldsWanted_vehicleTotal integer li_AccountClient_card_fieldsWanted_vehicleBudget integer li_AccountClient_card_fieldsWanted_vehicleEngine integer li_AccountClient_card_fieldsWanted_vehicleLength integer li_AccountClient_card_fieldsWanted_vehicleProfit integer li_AccountClient_card_fieldsWanted_vehicleSuffix integer li_AccountClient_card_fieldsWanted_vehicleWeight integer li_AccountClient_card_fieldsWanted_vehicleComment integer li_AccountClient_card_fieldsWanted_vehicleMileage integer li_AccountClient_card_fieldsWanted_vehiclePayment integer li_AccountClient_card_fieldsWanted_vehicleBodyType integer li_AccountClient_card_fieldsWanted_vehicleCategory integer li_AccountClient_card_fieldsWanted_vehicleModality integer li_AccountClient_card_fieldsWanted_vehicleResidual integer li_AccountClient_card_fieldsWanted_vehicleSleeping integer li_AccountClient_card_fieldsWanted_vehicleWarranty integer li_AccountClient_card_fieldsWanted_vehicleFrequency integer li_AccountClient_card_fieldsWanted_vehicleAccessories integer li_AccountClient_card_fieldsWanted_vehicleCategory_rv integer li_AccountClient_card_fieldsWanted_vehiclePreparation integer li_AccountClient_card_fieldsWanted_vehicleInitial_cash integer li_AccountClient_card_fieldsWanted_vehicleOffer_number integer li_AccountClient_card_fieldsWanted_vehicleOrder_number integer li_AccountClient_card_fieldsWanted_vehicleTransmission integer li_AccountClient_card_fieldsWanted_vehicleDocumentation integer li_AccountClient_card_fieldsWanted_vehicleDrivingWheels integer li_AccountClient_card_fieldsWanted_vehicleColor_exterior integer li_AccountClient_card_fieldsWanted_vehicleColor_interior integer li_AccountClient_card_fieldsWanted_vehicleAllowed_mileage integer li_AccountClient_card_fieldsWanted_vehicleSecurity_deposit integer li_AccountClient_card_fieldsWanted_vehicleEnd_contract_date integer li_AccountClient_card_fieldsExchange_vehicleVin integer li_AccountClient_card_fieldsExchange_vehicleFuel integer li_AccountClient_card_fieldsExchange_vehicleLink integer li_AccountClient_card_fieldsExchange_vehicleRate integer li_AccountClient_card_fieldsExchange_vehicleTerm integer li_AccountClient_card_fieldsExchange_vehicleYear integer li_AccountClient_card_fieldsExchange_vehicleColor integer li_AccountClient_card_fieldsExchange_vehiclePrice integer li_AccountClient_card_fieldsExchange_vehicleStock integer li_AccountClient_card_fieldsExchange_vehicleValue integer li_AccountClient_card_fieldsExchange_vehicleBudget integer li_AccountClient_card_fieldsExchange_vehicleEngine integer li_AccountClient_card_fieldsExchange_vehicleLength integer li_AccountClient_card_fieldsExchange_vehicleProfit integer li_AccountClient_card_fieldsExchange_vehicleSuffix integer li_AccountClient_card_fieldsExchange_vehicleWeight integer li_AccountClient_card_fieldsExchange_vehicleBalance integer li_AccountClient_card_fieldsExchange_vehicleComment integer li_AccountClient_card_fieldsExchange_vehicleMileage integer li_AccountClient_card_fieldsExchange_vehiclePayment integer li_AccountClient_card_fieldsExchange_vehicleRenewal integer li_AccountClient_card_fieldsExchange_vehicleSold_by integer li_AccountClient_card_fieldsExchange_vehicleBodyType integer li_AccountClient_card_fieldsExchange_vehicleCategory integer li_AccountClient_card_fieldsExchange_vehicleModality integer li_AccountClient_card_fieldsExchange_vehicleResidual integer li_AccountClient_card_fieldsExchange_vehicleSleeping integer li_AccountClient_card_fieldsExchange_vehicleWarranty integer li_AccountClient_card_fieldsExchange_vehicleCondition integer li_AccountClient_card_fieldsExchange_vehicleFrequency integer li_AccountClient_card_fieldsExchange_vehicleIntention integer li_AccountClient_card_fieldsExchange_vehicleRefinance integer li_AccountClient_card_fieldsExchange_vehicleRequested integer li_AccountClient_card_fieldsExchange_vehicleSold_date integer li_AccountClient_card_fieldsExchange_vehicleCategory_rv integer li_AccountClient_card_fieldsExchange_vehicleInstitution integer li_AccountClient_card_fieldsExchange_vehicleInitial_cash integer li_AccountClient_card_fieldsExchange_vehicleOffer_number integer li_AccountClient_card_fieldsExchange_vehicleTransmission integer li_AccountClient_card_fieldsExchange_vehicleDrivingWheels integer li_AccountClient_card_fieldsExchange_vehicleColor_exterior integer li_AccountClient_card_fieldsExchange_vehicleColor_interior integer li_AccountClient_card_fieldsExchange_vehicleAllowed_mileage integer li_AccountClient_card_fieldsExchange_vehicleSecurity_deposit integer li_AccountClient_card_fieldsExchange_vehicleEnd_contract_date integer li_AccountClient_number integer li_AccountConfirmation_appt integer li_AccountCredit integer li_AccountCsi integer li_AccountCsi_used string ls_AccountDefault_deliveryman_user_id integer li_AccountDelivered_by integer li_AccountDisable_communication_audio integer li_AccountDuplicates integer li_AccountGuest_action integer li_AccountEmail_client integer li_AccountIn_turn integer li_AccountIn_turn_director_management integer li_AccountLeads_other_division integer li_AccountLeadxpress_optionPriority integer li_AccountLeadxpress_optionReminderFrequency integer li_AccountLeadxpress_optionReminderRecurrence integer li_AccountLeadxpress_optionScheduleAccount integer li_AccountLeadxpress_optionScheduleAdvisor integer li_AccountLimited_audio_access string ls_AccountLogo string ls_AccountLogo_en integer li_AccountMandatory_coordinate integer li_AccountManually_status string ls_AccountMerge_rule integer li_AccountMonth_start_day string ls_AccountName integer li_AccountNiotext integer li_AccountNiotext_phone string ls_AccountPhone integer li_AccountPower_sport integer li_AccountProcess integer li_AccountRecreative_special integer li_AccountResult_date_validation integer li_AccountSale_accessories integer li_AccountSale_by_phone integer li_AccountSale_date_month integer li_AccountSale_table_optionsAccessory_column integer li_AccountSale_table_optionsCommercial_column integer li_AccountSale_table_optionsDivision_grouped_total_column integer li_AccountSale_validation integer li_AccountScan integer li_AccountStock_required_for_sale integer li_AccountTake_over_director integer li_AccountTrade_report integer li_AccountUnrestricted_assignment integer li_AccountUnsubscribe integer li_AccountUntreated_lead integer li_AccountVehicle_model_text integer li_AccountVehicle_text integer li_AccountVerified_sale integer li_AccountVin_decoder string ls_AccountWaiting_sale_date integer li_AccountWaiting_sale_option string ls_Advisor integer j integer li_Count_j integer li_Lead_id string ls_Address integer li_Valid string ls_Extension string ls_Number integer li_Validated integer li_Mobile string ls_Accessories string ls_Allowed_odometer integer li_Balance string ls_Budget_max string ls_Budget_min string ls_Cash_down string ls_Category string ls_Category_rv string ls_Client_number string ls_Color_exterior string ls_Color_interior string ls_Comment string ls_Condition string ls_End_contract_date string ls_End_warranty_date string ls_Engine string ls_Extended_warranty string ls_Fuel string ls_Length_max string ls_Length_min string ls_License_plate string ls_Make string ls_Modality string ls_Model string ls_Odometer string ls_Offer_number string ls_V_option string ls_Order_number string ls_Payment string ls_Payment_frequency string ls_Preparation string ls_Price string ls_Profit string ls_Purchase_date string ls_Rate string ls_Recall string ls_Recorded_date string ls_Residual string ls_Security_deposit string ls_Sleeping integer li_Sold string ls_Sold_by string ls_Sold_date string ls_Stock string ls_Stock_state string ls_Term integer li_Tire string ls_Transmission string ls_Trim string ls_Url string ls_Value string ls_Vin string ls_Warranty string ls_Weight string ls_Year string ls_Year_max string ls_Year_min // This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. loo_Http = create oleobject // Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 li_rc = loo_Http.ConnectToNewObject("Chilkat.Http") if li_rc < 0 then destroy loo_Http MessageBox("Error","Connecting to COM object failed") return end if loo_Http.AuthToken = "ACCESS_TOKEN" loo_Http.Accept = "application/json" ls_StrResp = loo_Http.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe") if loo_Http.LastMethodSuccess <> 1 then Write-Debug loo_Http.LastErrorText destroy loo_Http return end if Write-Debug "Response Status Code: " + string(loo_Http.LastStatus) loo_JsonResponse = create oleobject // Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 li_rc = loo_JsonResponse.ConnectToNewObject("Chilkat.JsonObject") loo_JsonResponse.Load(ls_StrResp) loo_JsonResponse.EmitCompact = 0 Write-Debug loo_JsonResponse.Emit() if loo_Http.LastStatus <> 200 then Write-Debug "Failed." destroy loo_Http destroy loo_JsonResponse return end if // 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 // } // } ls_LinksFirst = loo_JsonResponse.StringOf("links.first") ls_LinksLast = loo_JsonResponse.StringOf("links.last") ls_LinksPrev = loo_JsonResponse.StringOf("links.prev") ls_LinksNext = loo_JsonResponse.StringOf("links.next") li_MetaCurrent_page = loo_JsonResponse.IntOf("meta.current_page") li_MetaFrom = loo_JsonResponse.IntOf("meta.from") li_MetaLast_page = loo_JsonResponse.IntOf("meta.last_page") ls_MetaPath = loo_JsonResponse.StringOf("meta.path") li_MetaPer_page = loo_JsonResponse.IntOf("meta.per_page") li_MetaTo = loo_JsonResponse.IntOf("meta.to") li_MetaTotal = loo_JsonResponse.IntOf("meta.total") i = 0 li_Count_i = loo_JsonResponse.SizeOfArray("data") do while i < li_Count_i loo_JsonResponse.I = i li_Id = loo_JsonResponse.IntOf("data[i].id") ls_Created_at = loo_JsonResponse.StringOf("data[i].created_at") ls_Updated_at = loo_JsonResponse.StringOf("data[i].updated_at") li_Account_id = loo_JsonResponse.IntOf("data[i].account_id") ls_Address_line1 = loo_JsonResponse.StringOf("data[i].address_line1") ls_Address_line2 = loo_JsonResponse.StringOf("data[i].address_line2") ls_Appointment_date = loo_JsonResponse.StringOf("data[i].appointment_date") li_Appt_call = loo_JsonResponse.BoolOf("data[i].appt_call") ls_Available_date = loo_JsonResponse.StringOf("data[i].available_date") ls_Average_spending = loo_JsonResponse.StringOf("data[i].average_spending") ls_Be_back_date = loo_JsonResponse.StringOf("data[i].be_back_date") ls_Birth_date = loo_JsonResponse.StringOf("data[i].birth_date") ls_Business = loo_JsonResponse.StringOf("data[i].business") ls_Call_date = loo_JsonResponse.StringOf("data[i].call_date") ls_City = loo_JsonResponse.StringOf("data[i].city") ls_Civility = loo_JsonResponse.StringOf("data[i].civility") ls_Code = loo_JsonResponse.StringOf("data[i].code") ls_Country = loo_JsonResponse.StringOf("data[i].country") ls_Csi_date = loo_JsonResponse.StringOf("data[i].csi_date") ls_Delivered_by_id = loo_JsonResponse.StringOf("data[i].delivered_by_id") ls_Delivered_date = loo_JsonResponse.StringOf("data[i].delivered_date") ls_Delivery_date = loo_JsonResponse.StringOf("data[i].delivery_date") ls_Division = loo_JsonResponse.StringOf("data[i].division") ls_End_service_date = loo_JsonResponse.StringOf("data[i].end_service_date") ls_First_name = loo_JsonResponse.StringOf("data[i].first_name") ls_Gas = loo_JsonResponse.StringOf("data[i].gas") li_Gender = loo_JsonResponse.IntOf("data[i].gender") li_Invoiced = loo_JsonResponse.BoolOf("data[i].invoiced") ls_Last_name = loo_JsonResponse.StringOf("data[i].last_name") ls_Last_visit_date = loo_JsonResponse.StringOf("data[i].last_visit_date") ls_Locale = loo_JsonResponse.StringOf("data[i].locale") ls_Loyalty = loo_JsonResponse.StringOf("data[i].loyalty") ls_Next_visit_date = loo_JsonResponse.StringOf("data[i].next_visit_date") ls_Odometer_last_visit = loo_JsonResponse.StringOf("data[i].odometer_last_visit") ls_Open_work_order_date = loo_JsonResponse.StringOf("data[i].open_work_order_date") ls_Planned_pick_up_date = loo_JsonResponse.StringOf("data[i].planned_pick_up_date") ls_Postal_code = loo_JsonResponse.StringOf("data[i].postal_code") ls_Prepaid = loo_JsonResponse.StringOf("data[i].prepaid") li_Prepared = loo_JsonResponse.BoolOf("data[i].prepared") ls_Presented_date = loo_JsonResponse.StringOf("data[i].presented_date") ls_Promised_date = loo_JsonResponse.StringOf("data[i].promised_date") ls_Province = loo_JsonResponse.StringOf("data[i].province") ls_Rating = loo_JsonResponse.StringOf("data[i].rating") li_Reached_client = loo_JsonResponse.BoolOf("data[i].reached_client") ls_Refinanced_date = loo_JsonResponse.StringOf("data[i].refinanced_date") ls_Repair_date = loo_JsonResponse.StringOf("data[i].repair_date") ls_Repair_order = loo_JsonResponse.StringOf("data[i].repair_order") ls_Result = loo_JsonResponse.StringOf("data[i].result") ls_Road_test_date = loo_JsonResponse.StringOf("data[i].road_test_date") ls_Sale_date = loo_JsonResponse.StringOf("data[i].sale_date") ls_Second_contact = loo_JsonResponse.StringOf("data[i].second_contact") ls_Second_contact_civility = loo_JsonResponse.StringOf("data[i].second_contact_civility") ls_Segment = loo_JsonResponse.StringOf("data[i].segment") li_Service_cleaned = loo_JsonResponse.BoolOf("data[i].service_cleaned") ls_Service_interval_km = loo_JsonResponse.StringOf("data[i].service_interval_km") ls_Service_monthly_km = loo_JsonResponse.StringOf("data[i].service_monthly_km") ls_Service_processIntention = loo_JsonResponse.StringOf("data[i].service_process.intention") ls_Service_processTransport = loo_JsonResponse.StringOf("data[i].service_process.transport") ls_Service_processWalk_around = loo_JsonResponse.StringOf("data[i].service_process.walk_around") ls_Sex = loo_JsonResponse.StringOf("data[i].sex") ls_Source = loo_JsonResponse.StringOf("data[i].source") ls_Status = loo_JsonResponse.StringOf("data[i].status") ls_Storage = loo_JsonResponse.StringOf("data[i].storage") ls_Take_over_date = loo_JsonResponse.StringOf("data[i].take_over_date") ls_V_type = loo_JsonResponse.StringOf("data[i].type") ls_Unsubscribe_all_date = loo_JsonResponse.StringOf("data[i].unsubscribe_all_date") ls_Unsubscribe_call_date = loo_JsonResponse.StringOf("data[i].unsubscribe_call_date") ls_Unsubscribe_email_date = loo_JsonResponse.StringOf("data[i].unsubscribe_email_date") ls_Unsubscribe_sms_date = loo_JsonResponse.StringOf("data[i].unsubscribe_sms_date") ls_Work_order = loo_JsonResponse.StringOf("data[i].work_order") li_AccountId = loo_JsonResponse.IntOf("data[i].account.id") ls_AccountCreated_at = loo_JsonResponse.StringOf("data[i].account.created_at") ls_AccountUpdated_at = loo_JsonResponse.StringOf("data[i].account.updated_at") li_AccountPartner_id = loo_JsonResponse.IntOf("data[i].account.partner_id") li_AccountActivity_report = loo_JsonResponse.BoolOf("data[i].account.activity_report") li_AccountCommercial = loo_JsonResponse.BoolOf("data[i].account.commercial") li_AccountEvent = loo_JsonResponse.BoolOf("data[i].account.event") li_AccountLeadxpress = loo_JsonResponse.BoolOf("data[i].account.leadxpress") li_AccountLoyalty = loo_JsonResponse.BoolOf("data[i].account.loyalty") li_AccountPhone_up = loo_JsonResponse.BoolOf("data[i].account.phone_up") li_AccountRenewal = loo_JsonResponse.BoolOf("data[i].account.renewal") li_AccountSale_table = loo_JsonResponse.BoolOf("data[i].account.sale_table") li_AccountService = loo_JsonResponse.BoolOf("data[i].account.service") li_AccountWalk_in = loo_JsonResponse.BoolOf("data[i].account.walk_in") li_AccountWebboost = loo_JsonResponse.BoolOf("data[i].account.webboost") li_AccountAccount_manager = loo_JsonResponse.BoolOf("data[i].account.account_manager") ls_AccountActivation_date = loo_JsonResponse.StringOf("data[i].account.activation_date") li_AccountActive = loo_JsonResponse.BoolOf("data[i].account.active") li_AccountAssigned_lead = loo_JsonResponse.BoolOf("data[i].account.assigned_lead") li_AccountAuto_renewal = loo_JsonResponse.BoolOf("data[i].account.auto_renewal") li_AccountAuto_renewal_new = loo_JsonResponse.BoolOf("data[i].account.auto_renewal_new") li_AccountAuto_renewal_used = loo_JsonResponse.BoolOf("data[i].account.auto_renewal_used") li_AccountAutomation = loo_JsonResponse.BoolOf("data[i].account.automation") li_AccountBdc_advisor = loo_JsonResponse.BoolOf("data[i].account.bdc_advisor") li_AccountCalendar_options = loo_JsonResponse.BoolOf("data[i].account.calendar_options") li_AccountClient_card_fieldsProcessGas = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.gas") li_AccountClient_card_fieldsProcessRecorded = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded") li_AccountClient_card_fieldsProcessAvailable = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.available") li_AccountClient_card_fieldsProcessDiscounted = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted") li_AccountClient_card_fieldsCommercialProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit") li_AccountClient_card_fieldsCommercialExclude = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude") li_AccountClient_card_fieldsCommercialMeeting = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting") li_AccountClient_card_fieldsPerformanceDeposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit") li_AccountClient_card_fieldsPerformanceRefinanced = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced") li_AccountClient_card_fieldsPerformanceDealer_tour = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour") li_AccountClient_card_fieldsPerformanceWalk_around = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around") li_AccountClient_card_fieldsPerformanceQualification = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification") li_AccountClient_card_fieldsPerformanceTwenty_four_hour = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour") li_AccountClient_card_fieldsGeneral_infoBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget") li_AccountClient_card_fieldsGeneral_infoSector = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector") li_AccountClient_card_fieldsGeneral_infoCustom_1 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1") li_AccountClient_card_fieldsGeneral_infoCustom_2 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2") li_AccountClient_card_fieldsGeneral_infoCustom_3 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3") li_AccountClient_card_fieldsGeneral_infoCustom_4 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4") li_AccountClient_card_fieldsGeneral_infoCustom_5 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5") li_AccountClient_card_fieldsGeneral_infoCustom_6 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6") li_AccountClient_card_fieldsGeneral_infoCustom_7 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7") li_AccountClient_card_fieldsGeneral_infoCustom_8 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8") li_AccountClient_card_fieldsGeneral_infoCustom_9 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9") li_AccountClient_card_fieldsGeneral_infoCustom_10 = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10") li_AccountClient_card_fieldsGeneral_infoCommunication_preference = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference") li_AccountClient_card_fieldsWanted_vehicleVin = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin") li_AccountClient_card_fieldsWanted_vehicleFuel = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel") li_AccountClient_card_fieldsWanted_vehicleRate = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate") li_AccountClient_card_fieldsWanted_vehicleTerm = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term") li_AccountClient_card_fieldsWanted_vehicleTire = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire") li_AccountClient_card_fieldsWanted_vehicleYear = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year") li_AccountClient_card_fieldsWanted_vehicleColor = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color") li_AccountClient_card_fieldsWanted_vehiclePrice = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price") li_AccountClient_card_fieldsWanted_vehicleStock = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock") li_AccountClient_card_fieldsWanted_vehicleTotal = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total") li_AccountClient_card_fieldsWanted_vehicleBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget") li_AccountClient_card_fieldsWanted_vehicleEngine = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine") li_AccountClient_card_fieldsWanted_vehicleLength = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length") li_AccountClient_card_fieldsWanted_vehicleProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit") li_AccountClient_card_fieldsWanted_vehicleSuffix = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix") li_AccountClient_card_fieldsWanted_vehicleWeight = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight") li_AccountClient_card_fieldsWanted_vehicleComment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment") li_AccountClient_card_fieldsWanted_vehicleMileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage") li_AccountClient_card_fieldsWanted_vehiclePayment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment") li_AccountClient_card_fieldsWanted_vehicleBodyType = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType") li_AccountClient_card_fieldsWanted_vehicleCategory = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category") li_AccountClient_card_fieldsWanted_vehicleModality = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality") li_AccountClient_card_fieldsWanted_vehicleResidual = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual") li_AccountClient_card_fieldsWanted_vehicleSleeping = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping") li_AccountClient_card_fieldsWanted_vehicleWarranty = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty") li_AccountClient_card_fieldsWanted_vehicleFrequency = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency") li_AccountClient_card_fieldsWanted_vehicleAccessories = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories") li_AccountClient_card_fieldsWanted_vehicleCategory_rv = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv") li_AccountClient_card_fieldsWanted_vehiclePreparation = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation") li_AccountClient_card_fieldsWanted_vehicleInitial_cash = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash") li_AccountClient_card_fieldsWanted_vehicleOffer_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number") li_AccountClient_card_fieldsWanted_vehicleOrder_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number") li_AccountClient_card_fieldsWanted_vehicleTransmission = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission") li_AccountClient_card_fieldsWanted_vehicleDocumentation = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation") li_AccountClient_card_fieldsWanted_vehicleDrivingWheels = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels") li_AccountClient_card_fieldsWanted_vehicleColor_exterior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior") li_AccountClient_card_fieldsWanted_vehicleColor_interior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior") li_AccountClient_card_fieldsWanted_vehicleAllowed_mileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage") li_AccountClient_card_fieldsWanted_vehicleSecurity_deposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit") li_AccountClient_card_fieldsWanted_vehicleEnd_contract_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date") li_AccountClient_card_fieldsExchange_vehicleVin = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin") li_AccountClient_card_fieldsExchange_vehicleFuel = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel") li_AccountClient_card_fieldsExchange_vehicleLink = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link") li_AccountClient_card_fieldsExchange_vehicleRate = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate") li_AccountClient_card_fieldsExchange_vehicleTerm = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term") li_AccountClient_card_fieldsExchange_vehicleYear = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year") li_AccountClient_card_fieldsExchange_vehicleColor = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color") li_AccountClient_card_fieldsExchange_vehiclePrice = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price") li_AccountClient_card_fieldsExchange_vehicleStock = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock") li_AccountClient_card_fieldsExchange_vehicleValue = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value") li_AccountClient_card_fieldsExchange_vehicleBudget = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget") li_AccountClient_card_fieldsExchange_vehicleEngine = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine") li_AccountClient_card_fieldsExchange_vehicleLength = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length") li_AccountClient_card_fieldsExchange_vehicleProfit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit") li_AccountClient_card_fieldsExchange_vehicleSuffix = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix") li_AccountClient_card_fieldsExchange_vehicleWeight = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight") li_AccountClient_card_fieldsExchange_vehicleBalance = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance") li_AccountClient_card_fieldsExchange_vehicleComment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment") li_AccountClient_card_fieldsExchange_vehicleMileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage") li_AccountClient_card_fieldsExchange_vehiclePayment = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment") li_AccountClient_card_fieldsExchange_vehicleRenewal = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal") li_AccountClient_card_fieldsExchange_vehicleSold_by = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by") li_AccountClient_card_fieldsExchange_vehicleBodyType = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType") li_AccountClient_card_fieldsExchange_vehicleCategory = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category") li_AccountClient_card_fieldsExchange_vehicleModality = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality") li_AccountClient_card_fieldsExchange_vehicleResidual = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual") li_AccountClient_card_fieldsExchange_vehicleSleeping = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping") li_AccountClient_card_fieldsExchange_vehicleWarranty = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty") li_AccountClient_card_fieldsExchange_vehicleCondition = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition") li_AccountClient_card_fieldsExchange_vehicleFrequency = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency") li_AccountClient_card_fieldsExchange_vehicleIntention = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention") li_AccountClient_card_fieldsExchange_vehicleRefinance = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance") li_AccountClient_card_fieldsExchange_vehicleRequested = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested") li_AccountClient_card_fieldsExchange_vehicleSold_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date") li_AccountClient_card_fieldsExchange_vehicleCategory_rv = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv") li_AccountClient_card_fieldsExchange_vehicleInstitution = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution") li_AccountClient_card_fieldsExchange_vehicleInitial_cash = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash") li_AccountClient_card_fieldsExchange_vehicleOffer_number = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number") li_AccountClient_card_fieldsExchange_vehicleTransmission = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission") li_AccountClient_card_fieldsExchange_vehicleDrivingWheels = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels") li_AccountClient_card_fieldsExchange_vehicleColor_exterior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior") li_AccountClient_card_fieldsExchange_vehicleColor_interior = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior") li_AccountClient_card_fieldsExchange_vehicleAllowed_mileage = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage") li_AccountClient_card_fieldsExchange_vehicleSecurity_deposit = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit") li_AccountClient_card_fieldsExchange_vehicleEnd_contract_date = loo_JsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date") li_AccountClient_number = loo_JsonResponse.BoolOf("data[i].account.client_number") li_AccountConfirmation_appt = loo_JsonResponse.BoolOf("data[i].account.confirmation_appt") li_AccountCredit = loo_JsonResponse.BoolOf("data[i].account.credit") li_AccountCsi = loo_JsonResponse.BoolOf("data[i].account.csi") li_AccountCsi_used = loo_JsonResponse.BoolOf("data[i].account.csi_used") ls_AccountDefault_deliveryman_user_id = loo_JsonResponse.StringOf("data[i].account.default_deliveryman_user_id") li_AccountDelivered_by = loo_JsonResponse.BoolOf("data[i].account.delivered_by") li_AccountDisable_communication_audio = loo_JsonResponse.BoolOf("data[i].account.disable_communication_audio") li_AccountDuplicates = loo_JsonResponse.BoolOf("data[i].account.duplicates") li_AccountGuest_action = loo_JsonResponse.BoolOf("data[i].account.guest_action") li_AccountEmail_client = loo_JsonResponse.BoolOf("data[i].account.email_client") li_AccountIn_turn = loo_JsonResponse.BoolOf("data[i].account.in_turn") li_AccountIn_turn_director_management = loo_JsonResponse.BoolOf("data[i].account.in_turn_director_management") li_AccountLeads_other_division = loo_JsonResponse.BoolOf("data[i].account.leads_other_division") li_AccountLeadxpress_optionPriority = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.priority") li_AccountLeadxpress_optionReminderFrequency = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency") li_AccountLeadxpress_optionReminderRecurrence = loo_JsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence") li_AccountLeadxpress_optionScheduleAccount = loo_JsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account") li_AccountLeadxpress_optionScheduleAdvisor = loo_JsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor") li_AccountLimited_audio_access = loo_JsonResponse.BoolOf("data[i].account.limited_audio_access") ls_AccountLogo = loo_JsonResponse.StringOf("data[i].account.logo") ls_AccountLogo_en = loo_JsonResponse.StringOf("data[i].account.logo_en") li_AccountMandatory_coordinate = loo_JsonResponse.BoolOf("data[i].account.mandatory_coordinate") li_AccountManually_status = loo_JsonResponse.BoolOf("data[i].account.manually_status") ls_AccountMerge_rule = loo_JsonResponse.StringOf("data[i].account.merge_rule") li_AccountMonth_start_day = loo_JsonResponse.IntOf("data[i].account.month_start_day") ls_AccountName = loo_JsonResponse.StringOf("data[i].account.name") li_AccountNiotext = loo_JsonResponse.BoolOf("data[i].account.niotext") li_AccountNiotext_phone = loo_JsonResponse.BoolOf("data[i].account.niotext_phone") ls_AccountPhone = loo_JsonResponse.StringOf("data[i].account.phone") li_AccountPower_sport = loo_JsonResponse.BoolOf("data[i].account.power_sport") li_AccountProcess = loo_JsonResponse.BoolOf("data[i].account.process") li_AccountRecreative_special = loo_JsonResponse.BoolOf("data[i].account.recreative_special") li_AccountResult_date_validation = loo_JsonResponse.BoolOf("data[i].account.result_date_validation") li_AccountSale_accessories = loo_JsonResponse.BoolOf("data[i].account.sale_accessories") li_AccountSale_by_phone = loo_JsonResponse.BoolOf("data[i].account.sale_by_phone") li_AccountSale_date_month = loo_JsonResponse.BoolOf("data[i].account.sale_date_month") li_AccountSale_table_optionsAccessory_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column") li_AccountSale_table_optionsCommercial_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column") li_AccountSale_table_optionsDivision_grouped_total_column = loo_JsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column") li_AccountSale_validation = loo_JsonResponse.BoolOf("data[i].account.sale_validation") li_AccountScan = loo_JsonResponse.BoolOf("data[i].account.scan") li_AccountStock_required_for_sale = loo_JsonResponse.BoolOf("data[i].account.stock_required_for_sale") li_AccountTake_over_director = loo_JsonResponse.BoolOf("data[i].account.take_over_director") li_AccountTrade_report = loo_JsonResponse.BoolOf("data[i].account.trade_report") li_AccountUnrestricted_assignment = loo_JsonResponse.BoolOf("data[i].account.unrestricted_assignment") li_AccountUnsubscribe = loo_JsonResponse.BoolOf("data[i].account.unsubscribe") li_AccountUntreated_lead = loo_JsonResponse.BoolOf("data[i].account.untreated_lead") li_AccountVehicle_model_text = loo_JsonResponse.BoolOf("data[i].account.vehicle_model_text") li_AccountVehicle_text = loo_JsonResponse.BoolOf("data[i].account.vehicle_text") li_AccountVerified_sale = loo_JsonResponse.BoolOf("data[i].account.verified_sale") li_AccountVin_decoder = loo_JsonResponse.BoolOf("data[i].account.vin_decoder") ls_AccountWaiting_sale_date = loo_JsonResponse.StringOf("data[i].account.waiting_sale_date") li_AccountWaiting_sale_option = loo_JsonResponse.BoolOf("data[i].account.waiting_sale_option") ls_Advisor = loo_JsonResponse.StringOf("data[i].advisor") j = 0 li_Count_j = loo_JsonResponse.SizeOfArray("data[i].emails") do while j < li_Count_j loo_JsonResponse.J = j li_Id = loo_JsonResponse.IntOf("data[i].emails[j].id") ls_Created_at = loo_JsonResponse.StringOf("data[i].emails[j].created_at") ls_Updated_at = loo_JsonResponse.StringOf("data[i].emails[j].updated_at") li_Lead_id = loo_JsonResponse.IntOf("data[i].emails[j].lead_id") ls_Address = loo_JsonResponse.StringOf("data[i].emails[j].address") ls_V_type = loo_JsonResponse.StringOf("data[i].emails[j].type") li_Valid = loo_JsonResponse.BoolOf("data[i].emails[j].valid") j = j + 1 loop j = 0 li_Count_j = loo_JsonResponse.SizeOfArray("data[i].phones") do while j < li_Count_j loo_JsonResponse.J = j li_Id = loo_JsonResponse.IntOf("data[i].phones[j].id") ls_Created_at = loo_JsonResponse.StringOf("data[i].phones[j].created_at") ls_Updated_at = loo_JsonResponse.StringOf("data[i].phones[j].updated_at") li_Lead_id = loo_JsonResponse.IntOf("data[i].phones[j].lead_id") ls_Extension = loo_JsonResponse.StringOf("data[i].phones[j].extension") ls_Number = loo_JsonResponse.StringOf("data[i].phones[j].number") ls_V_type = loo_JsonResponse.StringOf("data[i].phones[j].type") li_Valid = loo_JsonResponse.BoolOf("data[i].phones[j].valid") li_Validated = loo_JsonResponse.BoolOf("data[i].phones[j].validated") li_Mobile = loo_JsonResponse.BoolOf("data[i].phones[j].mobile") j = j + 1 loop j = 0 li_Count_j = loo_JsonResponse.SizeOfArray("data[i].vehicles") do while j < li_Count_j loo_JsonResponse.J = j li_Id = loo_JsonResponse.IntOf("data[i].vehicles[j].id") ls_Created_at = loo_JsonResponse.StringOf("data[i].vehicles[j].created_at") ls_Updated_at = loo_JsonResponse.StringOf("data[i].vehicles[j].updated_at") li_Lead_id = loo_JsonResponse.IntOf("data[i].vehicles[j].lead_id") ls_Accessories = loo_JsonResponse.StringOf("data[i].vehicles[j].accessories") ls_Allowed_odometer = loo_JsonResponse.StringOf("data[i].vehicles[j].allowed_odometer") li_Balance = loo_JsonResponse.IntOf("data[i].vehicles[j].balance") ls_Budget_max = loo_JsonResponse.StringOf("data[i].vehicles[j].budget_max") ls_Budget_min = loo_JsonResponse.StringOf("data[i].vehicles[j].budget_min") ls_Cash_down = loo_JsonResponse.StringOf("data[i].vehicles[j].cash_down") ls_Category = loo_JsonResponse.StringOf("data[i].vehicles[j].category") ls_Category_rv = loo_JsonResponse.StringOf("data[i].vehicles[j].category_rv") ls_Client_number = loo_JsonResponse.StringOf("data[i].vehicles[j].client_number") ls_Color_exterior = loo_JsonResponse.StringOf("data[i].vehicles[j].color_exterior") ls_Color_interior = loo_JsonResponse.StringOf("data[i].vehicles[j].color_interior") ls_Comment = loo_JsonResponse.StringOf("data[i].vehicles[j].comment") ls_Condition = loo_JsonResponse.StringOf("data[i].vehicles[j].condition") ls_End_contract_date = loo_JsonResponse.StringOf("data[i].vehicles[j].end_contract_date") ls_End_warranty_date = loo_JsonResponse.StringOf("data[i].vehicles[j].end_warranty_date") ls_Engine = loo_JsonResponse.StringOf("data[i].vehicles[j].engine") ls_Extended_warranty = loo_JsonResponse.StringOf("data[i].vehicles[j].extended_warranty") ls_Fuel = loo_JsonResponse.StringOf("data[i].vehicles[j].fuel") ls_Length_max = loo_JsonResponse.StringOf("data[i].vehicles[j].length_max") ls_Length_min = loo_JsonResponse.StringOf("data[i].vehicles[j].length_min") ls_License_plate = loo_JsonResponse.StringOf("data[i].vehicles[j].license_plate") ls_Make = loo_JsonResponse.StringOf("data[i].vehicles[j].make") ls_Modality = loo_JsonResponse.StringOf("data[i].vehicles[j].modality") ls_Model = loo_JsonResponse.StringOf("data[i].vehicles[j].model") ls_Odometer = loo_JsonResponse.StringOf("data[i].vehicles[j].odometer") ls_Offer_number = loo_JsonResponse.StringOf("data[i].vehicles[j].offer_number") ls_V_option = loo_JsonResponse.StringOf("data[i].vehicles[j].option") ls_Order_number = loo_JsonResponse.StringOf("data[i].vehicles[j].order_number") ls_Payment = loo_JsonResponse.StringOf("data[i].vehicles[j].payment") ls_Payment_frequency = loo_JsonResponse.StringOf("data[i].vehicles[j].payment_frequency") ls_Preparation = loo_JsonResponse.StringOf("data[i].vehicles[j].preparation") ls_Price = loo_JsonResponse.StringOf("data[i].vehicles[j].price") ls_Profit = loo_JsonResponse.StringOf("data[i].vehicles[j].profit") ls_Purchase_date = loo_JsonResponse.StringOf("data[i].vehicles[j].purchase_date") ls_Rate = loo_JsonResponse.StringOf("data[i].vehicles[j].rate") ls_Recall = loo_JsonResponse.StringOf("data[i].vehicles[j].recall") ls_Recorded_date = loo_JsonResponse.StringOf("data[i].vehicles[j].recorded_date") ls_Residual = loo_JsonResponse.StringOf("data[i].vehicles[j].residual") ls_Security_deposit = loo_JsonResponse.StringOf("data[i].vehicles[j].security_deposit") ls_Sleeping = loo_JsonResponse.StringOf("data[i].vehicles[j].sleeping") li_Sold = loo_JsonResponse.BoolOf("data[i].vehicles[j].sold") ls_Sold_by = loo_JsonResponse.StringOf("data[i].vehicles[j].sold_by") ls_Sold_date = loo_JsonResponse.StringOf("data[i].vehicles[j].sold_date") ls_Stock = loo_JsonResponse.StringOf("data[i].vehicles[j].stock") ls_Stock_state = loo_JsonResponse.StringOf("data[i].vehicles[j].stock_state") ls_Term = loo_JsonResponse.StringOf("data[i].vehicles[j].term") li_Tire = loo_JsonResponse.BoolOf("data[i].vehicles[j].tire") ls_Transmission = loo_JsonResponse.StringOf("data[i].vehicles[j].transmission") ls_Trim = loo_JsonResponse.StringOf("data[i].vehicles[j].trim") ls_V_type = loo_JsonResponse.StringOf("data[i].vehicles[j].type") ls_Url = loo_JsonResponse.StringOf("data[i].vehicles[j].url") ls_Value = loo_JsonResponse.StringOf("data[i].vehicles[j].value") ls_Vin = loo_JsonResponse.StringOf("data[i].vehicles[j].vin") ls_Warranty = loo_JsonResponse.StringOf("data[i].vehicles[j].warranty") ls_Weight = loo_JsonResponse.StringOf("data[i].vehicles[j].weight") ls_Year = loo_JsonResponse.StringOf("data[i].vehicles[j].year") ls_Year_max = loo_JsonResponse.StringOf("data[i].vehicles[j].year_max") ls_Year_min = loo_JsonResponse.StringOf("data[i].vehicles[j].year_min") j = j + 1 loop j = 0 li_Count_j = loo_JsonResponse.SizeOfArray("data[i].products") do while j < li_Count_j loo_JsonResponse.J = j j = j + 1 loop i = i + 1 loop destroy loo_Http destroy loo_JsonResponse |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.