|
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
(AutoIt) 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. $oHttp = ObjCreate("Chilkat.Http") $oHttp.AuthToken = "ACCESS_TOKEN" $oHttp.Accept = "application/json" Local $strResp = $oHttp.QuickGetStr("https://crm.activix.ca/api/v2/leads/search?query=Doe") If ($oHttp.LastMethodSuccess <> True) Then ConsoleWrite($oHttp.LastErrorText & @CRLF) Exit EndIf ConsoleWrite("Response Status Code: " & $oHttp.LastStatus & @CRLF) $oJsonResponse = ObjCreate("Chilkat.JsonObject") $oJsonResponse.Load($strResp) $oJsonResponse.EmitCompact = False ConsoleWrite($oJsonResponse.Emit() & @CRLF) If ($oHttp.LastStatus <> 200) Then ConsoleWrite("Failed." & @CRLF) Exit 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 ; } ; } Local $sLinksFirst Local $sLinksLast Local $sLinksPrev Local $sLinksNext Local $iMetaCurrent_page Local $iMetaFrom Local $iMetaLast_page Local $sMetaPath Local $iMetaPer_page Local $iMetaTo Local $iMetaTotal Local $i Local $iCount_i Local $id Local $sCreated_at Local $sUpdated_at Local $iAccount_id Local $sAddress_line1 Local $sAddress_line2 Local $sAppointment_date Local $bAppt_call Local $sAvailable_date Local $sAverage_spending Local $sBe_back_date Local $sBirth_date Local $sBusiness Local $sCall_date Local $sCity Local $sCivility Local $sCode Local $sCountry Local $sCsi_date Local $sDelivered_by_id Local $sDelivered_date Local $sDelivery_date Local $sDivision Local $sEnd_service_date Local $sFirst_name Local $sGas Local $iGender Local $bInvoiced Local $sLast_name Local $sLast_visit_date Local $sLocale Local $sLoyalty Local $sNext_visit_date Local $sOdometer_last_visit Local $sOpen_work_order_date Local $sPlanned_pick_up_date Local $sPostal_code Local $sPrepaid Local $bPrepared Local $sPresented_date Local $sPromised_date Local $sProvince Local $sRating Local $bReached_client Local $sRefinanced_date Local $sRepair_date Local $sRepair_order Local $sResult Local $sRoad_test_date Local $sale_date Local $second_contact Local $second_contact_civility Local $segment Local $bService_cleaned Local $service_interval_km Local $service_monthly_km Local $service_processIntention Local $service_processTransport Local $service_processWalk_around Local $sex Local $source Local $status Local $storage Local $sTake_over_date Local $sV_type Local $sUnsubscribe_all_date Local $sUnsubscribe_call_date Local $sUnsubscribe_email_date Local $sUnsubscribe_sms_date Local $sWork_order Local $iAccountId Local $sAccountCreated_at Local $sAccountUpdated_at Local $iAccountPartner_id Local $bAccountActivity_report Local $bAccountCommercial Local $bAccountEvent Local $bAccountLeadxpress Local $bAccountLoyalty Local $bAccountPhone_up Local $bAccountRenewal Local $bAccountSale_table Local $bAccountService Local $bAccountWalk_in Local $bAccountWebboost Local $bAccountAccount_manager Local $sAccountActivation_date Local $bAccountActive Local $bAccountAssigned_lead Local $bAccountAuto_renewal Local $bAccountAuto_renewal_new Local $bAccountAuto_renewal_used Local $bAccountAutomation Local $bAccountBdc_advisor Local $bAccountCalendar_options Local $bAccountClient_card_fieldsProcessGas Local $bAccountClient_card_fieldsProcessRecorded Local $bAccountClient_card_fieldsProcessAvailable Local $bAccountClient_card_fieldsProcessDiscounted Local $bAccountClient_card_fieldsCommercialProfit Local $bAccountClient_card_fieldsCommercialExclude Local $bAccountClient_card_fieldsCommercialMeeting Local $bAccountClient_card_fieldsPerformanceDeposit Local $bAccountClient_card_fieldsPerformanceRefinanced Local $bAccountClient_card_fieldsPerformanceDealer_tour Local $bAccountClient_card_fieldsPerformanceWalk_around Local $bAccountClient_card_fieldsPerformanceQualification Local $bAccountClient_card_fieldsPerformanceTwenty_four_hour Local $bAccountClient_card_fieldsGeneral_infoBudget Local $bAccountClient_card_fieldsGeneral_infoSector Local $bAccountClient_card_fieldsGeneral_infoCustom_1 Local $bAccountClient_card_fieldsGeneral_infoCustom_2 Local $bAccountClient_card_fieldsGeneral_infoCustom_3 Local $bAccountClient_card_fieldsGeneral_infoCustom_4 Local $bAccountClient_card_fieldsGeneral_infoCustom_5 Local $bAccountClient_card_fieldsGeneral_infoCustom_6 Local $bAccountClient_card_fieldsGeneral_infoCustom_7 Local $bAccountClient_card_fieldsGeneral_infoCustom_8 Local $bAccountClient_card_fieldsGeneral_infoCustom_9 Local $bAccountClient_card_fieldsGeneral_infoCustom_10 Local $bAccountClient_card_fieldsGeneral_infoCommunication_preference Local $bAccountClient_card_fieldsWanted_vehicleVin Local $bAccountClient_card_fieldsWanted_vehicleFuel Local $bAccountClient_card_fieldsWanted_vehicleRate Local $bAccountClient_card_fieldsWanted_vehicleTerm Local $bAccountClient_card_fieldsWanted_vehicleTire Local $bAccountClient_card_fieldsWanted_vehicleYear Local $bAccountClient_card_fieldsWanted_vehicleColor Local $bAccountClient_card_fieldsWanted_vehiclePrice Local $bAccountClient_card_fieldsWanted_vehicleStock Local $bAccountClient_card_fieldsWanted_vehicleTotal Local $bAccountClient_card_fieldsWanted_vehicleBudget Local $bAccountClient_card_fieldsWanted_vehicleEngine Local $bAccountClient_card_fieldsWanted_vehicleLength Local $bAccountClient_card_fieldsWanted_vehicleProfit Local $bAccountClient_card_fieldsWanted_vehicleSuffix Local $bAccountClient_card_fieldsWanted_vehicleWeight Local $bAccountClient_card_fieldsWanted_vehicleComment Local $bAccountClient_card_fieldsWanted_vehicleMileage Local $bAccountClient_card_fieldsWanted_vehiclePayment Local $bAccountClient_card_fieldsWanted_vehicleBodyType Local $bAccountClient_card_fieldsWanted_vehicleCategory Local $bAccountClient_card_fieldsWanted_vehicleModality Local $bAccountClient_card_fieldsWanted_vehicleResidual Local $bAccountClient_card_fieldsWanted_vehicleSleeping Local $bAccountClient_card_fieldsWanted_vehicleWarranty Local $bAccountClient_card_fieldsWanted_vehicleFrequency Local $bAccountClient_card_fieldsWanted_vehicleAccessories Local $bAccountClient_card_fieldsWanted_vehicleCategory_rv Local $bAccountClient_card_fieldsWanted_vehiclePreparation Local $bAccountClient_card_fieldsWanted_vehicleInitial_cash Local $bAccountClient_card_fieldsWanted_vehicleOffer_number Local $bAccountClient_card_fieldsWanted_vehicleOrder_number Local $bAccountClient_card_fieldsWanted_vehicleTransmission Local $bAccountClient_card_fieldsWanted_vehicleDocumentation Local $bAccountClient_card_fieldsWanted_vehicleDrivingWheels Local $bAccountClient_card_fieldsWanted_vehicleColor_exterior Local $bAccountClient_card_fieldsWanted_vehicleColor_interior Local $bAccountClient_card_fieldsWanted_vehicleAllowed_mileage Local $bAccountClient_card_fieldsWanted_vehicleSecurity_deposit Local $bAccountClient_card_fieldsWanted_vehicleEnd_contract_date Local $bAccountClient_card_fieldsExchange_vehicleVin Local $bAccountClient_card_fieldsExchange_vehicleFuel Local $bAccountClient_card_fieldsExchange_vehicleLink Local $bAccountClient_card_fieldsExchange_vehicleRate Local $bAccountClient_card_fieldsExchange_vehicleTerm Local $bAccountClient_card_fieldsExchange_vehicleYear Local $bAccountClient_card_fieldsExchange_vehicleColor Local $bAccountClient_card_fieldsExchange_vehiclePrice Local $bAccountClient_card_fieldsExchange_vehicleStock Local $bAccountClient_card_fieldsExchange_vehicleValue Local $bAccountClient_card_fieldsExchange_vehicleBudget Local $bAccountClient_card_fieldsExchange_vehicleEngine Local $bAccountClient_card_fieldsExchange_vehicleLength Local $bAccountClient_card_fieldsExchange_vehicleProfit Local $bAccountClient_card_fieldsExchange_vehicleSuffix Local $bAccountClient_card_fieldsExchange_vehicleWeight Local $bAccountClient_card_fieldsExchange_vehicleBalance Local $bAccountClient_card_fieldsExchange_vehicleComment Local $bAccountClient_card_fieldsExchange_vehicleMileage Local $bAccountClient_card_fieldsExchange_vehiclePayment Local $bAccountClient_card_fieldsExchange_vehicleRenewal Local $bAccountClient_card_fieldsExchange_vehicleSold_by Local $bAccountClient_card_fieldsExchange_vehicleBodyType Local $bAccountClient_card_fieldsExchange_vehicleCategory Local $bAccountClient_card_fieldsExchange_vehicleModality Local $bAccountClient_card_fieldsExchange_vehicleResidual Local $bAccountClient_card_fieldsExchange_vehicleSleeping Local $bAccountClient_card_fieldsExchange_vehicleWarranty Local $bAccountClient_card_fieldsExchange_vehicleCondition Local $bAccountClient_card_fieldsExchange_vehicleFrequency Local $bAccountClient_card_fieldsExchange_vehicleIntention Local $bAccountClient_card_fieldsExchange_vehicleRefinance Local $bAccountClient_card_fieldsExchange_vehicleRequested Local $bAccountClient_card_fieldsExchange_vehicleSold_date Local $bAccountClient_card_fieldsExchange_vehicleCategory_rv Local $bAccountClient_card_fieldsExchange_vehicleInstitution Local $bAccountClient_card_fieldsExchange_vehicleInitial_cash Local $bAccountClient_card_fieldsExchange_vehicleOffer_number Local $bAccountClient_card_fieldsExchange_vehicleTransmission Local $bAccountClient_card_fieldsExchange_vehicleDrivingWheels Local $bAccountClient_card_fieldsExchange_vehicleColor_exterior Local $bAccountClient_card_fieldsExchange_vehicleColor_interior Local $bAccountClient_card_fieldsExchange_vehicleAllowed_mileage Local $bAccountClient_card_fieldsExchange_vehicleSecurity_deposit Local $bAccountClient_card_fieldsExchange_vehicleEnd_contract_date Local $bAccountClient_number Local $bAccountConfirmation_appt Local $bAccountCredit Local $bAccountCsi Local $bAccountCsi_used Local $sAccountDefault_deliveryman_user_id Local $bAccountDelivered_by Local $bAccountDisable_communication_audio Local $bAccountDuplicates Local $bAccountGuest_action Local $bAccountEmail_client Local $bAccountIn_turn Local $bAccountIn_turn_director_management Local $bAccountLeads_other_division Local $iAccountLeadxpress_optionPriority Local $iAccountLeadxpress_optionReminderFrequency Local $iAccountLeadxpress_optionReminderRecurrence Local $bAccountLeadxpress_optionScheduleAccount Local $bAccountLeadxpress_optionScheduleAdvisor Local $bAccountLimited_audio_access Local $sAccountLogo Local $sAccountLogo_en Local $bAccountMandatory_coordinate Local $bAccountManually_status Local $sAccountMerge_rule Local $iAccountMonth_start_day Local $sAccountName Local $bAccountNiotext Local $bAccountNiotext_phone Local $sAccountPhone Local $bAccountPower_sport Local $bAccountProcess Local $bAccountRecreative_special Local $bAccountResult_date_validation Local $bAccountSale_accessories Local $bAccountSale_by_phone Local $bAccountSale_date_month Local $bAccountSale_table_optionsAccessory_column Local $bAccountSale_table_optionsCommercial_column Local $bAccountSale_table_optionsDivision_grouped_total_column Local $bAccountSale_validation Local $bAccountScan Local $bAccountStock_required_for_sale Local $bAccountTake_over_director Local $bAccountTrade_report Local $bAccountUnrestricted_assignment Local $bAccountUnsubscribe Local $bAccountUntreated_lead Local $bAccountVehicle_model_text Local $bAccountVehicle_text Local $bAccountVerified_sale Local $bAccountVin_decoder Local $sAccountWaiting_sale_date Local $bAccountWaiting_sale_option Local $sAdvisor Local $iJ Local $iCount_j Local $iLead_id Local $sAddress Local $bValid Local $sExtension Local $sNumber Local $bValidated Local $bMobile Local $sAccessories Local $sAllowed_odometer Local $iBalance Local $sBudget_max Local $sBudget_min Local $sCash_down Local $sCategory Local $sCategory_rv Local $sClient_number Local $sColor_exterior Local $sColor_interior Local $sComment Local $sCondition Local $sEnd_contract_date Local $sEnd_warranty_date Local $sEngine Local $sExtended_warranty Local $sFuel Local $sLength_max Local $sLength_min Local $sLicense_plate Local $sMake Local $sModality Local $sModel Local $sOdometer Local $sOffer_number Local $sV_option Local $sOrder_number Local $sPayment Local $sPayment_frequency Local $sPreparation Local $sPrice Local $sProfit Local $sPurchase_date Local $sRate Local $sRecall Local $sRecorded_date Local $sResidual Local $security_deposit Local $sleeping Local $bSold Local $sold_by Local $sold_date Local $stock Local $stock_state Local $sTerm Local $bTire Local $sTransmission Local $sTrim Local $sUrl Local $sValue Local $sVin Local $sWarranty Local $sWeight Local $sYear Local $sYear_max Local $sYear_min $sLinksFirst = $oJsonResponse.StringOf("links.first") $sLinksLast = $oJsonResponse.StringOf("links.last") $sLinksPrev = $oJsonResponse.StringOf("links.prev") $sLinksNext = $oJsonResponse.StringOf("links.next") $iMetaCurrent_page = $oJsonResponse.IntOf("meta.current_page") $iMetaFrom = $oJsonResponse.IntOf("meta.from") $iMetaLast_page = $oJsonResponse.IntOf("meta.last_page") $sMetaPath = $oJsonResponse.StringOf("meta.path") $iMetaPer_page = $oJsonResponse.IntOf("meta.per_page") $iMetaTo = $oJsonResponse.IntOf("meta.to") $iMetaTotal = $oJsonResponse.IntOf("meta.total") $i = 0 $iCount_i = $oJsonResponse.SizeOfArray("data") While $i < $iCount_i $oJsonResponse.I = $i $id = $oJsonResponse.IntOf("data[i].id") $sCreated_at = $oJsonResponse.StringOf("data[i].created_at") $sUpdated_at = $oJsonResponse.StringOf("data[i].updated_at") $iAccount_id = $oJsonResponse.IntOf("data[i].account_id") $sAddress_line1 = $oJsonResponse.StringOf("data[i].address_line1") $sAddress_line2 = $oJsonResponse.StringOf("data[i].address_line2") $sAppointment_date = $oJsonResponse.StringOf("data[i].appointment_date") $bAppt_call = $oJsonResponse.BoolOf("data[i].appt_call") $sAvailable_date = $oJsonResponse.StringOf("data[i].available_date") $sAverage_spending = $oJsonResponse.StringOf("data[i].average_spending") $sBe_back_date = $oJsonResponse.StringOf("data[i].be_back_date") $sBirth_date = $oJsonResponse.StringOf("data[i].birth_date") $sBusiness = $oJsonResponse.StringOf("data[i].business") $sCall_date = $oJsonResponse.StringOf("data[i].call_date") $sCity = $oJsonResponse.StringOf("data[i].city") $sCivility = $oJsonResponse.StringOf("data[i].civility") $sCode = $oJsonResponse.StringOf("data[i].code") $sCountry = $oJsonResponse.StringOf("data[i].country") $sCsi_date = $oJsonResponse.StringOf("data[i].csi_date") $sDelivered_by_id = $oJsonResponse.StringOf("data[i].delivered_by_id") $sDelivered_date = $oJsonResponse.StringOf("data[i].delivered_date") $sDelivery_date = $oJsonResponse.StringOf("data[i].delivery_date") $sDivision = $oJsonResponse.StringOf("data[i].division") $sEnd_service_date = $oJsonResponse.StringOf("data[i].end_service_date") $sFirst_name = $oJsonResponse.StringOf("data[i].first_name") $sGas = $oJsonResponse.StringOf("data[i].gas") $iGender = $oJsonResponse.IntOf("data[i].gender") $bInvoiced = $oJsonResponse.BoolOf("data[i].invoiced") $sLast_name = $oJsonResponse.StringOf("data[i].last_name") $sLast_visit_date = $oJsonResponse.StringOf("data[i].last_visit_date") $sLocale = $oJsonResponse.StringOf("data[i].locale") $sLoyalty = $oJsonResponse.StringOf("data[i].loyalty") $sNext_visit_date = $oJsonResponse.StringOf("data[i].next_visit_date") $sOdometer_last_visit = $oJsonResponse.StringOf("data[i].odometer_last_visit") $sOpen_work_order_date = $oJsonResponse.StringOf("data[i].open_work_order_date") $sPlanned_pick_up_date = $oJsonResponse.StringOf("data[i].planned_pick_up_date") $sPostal_code = $oJsonResponse.StringOf("data[i].postal_code") $sPrepaid = $oJsonResponse.StringOf("data[i].prepaid") $bPrepared = $oJsonResponse.BoolOf("data[i].prepared") $sPresented_date = $oJsonResponse.StringOf("data[i].presented_date") $sPromised_date = $oJsonResponse.StringOf("data[i].promised_date") $sProvince = $oJsonResponse.StringOf("data[i].province") $sRating = $oJsonResponse.StringOf("data[i].rating") $bReached_client = $oJsonResponse.BoolOf("data[i].reached_client") $sRefinanced_date = $oJsonResponse.StringOf("data[i].refinanced_date") $sRepair_date = $oJsonResponse.StringOf("data[i].repair_date") $sRepair_order = $oJsonResponse.StringOf("data[i].repair_order") $sResult = $oJsonResponse.StringOf("data[i].result") $sRoad_test_date = $oJsonResponse.StringOf("data[i].road_test_date") $sale_date = $oJsonResponse.StringOf("data[i].sale_date") $second_contact = $oJsonResponse.StringOf("data[i].second_contact") $second_contact_civility = $oJsonResponse.StringOf("data[i].second_contact_civility") $segment = $oJsonResponse.StringOf("data[i].segment") $bService_cleaned = $oJsonResponse.BoolOf("data[i].service_cleaned") $service_interval_km = $oJsonResponse.StringOf("data[i].service_interval_km") $service_monthly_km = $oJsonResponse.StringOf("data[i].service_monthly_km") $service_processIntention = $oJsonResponse.StringOf("data[i].service_process.intention") $service_processTransport = $oJsonResponse.StringOf("data[i].service_process.transport") $service_processWalk_around = $oJsonResponse.StringOf("data[i].service_process.walk_around") $sex = $oJsonResponse.StringOf("data[i].sex") $source = $oJsonResponse.StringOf("data[i].source") $status = $oJsonResponse.StringOf("data[i].status") $storage = $oJsonResponse.StringOf("data[i].storage") $sTake_over_date = $oJsonResponse.StringOf("data[i].take_over_date") $sV_type = $oJsonResponse.StringOf("data[i].type") $sUnsubscribe_all_date = $oJsonResponse.StringOf("data[i].unsubscribe_all_date") $sUnsubscribe_call_date = $oJsonResponse.StringOf("data[i].unsubscribe_call_date") $sUnsubscribe_email_date = $oJsonResponse.StringOf("data[i].unsubscribe_email_date") $sUnsubscribe_sms_date = $oJsonResponse.StringOf("data[i].unsubscribe_sms_date") $sWork_order = $oJsonResponse.StringOf("data[i].work_order") $iAccountId = $oJsonResponse.IntOf("data[i].account.id") $sAccountCreated_at = $oJsonResponse.StringOf("data[i].account.created_at") $sAccountUpdated_at = $oJsonResponse.StringOf("data[i].account.updated_at") $iAccountPartner_id = $oJsonResponse.IntOf("data[i].account.partner_id") $bAccountActivity_report = $oJsonResponse.BoolOf("data[i].account.activity_report") $bAccountCommercial = $oJsonResponse.BoolOf("data[i].account.commercial") $bAccountEvent = $oJsonResponse.BoolOf("data[i].account.event") $bAccountLeadxpress = $oJsonResponse.BoolOf("data[i].account.leadxpress") $bAccountLoyalty = $oJsonResponse.BoolOf("data[i].account.loyalty") $bAccountPhone_up = $oJsonResponse.BoolOf("data[i].account.phone_up") $bAccountRenewal = $oJsonResponse.BoolOf("data[i].account.renewal") $bAccountSale_table = $oJsonResponse.BoolOf("data[i].account.sale_table") $bAccountService = $oJsonResponse.BoolOf("data[i].account.service") $bAccountWalk_in = $oJsonResponse.BoolOf("data[i].account.walk_in") $bAccountWebboost = $oJsonResponse.BoolOf("data[i].account.webboost") $bAccountAccount_manager = $oJsonResponse.BoolOf("data[i].account.account_manager") $sAccountActivation_date = $oJsonResponse.StringOf("data[i].account.activation_date") $bAccountActive = $oJsonResponse.BoolOf("data[i].account.active") $bAccountAssigned_lead = $oJsonResponse.BoolOf("data[i].account.assigned_lead") $bAccountAuto_renewal = $oJsonResponse.BoolOf("data[i].account.auto_renewal") $bAccountAuto_renewal_new = $oJsonResponse.BoolOf("data[i].account.auto_renewal_new") $bAccountAuto_renewal_used = $oJsonResponse.BoolOf("data[i].account.auto_renewal_used") $bAccountAutomation = $oJsonResponse.BoolOf("data[i].account.automation") $bAccountBdc_advisor = $oJsonResponse.BoolOf("data[i].account.bdc_advisor") $bAccountCalendar_options = $oJsonResponse.BoolOf("data[i].account.calendar_options") $bAccountClient_card_fieldsProcessGas = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.gas") $bAccountClient_card_fieldsProcessRecorded = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.recorded") $bAccountClient_card_fieldsProcessAvailable = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.available") $bAccountClient_card_fieldsProcessDiscounted = $oJsonResponse.BoolOf("data[i].account.client_card_fields.process.discounted") $bAccountClient_card_fieldsCommercialProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.profit") $bAccountClient_card_fieldsCommercialExclude = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.exclude") $bAccountClient_card_fieldsCommercialMeeting = $oJsonResponse.BoolOf("data[i].account.client_card_fields.commercial.meeting") $bAccountClient_card_fieldsPerformanceDeposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.deposit") $bAccountClient_card_fieldsPerformanceRefinanced = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.refinanced") $bAccountClient_card_fieldsPerformanceDealer_tour = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.dealer_tour") $bAccountClient_card_fieldsPerformanceWalk_around = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.walk_around") $bAccountClient_card_fieldsPerformanceQualification = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.qualification") $bAccountClient_card_fieldsPerformanceTwenty_four_hour = $oJsonResponse.BoolOf("data[i].account.client_card_fields.performance.twenty_four_hour") $bAccountClient_card_fieldsGeneral_infoBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.budget") $bAccountClient_card_fieldsGeneral_infoSector = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.sector") $bAccountClient_card_fieldsGeneral_infoCustom_1 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_1") $bAccountClient_card_fieldsGeneral_infoCustom_2 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_2") $bAccountClient_card_fieldsGeneral_infoCustom_3 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_3") $bAccountClient_card_fieldsGeneral_infoCustom_4 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_4") $bAccountClient_card_fieldsGeneral_infoCustom_5 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_5") $bAccountClient_card_fieldsGeneral_infoCustom_6 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_6") $bAccountClient_card_fieldsGeneral_infoCustom_7 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_7") $bAccountClient_card_fieldsGeneral_infoCustom_8 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_8") $bAccountClient_card_fieldsGeneral_infoCustom_9 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_9") $bAccountClient_card_fieldsGeneral_infoCustom_10 = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.custom_10") $bAccountClient_card_fieldsGeneral_infoCommunication_preference = $oJsonResponse.BoolOf("data[i].account.client_card_fields.general_info.communication_preference") $bAccountClient_card_fieldsWanted_vehicleVin = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.vin") $bAccountClient_card_fieldsWanted_vehicleFuel = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.fuel") $bAccountClient_card_fieldsWanted_vehicleRate = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.rate") $bAccountClient_card_fieldsWanted_vehicleTerm = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.term") $bAccountClient_card_fieldsWanted_vehicleTire = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.tire") $bAccountClient_card_fieldsWanted_vehicleYear = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.year") $bAccountClient_card_fieldsWanted_vehicleColor = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color") $bAccountClient_card_fieldsWanted_vehiclePrice = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.price") $bAccountClient_card_fieldsWanted_vehicleStock = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.stock") $bAccountClient_card_fieldsWanted_vehicleTotal = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.total") $bAccountClient_card_fieldsWanted_vehicleBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.budget") $bAccountClient_card_fieldsWanted_vehicleEngine = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.engine") $bAccountClient_card_fieldsWanted_vehicleLength = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.length") $bAccountClient_card_fieldsWanted_vehicleProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.profit") $bAccountClient_card_fieldsWanted_vehicleSuffix = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.suffix") $bAccountClient_card_fieldsWanted_vehicleWeight = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.weight") $bAccountClient_card_fieldsWanted_vehicleComment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.comment") $bAccountClient_card_fieldsWanted_vehicleMileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.mileage") $bAccountClient_card_fieldsWanted_vehiclePayment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.payment") $bAccountClient_card_fieldsWanted_vehicleBodyType = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.bodyType") $bAccountClient_card_fieldsWanted_vehicleCategory = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category") $bAccountClient_card_fieldsWanted_vehicleModality = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.modality") $bAccountClient_card_fieldsWanted_vehicleResidual = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.residual") $bAccountClient_card_fieldsWanted_vehicleSleeping = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.sleeping") $bAccountClient_card_fieldsWanted_vehicleWarranty = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.warranty") $bAccountClient_card_fieldsWanted_vehicleFrequency = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.frequency") $bAccountClient_card_fieldsWanted_vehicleAccessories = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.accessories") $bAccountClient_card_fieldsWanted_vehicleCategory_rv = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.category_rv") $bAccountClient_card_fieldsWanted_vehiclePreparation = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.preparation") $bAccountClient_card_fieldsWanted_vehicleInitial_cash = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.initial_cash") $bAccountClient_card_fieldsWanted_vehicleOffer_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.offer_number") $bAccountClient_card_fieldsWanted_vehicleOrder_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.order_number") $bAccountClient_card_fieldsWanted_vehicleTransmission = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.transmission") $bAccountClient_card_fieldsWanted_vehicleDocumentation = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.documentation") $bAccountClient_card_fieldsWanted_vehicleDrivingWheels = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.drivingWheels") $bAccountClient_card_fieldsWanted_vehicleColor_exterior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_exterior") $bAccountClient_card_fieldsWanted_vehicleColor_interior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.color_interior") $bAccountClient_card_fieldsWanted_vehicleAllowed_mileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.allowed_mileage") $bAccountClient_card_fieldsWanted_vehicleSecurity_deposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.security_deposit") $bAccountClient_card_fieldsWanted_vehicleEnd_contract_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.wanted_vehicle.end_contract_date") $bAccountClient_card_fieldsExchange_vehicleVin = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.vin") $bAccountClient_card_fieldsExchange_vehicleFuel = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.fuel") $bAccountClient_card_fieldsExchange_vehicleLink = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.link") $bAccountClient_card_fieldsExchange_vehicleRate = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.rate") $bAccountClient_card_fieldsExchange_vehicleTerm = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.term") $bAccountClient_card_fieldsExchange_vehicleYear = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.year") $bAccountClient_card_fieldsExchange_vehicleColor = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color") $bAccountClient_card_fieldsExchange_vehiclePrice = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.price") $bAccountClient_card_fieldsExchange_vehicleStock = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.stock") $bAccountClient_card_fieldsExchange_vehicleValue = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.value") $bAccountClient_card_fieldsExchange_vehicleBudget = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.budget") $bAccountClient_card_fieldsExchange_vehicleEngine = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.engine") $bAccountClient_card_fieldsExchange_vehicleLength = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.length") $bAccountClient_card_fieldsExchange_vehicleProfit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.profit") $bAccountClient_card_fieldsExchange_vehicleSuffix = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.suffix") $bAccountClient_card_fieldsExchange_vehicleWeight = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.weight") $bAccountClient_card_fieldsExchange_vehicleBalance = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.balance") $bAccountClient_card_fieldsExchange_vehicleComment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.comment") $bAccountClient_card_fieldsExchange_vehicleMileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.mileage") $bAccountClient_card_fieldsExchange_vehiclePayment = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.payment") $bAccountClient_card_fieldsExchange_vehicleRenewal = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.renewal") $bAccountClient_card_fieldsExchange_vehicleSold_by = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_by") $bAccountClient_card_fieldsExchange_vehicleBodyType = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.bodyType") $bAccountClient_card_fieldsExchange_vehicleCategory = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category") $bAccountClient_card_fieldsExchange_vehicleModality = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.modality") $bAccountClient_card_fieldsExchange_vehicleResidual = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.residual") $bAccountClient_card_fieldsExchange_vehicleSleeping = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sleeping") $bAccountClient_card_fieldsExchange_vehicleWarranty = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.warranty") $bAccountClient_card_fieldsExchange_vehicleCondition = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.condition") $bAccountClient_card_fieldsExchange_vehicleFrequency = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.frequency") $bAccountClient_card_fieldsExchange_vehicleIntention = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.intention") $bAccountClient_card_fieldsExchange_vehicleRefinance = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.refinance") $bAccountClient_card_fieldsExchange_vehicleRequested = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.requested") $bAccountClient_card_fieldsExchange_vehicleSold_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.sold_date") $bAccountClient_card_fieldsExchange_vehicleCategory_rv = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.category_rv") $bAccountClient_card_fieldsExchange_vehicleInstitution = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.institution") $bAccountClient_card_fieldsExchange_vehicleInitial_cash = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.initial_cash") $bAccountClient_card_fieldsExchange_vehicleOffer_number = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.offer_number") $bAccountClient_card_fieldsExchange_vehicleTransmission = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.transmission") $bAccountClient_card_fieldsExchange_vehicleDrivingWheels = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.drivingWheels") $bAccountClient_card_fieldsExchange_vehicleColor_exterior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_exterior") $bAccountClient_card_fieldsExchange_vehicleColor_interior = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.color_interior") $bAccountClient_card_fieldsExchange_vehicleAllowed_mileage = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.allowed_mileage") $bAccountClient_card_fieldsExchange_vehicleSecurity_deposit = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.security_deposit") $bAccountClient_card_fieldsExchange_vehicleEnd_contract_date = $oJsonResponse.BoolOf("data[i].account.client_card_fields.exchange_vehicle.end_contract_date") $bAccountClient_number = $oJsonResponse.BoolOf("data[i].account.client_number") $bAccountConfirmation_appt = $oJsonResponse.BoolOf("data[i].account.confirmation_appt") $bAccountCredit = $oJsonResponse.BoolOf("data[i].account.credit") $bAccountCsi = $oJsonResponse.BoolOf("data[i].account.csi") $bAccountCsi_used = $oJsonResponse.BoolOf("data[i].account.csi_used") $sAccountDefault_deliveryman_user_id = $oJsonResponse.StringOf("data[i].account.default_deliveryman_user_id") $bAccountDelivered_by = $oJsonResponse.BoolOf("data[i].account.delivered_by") $bAccountDisable_communication_audio = $oJsonResponse.BoolOf("data[i].account.disable_communication_audio") $bAccountDuplicates = $oJsonResponse.BoolOf("data[i].account.duplicates") $bAccountGuest_action = $oJsonResponse.BoolOf("data[i].account.guest_action") $bAccountEmail_client = $oJsonResponse.BoolOf("data[i].account.email_client") $bAccountIn_turn = $oJsonResponse.BoolOf("data[i].account.in_turn") $bAccountIn_turn_director_management = $oJsonResponse.BoolOf("data[i].account.in_turn_director_management") $bAccountLeads_other_division = $oJsonResponse.BoolOf("data[i].account.leads_other_division") $iAccountLeadxpress_optionPriority = $oJsonResponse.IntOf("data[i].account.leadxpress_option.priority") $iAccountLeadxpress_optionReminderFrequency = $oJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.frequency") $iAccountLeadxpress_optionReminderRecurrence = $oJsonResponse.IntOf("data[i].account.leadxpress_option.reminder.recurrence") $bAccountLeadxpress_optionScheduleAccount = $oJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.account") $bAccountLeadxpress_optionScheduleAdvisor = $oJsonResponse.BoolOf("data[i].account.leadxpress_option.schedule.advisor") $bAccountLimited_audio_access = $oJsonResponse.BoolOf("data[i].account.limited_audio_access") $sAccountLogo = $oJsonResponse.StringOf("data[i].account.logo") $sAccountLogo_en = $oJsonResponse.StringOf("data[i].account.logo_en") $bAccountMandatory_coordinate = $oJsonResponse.BoolOf("data[i].account.mandatory_coordinate") $bAccountManually_status = $oJsonResponse.BoolOf("data[i].account.manually_status") $sAccountMerge_rule = $oJsonResponse.StringOf("data[i].account.merge_rule") $iAccountMonth_start_day = $oJsonResponse.IntOf("data[i].account.month_start_day") $sAccountName = $oJsonResponse.StringOf("data[i].account.name") $bAccountNiotext = $oJsonResponse.BoolOf("data[i].account.niotext") $bAccountNiotext_phone = $oJsonResponse.BoolOf("data[i].account.niotext_phone") $sAccountPhone = $oJsonResponse.StringOf("data[i].account.phone") $bAccountPower_sport = $oJsonResponse.BoolOf("data[i].account.power_sport") $bAccountProcess = $oJsonResponse.BoolOf("data[i].account.process") $bAccountRecreative_special = $oJsonResponse.BoolOf("data[i].account.recreative_special") $bAccountResult_date_validation = $oJsonResponse.BoolOf("data[i].account.result_date_validation") $bAccountSale_accessories = $oJsonResponse.BoolOf("data[i].account.sale_accessories") $bAccountSale_by_phone = $oJsonResponse.BoolOf("data[i].account.sale_by_phone") $bAccountSale_date_month = $oJsonResponse.BoolOf("data[i].account.sale_date_month") $bAccountSale_table_optionsAccessory_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.accessory_column") $bAccountSale_table_optionsCommercial_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.commercial_column") $bAccountSale_table_optionsDivision_grouped_total_column = $oJsonResponse.BoolOf("data[i].account.sale_table_options.division_grouped_total_column") $bAccountSale_validation = $oJsonResponse.BoolOf("data[i].account.sale_validation") $bAccountScan = $oJsonResponse.BoolOf("data[i].account.scan") $bAccountStock_required_for_sale = $oJsonResponse.BoolOf("data[i].account.stock_required_for_sale") $bAccountTake_over_director = $oJsonResponse.BoolOf("data[i].account.take_over_director") $bAccountTrade_report = $oJsonResponse.BoolOf("data[i].account.trade_report") $bAccountUnrestricted_assignment = $oJsonResponse.BoolOf("data[i].account.unrestricted_assignment") $bAccountUnsubscribe = $oJsonResponse.BoolOf("data[i].account.unsubscribe") $bAccountUntreated_lead = $oJsonResponse.BoolOf("data[i].account.untreated_lead") $bAccountVehicle_model_text = $oJsonResponse.BoolOf("data[i].account.vehicle_model_text") $bAccountVehicle_text = $oJsonResponse.BoolOf("data[i].account.vehicle_text") $bAccountVerified_sale = $oJsonResponse.BoolOf("data[i].account.verified_sale") $bAccountVin_decoder = $oJsonResponse.BoolOf("data[i].account.vin_decoder") $sAccountWaiting_sale_date = $oJsonResponse.StringOf("data[i].account.waiting_sale_date") $bAccountWaiting_sale_option = $oJsonResponse.BoolOf("data[i].account.waiting_sale_option") $sAdvisor = $oJsonResponse.StringOf("data[i].advisor") $iJ = 0 $iCount_j = $oJsonResponse.SizeOfArray("data[i].emails") While $iJ < $iCount_j $oJsonResponse.J = $iJ $id = $oJsonResponse.IntOf("data[i].emails[j].id") $sCreated_at = $oJsonResponse.StringOf("data[i].emails[j].created_at") $sUpdated_at = $oJsonResponse.StringOf("data[i].emails[j].updated_at") $iLead_id = $oJsonResponse.IntOf("data[i].emails[j].lead_id") $sAddress = $oJsonResponse.StringOf("data[i].emails[j].address") $sV_type = $oJsonResponse.StringOf("data[i].emails[j].type") $bValid = $oJsonResponse.BoolOf("data[i].emails[j].valid") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJsonResponse.SizeOfArray("data[i].phones") While $iJ < $iCount_j $oJsonResponse.J = $iJ $id = $oJsonResponse.IntOf("data[i].phones[j].id") $sCreated_at = $oJsonResponse.StringOf("data[i].phones[j].created_at") $sUpdated_at = $oJsonResponse.StringOf("data[i].phones[j].updated_at") $iLead_id = $oJsonResponse.IntOf("data[i].phones[j].lead_id") $sExtension = $oJsonResponse.StringOf("data[i].phones[j].extension") $sNumber = $oJsonResponse.StringOf("data[i].phones[j].number") $sV_type = $oJsonResponse.StringOf("data[i].phones[j].type") $bValid = $oJsonResponse.BoolOf("data[i].phones[j].valid") $bValidated = $oJsonResponse.BoolOf("data[i].phones[j].validated") $bMobile = $oJsonResponse.BoolOf("data[i].phones[j].mobile") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJsonResponse.SizeOfArray("data[i].vehicles") While $iJ < $iCount_j $oJsonResponse.J = $iJ $id = $oJsonResponse.IntOf("data[i].vehicles[j].id") $sCreated_at = $oJsonResponse.StringOf("data[i].vehicles[j].created_at") $sUpdated_at = $oJsonResponse.StringOf("data[i].vehicles[j].updated_at") $iLead_id = $oJsonResponse.IntOf("data[i].vehicles[j].lead_id") $sAccessories = $oJsonResponse.StringOf("data[i].vehicles[j].accessories") $sAllowed_odometer = $oJsonResponse.StringOf("data[i].vehicles[j].allowed_odometer") $iBalance = $oJsonResponse.IntOf("data[i].vehicles[j].balance") $sBudget_max = $oJsonResponse.StringOf("data[i].vehicles[j].budget_max") $sBudget_min = $oJsonResponse.StringOf("data[i].vehicles[j].budget_min") $sCash_down = $oJsonResponse.StringOf("data[i].vehicles[j].cash_down") $sCategory = $oJsonResponse.StringOf("data[i].vehicles[j].category") $sCategory_rv = $oJsonResponse.StringOf("data[i].vehicles[j].category_rv") $sClient_number = $oJsonResponse.StringOf("data[i].vehicles[j].client_number") $sColor_exterior = $oJsonResponse.StringOf("data[i].vehicles[j].color_exterior") $sColor_interior = $oJsonResponse.StringOf("data[i].vehicles[j].color_interior") $sComment = $oJsonResponse.StringOf("data[i].vehicles[j].comment") $sCondition = $oJsonResponse.StringOf("data[i].vehicles[j].condition") $sEnd_contract_date = $oJsonResponse.StringOf("data[i].vehicles[j].end_contract_date") $sEnd_warranty_date = $oJsonResponse.StringOf("data[i].vehicles[j].end_warranty_date") $sEngine = $oJsonResponse.StringOf("data[i].vehicles[j].engine") $sExtended_warranty = $oJsonResponse.StringOf("data[i].vehicles[j].extended_warranty") $sFuel = $oJsonResponse.StringOf("data[i].vehicles[j].fuel") $sLength_max = $oJsonResponse.StringOf("data[i].vehicles[j].length_max") $sLength_min = $oJsonResponse.StringOf("data[i].vehicles[j].length_min") $sLicense_plate = $oJsonResponse.StringOf("data[i].vehicles[j].license_plate") $sMake = $oJsonResponse.StringOf("data[i].vehicles[j].make") $sModality = $oJsonResponse.StringOf("data[i].vehicles[j].modality") $sModel = $oJsonResponse.StringOf("data[i].vehicles[j].model") $sOdometer = $oJsonResponse.StringOf("data[i].vehicles[j].odometer") $sOffer_number = $oJsonResponse.StringOf("data[i].vehicles[j].offer_number") $sV_option = $oJsonResponse.StringOf("data[i].vehicles[j].option") $sOrder_number = $oJsonResponse.StringOf("data[i].vehicles[j].order_number") $sPayment = $oJsonResponse.StringOf("data[i].vehicles[j].payment") $sPayment_frequency = $oJsonResponse.StringOf("data[i].vehicles[j].payment_frequency") $sPreparation = $oJsonResponse.StringOf("data[i].vehicles[j].preparation") $sPrice = $oJsonResponse.StringOf("data[i].vehicles[j].price") $sProfit = $oJsonResponse.StringOf("data[i].vehicles[j].profit") $sPurchase_date = $oJsonResponse.StringOf("data[i].vehicles[j].purchase_date") $sRate = $oJsonResponse.StringOf("data[i].vehicles[j].rate") $sRecall = $oJsonResponse.StringOf("data[i].vehicles[j].recall") $sRecorded_date = $oJsonResponse.StringOf("data[i].vehicles[j].recorded_date") $sResidual = $oJsonResponse.StringOf("data[i].vehicles[j].residual") $security_deposit = $oJsonResponse.StringOf("data[i].vehicles[j].security_deposit") $sleeping = $oJsonResponse.StringOf("data[i].vehicles[j].sleeping") $bSold = $oJsonResponse.BoolOf("data[i].vehicles[j].sold") $sold_by = $oJsonResponse.StringOf("data[i].vehicles[j].sold_by") $sold_date = $oJsonResponse.StringOf("data[i].vehicles[j].sold_date") $stock = $oJsonResponse.StringOf("data[i].vehicles[j].stock") $stock_state = $oJsonResponse.StringOf("data[i].vehicles[j].stock_state") $sTerm = $oJsonResponse.StringOf("data[i].vehicles[j].term") $bTire = $oJsonResponse.BoolOf("data[i].vehicles[j].tire") $sTransmission = $oJsonResponse.StringOf("data[i].vehicles[j].transmission") $sTrim = $oJsonResponse.StringOf("data[i].vehicles[j].trim") $sV_type = $oJsonResponse.StringOf("data[i].vehicles[j].type") $sUrl = $oJsonResponse.StringOf("data[i].vehicles[j].url") $sValue = $oJsonResponse.StringOf("data[i].vehicles[j].value") $sVin = $oJsonResponse.StringOf("data[i].vehicles[j].vin") $sWarranty = $oJsonResponse.StringOf("data[i].vehicles[j].warranty") $sWeight = $oJsonResponse.StringOf("data[i].vehicles[j].weight") $sYear = $oJsonResponse.StringOf("data[i].vehicles[j].year") $sYear_max = $oJsonResponse.StringOf("data[i].vehicles[j].year_max") $sYear_min = $oJsonResponse.StringOf("data[i].vehicles[j].year_min") $iJ = $iJ + 1 Wend $iJ = 0 $iCount_j = $oJsonResponse.SizeOfArray("data[i].products") While $iJ < $iCount_j $oJsonResponse.J = $iJ $iJ = $iJ + 1 Wend $i = $i + 1 Wend |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.