|
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
(SQL Server) Activix CRM Create a LeadDemonstrates how to create a lead and returns the created lead. For more information, see https://docs.crm.activix.ca/api/resources/lead
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @iTmp0 int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- This example requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @http int -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END EXEC sp_OASetProperty @http, 'AuthToken', 'ACCESS_TOKEN' EXEC sp_OASetProperty @http, 'Accept', 'application/json' -- The following JSON is sent in the request body: -- { -- "account_id": "MY_ACCOUNT_ID", -- "first_name": "John", -- "last_name": "Doe", -- "type": "email", -- "advisor": { -- "first_name": "John", -- "last_name": "Doe" -- }, -- "emails": [ -- { -- "address": "hello@example.com", -- "type": "home" -- } -- ], -- "phones": [ -- { -- "number": "+15144321214", -- "extension": 12345, -- "type": "home" -- } -- ], -- "vehicles": [ -- { -- "make": "Aston Martin", -- "model": "DB11", -- "year": 2018, -- "type": "wanted" -- } -- ] -- } -- Use this online tool to generate the code from sample JSON: -- Generate Code to Create JSON DECLARE @jsonRequestBody int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonRequestBody OUT DECLARE @success int EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'account_id', 'MY_ACCOUNT_ID' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'first_name', 'John' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'last_name', 'Doe' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'type', 'email' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'advisor.first_name', 'John' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'advisor.last_name', 'Doe' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'emails[0].address', 'hello@example.com' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'emails[0].type', 'home' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'phones[0].number', '+15144321214' EXEC sp_OAMethod @jsonRequestBody, 'UpdateInt', @success OUT, 'phones[0].extension', 12345 EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'phones[0].type', 'home' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'vehicles[0].make', 'Aston Martin' EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'vehicles[0].model', 'DB11' EXEC sp_OAMethod @jsonRequestBody, 'UpdateInt', @success OUT, 'vehicles[0].year', 2018 EXEC sp_OAMethod @jsonRequestBody, 'UpdateString', @success OUT, 'vehicles[0].type', 'wanted' DECLARE @url nvarchar(4000) SELECT @url = 'https://crm.activix.ca/api/v2/leads' DECLARE @resp int EXEC sp_OAMethod @jsonRequestBody, 'Emit', @sTmp0 OUT EXEC sp_OAMethod @http, 'PText', @resp OUT, 'POST', @url, @sTmp0, 'utf-8', 'application/json', 0, 0 EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT IF @iTmp0 <> 1 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonRequestBody RETURN END EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT PRINT 'Response Status Code: ' + @iTmp0 DECLARE @jsonResponse int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonResponse OUT EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT EXEC sp_OAMethod @jsonResponse, 'Load', @success OUT, @sTmp0 EXEC sp_OASetProperty @jsonResponse, 'EmitCompact', 0 EXEC sp_OAMethod @jsonResponse, 'Emit', @sTmp0 OUT PRINT @sTmp0 EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT IF @iTmp0 >= 300 BEGIN PRINT 'Failed.' EXEC @hr = sp_OADestroy @resp EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonRequestBody EXEC @hr = sp_OADestroy @jsonResponse RETURN END EXEC @hr = sp_OADestroy @resp -- Sample output... -- (See the parsing code below..) -- -- Use the 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, -- ... -- }, -- ... -- ] -- } -- } DECLARE @dataId int DECLARE @dataCreated_at nvarchar(4000) DECLARE @dataUpdated_at nvarchar(4000) DECLARE @dataAccount_id int DECLARE @dataAddress_line1 nvarchar(4000) DECLARE @dataAddress_line2 nvarchar(4000) DECLARE @dataAppointment_date nvarchar(4000) DECLARE @dataAppt_call nvarchar(4000) DECLARE @dataAvailable_date nvarchar(4000) DECLARE @dataAverage_spending nvarchar(4000) DECLARE @dataBe_back_date nvarchar(4000) DECLARE @dataBirth_date nvarchar(4000) DECLARE @dataBusiness nvarchar(4000) DECLARE @dataCall_date nvarchar(4000) DECLARE @dataCity nvarchar(4000) DECLARE @dataCivility nvarchar(4000) DECLARE @dataCode nvarchar(4000) DECLARE @dataCountry nvarchar(4000) DECLARE @dataCsi_date nvarchar(4000) DECLARE @dataDelivered_by_id nvarchar(4000) DECLARE @dataDelivered_date nvarchar(4000) DECLARE @dataDelivery_date nvarchar(4000) DECLARE @dataDivision nvarchar(4000) DECLARE @dataEnd_service_date nvarchar(4000) DECLARE @dataFirst_name nvarchar(4000) DECLARE @dataGas nvarchar(4000) DECLARE @dataGender int DECLARE @dataInvoiced nvarchar(4000) DECLARE @dataLast_name nvarchar(4000) DECLARE @dataLast_visit_date nvarchar(4000) DECLARE @dataLocale nvarchar(4000) DECLARE @dataLoyalty nvarchar(4000) DECLARE @dataNext_visit_date nvarchar(4000) DECLARE @dataOdometer_last_visit nvarchar(4000) DECLARE @dataOpen_work_order_date nvarchar(4000) DECLARE @dataPlanned_pick_up_date nvarchar(4000) DECLARE @dataPostal_code nvarchar(4000) DECLARE @dataPrepaid nvarchar(4000) DECLARE @dataPrepared nvarchar(4000) DECLARE @dataPresented_date nvarchar(4000) DECLARE @dataPromised_date nvarchar(4000) DECLARE @dataProvince nvarchar(4000) DECLARE @dataRating nvarchar(4000) DECLARE @dataReached_client nvarchar(4000) DECLARE @dataRefinanced_date nvarchar(4000) DECLARE @dataRepair_date nvarchar(4000) DECLARE @dataRepair_order nvarchar(4000) DECLARE @dataResult nvarchar(4000) DECLARE @dataRoad_test_date nvarchar(4000) DECLARE @dataSale_date nvarchar(4000) DECLARE @dataSecond_contact nvarchar(4000) DECLARE @dataSecond_contact_civility nvarchar(4000) DECLARE @dataSegment nvarchar(4000) DECLARE @dataService_cleaned nvarchar(4000) DECLARE @dataService_interval_km nvarchar(4000) DECLARE @dataService_monthly_km nvarchar(4000) DECLARE @dataSex nvarchar(4000) DECLARE @dataSource nvarchar(4000) DECLARE @dataStatus nvarchar(4000) DECLARE @dataStorage nvarchar(4000) DECLARE @dataTake_over_date nvarchar(4000) DECLARE @dataType nvarchar(4000) DECLARE @dataUnsubscribe_all_date nvarchar(4000) DECLARE @dataUnsubscribe_call_date nvarchar(4000) DECLARE @dataUnsubscribe_email_date nvarchar(4000) DECLARE @dataUnsubscribe_sms_date nvarchar(4000) DECLARE @dataWork_order nvarchar(4000) DECLARE @dataAccountId int DECLARE @dataAccountCreated_at nvarchar(4000) DECLARE @dataAccountUpdated_at nvarchar(4000) DECLARE @dataAccountPartner_id int DECLARE @dataAccountActivity_report int DECLARE @dataAccountCommercial int DECLARE @dataAccountEvent int DECLARE @dataAccountLeadxpress int DECLARE @dataAccountLoyalty int DECLARE @dataAccountPhone_up int DECLARE @dataAccountRenewal int DECLARE @dataAccountSale_table int DECLARE @dataAccountService int DECLARE @dataAccountWalk_in int DECLARE @dataAccountWebboost int DECLARE @dataAccountAccount_manager int DECLARE @dataAccountActivation_date nvarchar(4000) DECLARE @dataAccountActive int DECLARE @dataAccountAssigned_lead int DECLARE @dataAccountAuto_renewal int DECLARE @dataAccountAuto_renewal_new int DECLARE @dataAccountAuto_renewal_used int DECLARE @dataAccountAutomation int DECLARE @dataAccountBdc_advisor int DECLARE @dataAccountCalendar_options int DECLARE @dataAccountClient_card_fieldsProcessGas int DECLARE @dataAccountClient_card_fieldsProcessRecorded int DECLARE @dataAccountClient_card_fieldsProcessAvailable int DECLARE @dataAccountClient_card_fieldsProcessDiscounted int DECLARE @dataAccountClient_card_fieldsCommercialProfit int DECLARE @dataAccountClient_card_fieldsCommercialExclude int DECLARE @dataAccountClient_card_fieldsCommercialMeeting int DECLARE @dataAccountClient_card_fieldsPerformanceDeposit int DECLARE @dataAccountClient_card_fieldsPerformanceRefinanced int DECLARE @dataAccountClient_card_fieldsPerformanceDealer_tour int DECLARE @dataAccountClient_card_fieldsPerformanceWalk_around int DECLARE @dataAccountClient_card_fieldsPerformanceQualification int DECLARE @dataAccountClient_card_fieldsPerformanceTwenty_four_hour int DECLARE @dataAccountClient_card_fieldsGeneral_infoBudget int DECLARE @dataAccountClient_card_fieldsGeneral_infoSector int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_1 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_2 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_3 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_4 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_5 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_6 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_7 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_8 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_9 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCustom_10 int DECLARE @dataAccountClient_card_fieldsGeneral_infoCommunication_preference int DECLARE @dataAccountClient_card_fieldsWanted_vehicleVin int DECLARE @dataAccountClient_card_fieldsWanted_vehicleFuel int DECLARE @dataAccountClient_card_fieldsWanted_vehicleRate int DECLARE @dataAccountClient_card_fieldsWanted_vehicleTerm int DECLARE @dataAccountClient_card_fieldsWanted_vehicleTire int DECLARE @dataAccountClient_card_fieldsWanted_vehicleYear int DECLARE @dataAccountClient_card_fieldsWanted_vehicleColor int DECLARE @dataAccountClient_card_fieldsWanted_vehiclePrice int DECLARE @dataAccountClient_card_fieldsWanted_vehicleStock int DECLARE @dataAccountClient_card_fieldsWanted_vehicleTotal int DECLARE @dataAccountClient_card_fieldsWanted_vehicleBudget int DECLARE @dataAccountClient_card_fieldsWanted_vehicleEngine int DECLARE @dataAccountClient_card_fieldsWanted_vehicleLength int DECLARE @dataAccountClient_card_fieldsWanted_vehicleProfit int DECLARE @dataAccountClient_card_fieldsWanted_vehicleSuffix int DECLARE @dataAccountClient_card_fieldsWanted_vehicleWeight int DECLARE @dataAccountClient_card_fieldsWanted_vehicleComment int DECLARE @dataAccountClient_card_fieldsWanted_vehicleMileage int DECLARE @dataAccountClient_card_fieldsWanted_vehiclePayment int DECLARE @dataAccountClient_card_fieldsWanted_vehicleBodyType int DECLARE @dataAccountClient_card_fieldsWanted_vehicleCategory int DECLARE @dataAccountClient_card_fieldsWanted_vehicleModality int DECLARE @dataAccountClient_card_fieldsWanted_vehicleResidual int DECLARE @dataAccountClient_card_fieldsWanted_vehicleSleeping int DECLARE @dataAccountClient_card_fieldsWanted_vehicleWarranty int DECLARE @dataAccountClient_card_fieldsWanted_vehicleFrequency int DECLARE @dataAccountClient_card_fieldsWanted_vehicleAccessories int DECLARE @dataAccountClient_card_fieldsWanted_vehicleCategory_rv int DECLARE @dataAccountClient_card_fieldsWanted_vehiclePreparation int DECLARE @dataAccountClient_card_fieldsWanted_vehicleInitial_cash int DECLARE @dataAccountClient_card_fieldsWanted_vehicleOffer_number int DECLARE @dataAccountClient_card_fieldsWanted_vehicleOrder_number int DECLARE @dataAccountClient_card_fieldsWanted_vehicleTransmission int DECLARE @dataAccountClient_card_fieldsWanted_vehicleDocumentation int DECLARE @dataAccountClient_card_fieldsWanted_vehicleDrivingWheels int DECLARE @dataAccountClient_card_fieldsWanted_vehicleColor_exterior int DECLARE @dataAccountClient_card_fieldsWanted_vehicleColor_interior int DECLARE @dataAccountClient_card_fieldsWanted_vehicleAllowed_mileage int DECLARE @dataAccountClient_card_fieldsWanted_vehicleSecurity_deposit int DECLARE @dataAccountClient_card_fieldsWanted_vehicleEnd_contract_date int DECLARE @dataAccountClient_card_fieldsExchange_vehicleVin int DECLARE @dataAccountClient_card_fieldsExchange_vehicleFuel int DECLARE @dataAccountClient_card_fieldsExchange_vehicleLink int DECLARE @dataAccountClient_card_fieldsExchange_vehicleRate int DECLARE @dataAccountClient_card_fieldsExchange_vehicleTerm int DECLARE @dataAccountClient_card_fieldsExchange_vehicleYear int DECLARE @dataAccountClient_card_fieldsExchange_vehicleColor int DECLARE @dataAccountClient_card_fieldsExchange_vehiclePrice int DECLARE @dataAccountClient_card_fieldsExchange_vehicleStock int DECLARE @dataAccountClient_card_fieldsExchange_vehicleValue int DECLARE @dataAccountClient_card_fieldsExchange_vehicleBudget int DECLARE @dataAccountClient_card_fieldsExchange_vehicleEngine int DECLARE @dataAccountClient_card_fieldsExchange_vehicleLength int DECLARE @dataAccountClient_card_fieldsExchange_vehicleProfit int DECLARE @dataAccountClient_card_fieldsExchange_vehicleSuffix int DECLARE @dataAccountClient_card_fieldsExchange_vehicleWeight int DECLARE @dataAccountClient_card_fieldsExchange_vehicleBalance int DECLARE @dataAccountClient_card_fieldsExchange_vehicleComment int DECLARE @dataAccountClient_card_fieldsExchange_vehicleMileage int DECLARE @dataAccountClient_card_fieldsExchange_vehiclePayment int DECLARE @dataAccountClient_card_fieldsExchange_vehicleRenewal int DECLARE @dataAccountClient_card_fieldsExchange_vehicleSold_by int DECLARE @dataAccountClient_card_fieldsExchange_vehicleBodyType int DECLARE @dataAccountClient_card_fieldsExchange_vehicleCategory int DECLARE @dataAccountClient_card_fieldsExchange_vehicleModality int DECLARE @dataAccountClient_card_fieldsExchange_vehicleResidual int DECLARE @dataAccountClient_card_fieldsExchange_vehicleSleeping int DECLARE @dataAccountClient_card_fieldsExchange_vehicleWarranty int DECLARE @dataAccountClient_card_fieldsExchange_vehicleCondition int DECLARE @dataAccountClient_card_fieldsExchange_vehicleFrequency int DECLARE @dataAccountClient_card_fieldsExchange_vehicleIntention int DECLARE @dataAccountClient_card_fieldsExchange_vehicleRefinance int DECLARE @dataAccountClient_card_fieldsExchange_vehicleRequested int DECLARE @dataAccountClient_card_fieldsExchange_vehicleSold_date int DECLARE @dataAccountClient_card_fieldsExchange_vehicleCategory_rv int DECLARE @dataAccountClient_card_fieldsExchange_vehicleInstitution int DECLARE @dataAccountClient_card_fieldsExchange_vehicleInitial_cash int DECLARE @dataAccountClient_card_fieldsExchange_vehicleOffer_number int DECLARE @dataAccountClient_card_fieldsExchange_vehicleTransmission int DECLARE @dataAccountClient_card_fieldsExchange_vehicleDrivingWheels int DECLARE @dataAccountClient_card_fieldsExchange_vehicleColor_exterior int DECLARE @dataAccountClient_card_fieldsExchange_vehicleColor_interior int DECLARE @dataAccountClient_card_fieldsExchange_vehicleAllowed_mileage int DECLARE @dataAccountClient_card_fieldsExchange_vehicleSecurity_deposit int DECLARE @dataAccountClient_card_fieldsExchange_vehicleEnd_contract_date int DECLARE @dataAccountClient_number int DECLARE @dataAccountConfirmation_appt int DECLARE @dataAccountCredit int DECLARE @dataAccountCsi int DECLARE @dataAccountCsi_used int DECLARE @dataAccountDefault_deliveryman_user_id nvarchar(4000) DECLARE @dataAccountDelivered_by int DECLARE @dataAccountDisable_communication_audio int DECLARE @dataAccountDuplicates int DECLARE @dataAccountGuest_action int DECLARE @dataAccountEmail_client int DECLARE @dataAccountIn_turn int DECLARE @dataAccountIn_turn_director_management int DECLARE @dataAccountLeads_other_division int DECLARE @dataAccountLeadxpress_optionPriority int DECLARE @dataAccountLeadxpress_optionReminderFrequency int DECLARE @dataAccountLeadxpress_optionReminderRecurrence int DECLARE @dataAccountLeadxpress_optionScheduleAccount int DECLARE @dataAccountLeadxpress_optionScheduleAdvisor int DECLARE @dataAccountLimited_audio_access int DECLARE @dataAccountLogo nvarchar(4000) DECLARE @dataAccountLogo_en nvarchar(4000) DECLARE @dataAccountMandatory_coordinate int DECLARE @dataAccountManually_status int DECLARE @dataAccountMerge_rule nvarchar(4000) DECLARE @dataAccountMonth_start_day int DECLARE @dataAccountName nvarchar(4000) DECLARE @dataAccountNiotext int DECLARE @dataAccountNiotext_phone int DECLARE @dataAccountPhone nvarchar(4000) DECLARE @dataAccountPower_sport int DECLARE @dataAccountProcess int DECLARE @dataAccountRecreative_special int DECLARE @dataAccountResult_date_validation int DECLARE @dataAccountSale_accessories int DECLARE @dataAccountSale_by_phone int DECLARE @dataAccountSale_date_month int DECLARE @dataAccountSale_table_optionsAccessory_column int DECLARE @dataAccountSale_table_optionsCommercial_column int DECLARE @dataAccountSale_table_optionsDivision_grouped_total_column int DECLARE @dataAccountSale_validation int DECLARE @dataAccountScan int DECLARE @dataAccountStock_required_for_sale int DECLARE @dataAccountTake_over_director int DECLARE @dataAccountTrade_report int DECLARE @dataAccountUnrestricted_assignment int DECLARE @dataAccountUnsubscribe int DECLARE @dataAccountUntreated_lead int DECLARE @dataAccountVehicle_model_text int DECLARE @dataAccountVehicle_text int DECLARE @dataAccountVerified_sale int DECLARE @dataAccountVin_decoder int DECLARE @dataAccountWaiting_sale_date nvarchar(4000) DECLARE @dataAccountWaiting_sale_option int DECLARE @dataAdvisor nvarchar(4000) DECLARE @dataBdc nvarchar(4000) DECLARE @dataCommercial nvarchar(4000) DECLARE @dataService_advisor nvarchar(4000) DECLARE @dataService_agent nvarchar(4000) DECLARE @i int DECLARE @count_i int DECLARE @id int DECLARE @created_at nvarchar(4000) DECLARE @updated_at nvarchar(4000) DECLARE @lead_id int DECLARE @address nvarchar(4000) DECLARE @v_type nvarchar(4000) DECLARE @valid int DECLARE @extension nvarchar(4000) DECLARE @number nvarchar(4000) DECLARE @validated int DECLARE @mobile int DECLARE @accessories nvarchar(4000) DECLARE @allowed_odometer nvarchar(4000) DECLARE @balance int DECLARE @budget_max nvarchar(4000) DECLARE @budget_min nvarchar(4000) DECLARE @cash_down nvarchar(4000) DECLARE @category nvarchar(4000) DECLARE @category_rv nvarchar(4000) DECLARE @client_number nvarchar(4000) DECLARE @color_exterior nvarchar(4000) DECLARE @color_interior nvarchar(4000) DECLARE @comment nvarchar(4000) DECLARE @condition nvarchar(4000) DECLARE @end_contract_date nvarchar(4000) DECLARE @end_warranty_date nvarchar(4000) DECLARE @engine nvarchar(4000) DECLARE @extended_warranty nvarchar(4000) DECLARE @fuel nvarchar(4000) DECLARE @length_max nvarchar(4000) DECLARE @length_min nvarchar(4000) DECLARE @license_plate nvarchar(4000) DECLARE @make nvarchar(4000) DECLARE @modality nvarchar(4000) DECLARE @model nvarchar(4000) DECLARE @odometer nvarchar(4000) DECLARE @offer_number nvarchar(4000) DECLARE @v_option nvarchar(4000) DECLARE @order_number nvarchar(4000) DECLARE @payment nvarchar(4000) DECLARE @payment_frequency nvarchar(4000) DECLARE @preparation nvarchar(4000) DECLARE @price nvarchar(4000) DECLARE @profit nvarchar(4000) DECLARE @purchase_date nvarchar(4000) DECLARE @rate nvarchar(4000) DECLARE @recall nvarchar(4000) DECLARE @recorded_date nvarchar(4000) DECLARE @residual nvarchar(4000) DECLARE @security_deposit nvarchar(4000) DECLARE @sleeping nvarchar(4000) DECLARE @sold int DECLARE @sold_by nvarchar(4000) DECLARE @sold_date nvarchar(4000) DECLARE @stock nvarchar(4000) DECLARE @stock_state nvarchar(4000) DECLARE @term nvarchar(4000) DECLARE @tire int DECLARE @transmission nvarchar(4000) DECLARE @trim nvarchar(4000) DECLARE @url nvarchar(4000) DECLARE @value nvarchar(4000) DECLARE @vin nvarchar(4000) DECLARE @warranty nvarchar(4000) DECLARE @weight nvarchar(4000) DECLARE @year nvarchar(4000) DECLARE @year_max nvarchar(4000) DECLARE @year_min nvarchar(4000) EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataId OUT, 'data.id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCreated_at OUT, 'data.created_at' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataUpdated_at OUT, 'data.updated_at' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccount_id OUT, 'data.account_id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAddress_line1 OUT, 'data.address_line1' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAddress_line2 OUT, 'data.address_line2' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAppointment_date OUT, 'data.appointment_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAppt_call OUT, 'data.appt_call' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAvailable_date OUT, 'data.available_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAverage_spending OUT, 'data.average_spending' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataBe_back_date OUT, 'data.be_back_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataBirth_date OUT, 'data.birth_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataBusiness OUT, 'data.business' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCall_date OUT, 'data.call_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCity OUT, 'data.city' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCivility OUT, 'data.civility' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCode OUT, 'data.code' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCountry OUT, 'data.country' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCsi_date OUT, 'data.csi_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataDelivered_by_id OUT, 'data.delivered_by_id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataDelivered_date OUT, 'data.delivered_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataDelivery_date OUT, 'data.delivery_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataDivision OUT, 'data.division' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataEnd_service_date OUT, 'data.end_service_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataFirst_name OUT, 'data.first_name' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataGas OUT, 'data.gas' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataGender OUT, 'data.gender' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataInvoiced OUT, 'data.invoiced' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataLast_name OUT, 'data.last_name' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataLast_visit_date OUT, 'data.last_visit_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataLocale OUT, 'data.locale' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataLoyalty OUT, 'data.loyalty' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataNext_visit_date OUT, 'data.next_visit_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataOdometer_last_visit OUT, 'data.odometer_last_visit' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataOpen_work_order_date OUT, 'data.open_work_order_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPlanned_pick_up_date OUT, 'data.planned_pick_up_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPostal_code OUT, 'data.postal_code' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPrepaid OUT, 'data.prepaid' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPrepared OUT, 'data.prepared' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPresented_date OUT, 'data.presented_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataPromised_date OUT, 'data.promised_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataProvince OUT, 'data.province' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataRating OUT, 'data.rating' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataReached_client OUT, 'data.reached_client' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataRefinanced_date OUT, 'data.refinanced_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataRepair_date OUT, 'data.repair_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataRepair_order OUT, 'data.repair_order' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataResult OUT, 'data.result' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataRoad_test_date OUT, 'data.road_test_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSale_date OUT, 'data.sale_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSecond_contact OUT, 'data.second_contact' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSecond_contact_civility OUT, 'data.second_contact_civility' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSegment OUT, 'data.segment' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataService_cleaned OUT, 'data.service_cleaned' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataService_interval_km OUT, 'data.service_interval_km' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataService_monthly_km OUT, 'data.service_monthly_km' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSex OUT, 'data.sex' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataSource OUT, 'data.source' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataStatus OUT, 'data.status' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataStorage OUT, 'data.storage' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataTake_over_date OUT, 'data.take_over_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataType OUT, 'data.type' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataUnsubscribe_all_date OUT, 'data.unsubscribe_all_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataUnsubscribe_call_date OUT, 'data.unsubscribe_call_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataUnsubscribe_email_date OUT, 'data.unsubscribe_email_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataUnsubscribe_sms_date OUT, 'data.unsubscribe_sms_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataWork_order OUT, 'data.work_order' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountId OUT, 'data.account.id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountCreated_at OUT, 'data.account.created_at' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountUpdated_at OUT, 'data.account.updated_at' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountPartner_id OUT, 'data.account.partner_id' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountActivity_report OUT, 'data.account.activity_report' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountCommercial OUT, 'data.account.commercial' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountEvent OUT, 'data.account.event' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLeadxpress OUT, 'data.account.leadxpress' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLoyalty OUT, 'data.account.loyalty' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountPhone_up OUT, 'data.account.phone_up' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountRenewal OUT, 'data.account.renewal' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_table OUT, 'data.account.sale_table' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountService OUT, 'data.account.service' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountWalk_in OUT, 'data.account.walk_in' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountWebboost OUT, 'data.account.webboost' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAccount_manager OUT, 'data.account.account_manager' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountActivation_date OUT, 'data.account.activation_date' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountActive OUT, 'data.account.active' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAssigned_lead OUT, 'data.account.assigned_lead' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAuto_renewal OUT, 'data.account.auto_renewal' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAuto_renewal_new OUT, 'data.account.auto_renewal_new' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAuto_renewal_used OUT, 'data.account.auto_renewal_used' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountAutomation OUT, 'data.account.automation' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountBdc_advisor OUT, 'data.account.bdc_advisor' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountCalendar_options OUT, 'data.account.calendar_options' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsProcessGas OUT, 'data.account.client_card_fields.process.gas' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsProcessRecorded OUT, 'data.account.client_card_fields.process.recorded' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsProcessAvailable OUT, 'data.account.client_card_fields.process.available' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsProcessDiscounted OUT, 'data.account.client_card_fields.process.discounted' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsCommercialProfit OUT, 'data.account.client_card_fields.commercial.profit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsCommercialExclude OUT, 'data.account.client_card_fields.commercial.exclude' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsCommercialMeeting OUT, 'data.account.client_card_fields.commercial.meeting' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceDeposit OUT, 'data.account.client_card_fields.performance.deposit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceRefinanced OUT, 'data.account.client_card_fields.performance.refinanced' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceDealer_tour OUT, 'data.account.client_card_fields.performance.dealer_tour' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceWalk_around OUT, 'data.account.client_card_fields.performance.walk_around' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceQualification OUT, 'data.account.client_card_fields.performance.qualification' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsPerformanceTwenty_four_hour OUT, 'data.account.client_card_fields.performance.twenty_four_hour' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoBudget OUT, 'data.account.client_card_fields.general_info.budget' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoSector OUT, 'data.account.client_card_fields.general_info.sector' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_1 OUT, 'data.account.client_card_fields.general_info.custom_1' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_2 OUT, 'data.account.client_card_fields.general_info.custom_2' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_3 OUT, 'data.account.client_card_fields.general_info.custom_3' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_4 OUT, 'data.account.client_card_fields.general_info.custom_4' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_5 OUT, 'data.account.client_card_fields.general_info.custom_5' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_6 OUT, 'data.account.client_card_fields.general_info.custom_6' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_7 OUT, 'data.account.client_card_fields.general_info.custom_7' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_8 OUT, 'data.account.client_card_fields.general_info.custom_8' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_9 OUT, 'data.account.client_card_fields.general_info.custom_9' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCustom_10 OUT, 'data.account.client_card_fields.general_info.custom_10' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsGeneral_infoCommunication_preference OUT, 'data.account.client_card_fields.general_info.communication_preference' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleVin OUT, 'data.account.client_card_fields.wanted_vehicle.vin' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleFuel OUT, 'data.account.client_card_fields.wanted_vehicle.fuel' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleRate OUT, 'data.account.client_card_fields.wanted_vehicle.rate' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleTerm OUT, 'data.account.client_card_fields.wanted_vehicle.term' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleTire OUT, 'data.account.client_card_fields.wanted_vehicle.tire' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleYear OUT, 'data.account.client_card_fields.wanted_vehicle.year' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleColor OUT, 'data.account.client_card_fields.wanted_vehicle.color' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehiclePrice OUT, 'data.account.client_card_fields.wanted_vehicle.price' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleStock OUT, 'data.account.client_card_fields.wanted_vehicle.stock' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleTotal OUT, 'data.account.client_card_fields.wanted_vehicle.total' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleBudget OUT, 'data.account.client_card_fields.wanted_vehicle.budget' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleEngine OUT, 'data.account.client_card_fields.wanted_vehicle.engine' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleLength OUT, 'data.account.client_card_fields.wanted_vehicle.length' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleProfit OUT, 'data.account.client_card_fields.wanted_vehicle.profit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleSuffix OUT, 'data.account.client_card_fields.wanted_vehicle.suffix' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleWeight OUT, 'data.account.client_card_fields.wanted_vehicle.weight' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleComment OUT, 'data.account.client_card_fields.wanted_vehicle.comment' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleMileage OUT, 'data.account.client_card_fields.wanted_vehicle.mileage' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehiclePayment OUT, 'data.account.client_card_fields.wanted_vehicle.payment' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleBodyType OUT, 'data.account.client_card_fields.wanted_vehicle.bodyType' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleCategory OUT, 'data.account.client_card_fields.wanted_vehicle.category' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleModality OUT, 'data.account.client_card_fields.wanted_vehicle.modality' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleResidual OUT, 'data.account.client_card_fields.wanted_vehicle.residual' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleSleeping OUT, 'data.account.client_card_fields.wanted_vehicle.sleeping' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleWarranty OUT, 'data.account.client_card_fields.wanted_vehicle.warranty' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleFrequency OUT, 'data.account.client_card_fields.wanted_vehicle.frequency' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleAccessories OUT, 'data.account.client_card_fields.wanted_vehicle.accessories' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleCategory_rv OUT, 'data.account.client_card_fields.wanted_vehicle.category_rv' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehiclePreparation OUT, 'data.account.client_card_fields.wanted_vehicle.preparation' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleInitial_cash OUT, 'data.account.client_card_fields.wanted_vehicle.initial_cash' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleOffer_number OUT, 'data.account.client_card_fields.wanted_vehicle.offer_number' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleOrder_number OUT, 'data.account.client_card_fields.wanted_vehicle.order_number' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleTransmission OUT, 'data.account.client_card_fields.wanted_vehicle.transmission' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleDocumentation OUT, 'data.account.client_card_fields.wanted_vehicle.documentation' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleDrivingWheels OUT, 'data.account.client_card_fields.wanted_vehicle.drivingWheels' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleColor_exterior OUT, 'data.account.client_card_fields.wanted_vehicle.color_exterior' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleColor_interior OUT, 'data.account.client_card_fields.wanted_vehicle.color_interior' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleAllowed_mileage OUT, 'data.account.client_card_fields.wanted_vehicle.allowed_mileage' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleSecurity_deposit OUT, 'data.account.client_card_fields.wanted_vehicle.security_deposit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsWanted_vehicleEnd_contract_date OUT, 'data.account.client_card_fields.wanted_vehicle.end_contract_date' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleVin OUT, 'data.account.client_card_fields.exchange_vehicle.vin' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleFuel OUT, 'data.account.client_card_fields.exchange_vehicle.fuel' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleLink OUT, 'data.account.client_card_fields.exchange_vehicle.link' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleRate OUT, 'data.account.client_card_fields.exchange_vehicle.rate' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleTerm OUT, 'data.account.client_card_fields.exchange_vehicle.term' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleYear OUT, 'data.account.client_card_fields.exchange_vehicle.year' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleColor OUT, 'data.account.client_card_fields.exchange_vehicle.color' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehiclePrice OUT, 'data.account.client_card_fields.exchange_vehicle.price' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleStock OUT, 'data.account.client_card_fields.exchange_vehicle.stock' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleValue OUT, 'data.account.client_card_fields.exchange_vehicle.value' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleBudget OUT, 'data.account.client_card_fields.exchange_vehicle.budget' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleEngine OUT, 'data.account.client_card_fields.exchange_vehicle.engine' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleLength OUT, 'data.account.client_card_fields.exchange_vehicle.length' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleProfit OUT, 'data.account.client_card_fields.exchange_vehicle.profit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleSuffix OUT, 'data.account.client_card_fields.exchange_vehicle.suffix' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleWeight OUT, 'data.account.client_card_fields.exchange_vehicle.weight' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleBalance OUT, 'data.account.client_card_fields.exchange_vehicle.balance' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleComment OUT, 'data.account.client_card_fields.exchange_vehicle.comment' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleMileage OUT, 'data.account.client_card_fields.exchange_vehicle.mileage' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehiclePayment OUT, 'data.account.client_card_fields.exchange_vehicle.payment' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleRenewal OUT, 'data.account.client_card_fields.exchange_vehicle.renewal' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleSold_by OUT, 'data.account.client_card_fields.exchange_vehicle.sold_by' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleBodyType OUT, 'data.account.client_card_fields.exchange_vehicle.bodyType' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleCategory OUT, 'data.account.client_card_fields.exchange_vehicle.category' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleModality OUT, 'data.account.client_card_fields.exchange_vehicle.modality' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleResidual OUT, 'data.account.client_card_fields.exchange_vehicle.residual' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleSleeping OUT, 'data.account.client_card_fields.exchange_vehicle.sleeping' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleWarranty OUT, 'data.account.client_card_fields.exchange_vehicle.warranty' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleCondition OUT, 'data.account.client_card_fields.exchange_vehicle.condition' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleFrequency OUT, 'data.account.client_card_fields.exchange_vehicle.frequency' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleIntention OUT, 'data.account.client_card_fields.exchange_vehicle.intention' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleRefinance OUT, 'data.account.client_card_fields.exchange_vehicle.refinance' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleRequested OUT, 'data.account.client_card_fields.exchange_vehicle.requested' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleSold_date OUT, 'data.account.client_card_fields.exchange_vehicle.sold_date' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleCategory_rv OUT, 'data.account.client_card_fields.exchange_vehicle.category_rv' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleInstitution OUT, 'data.account.client_card_fields.exchange_vehicle.institution' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleInitial_cash OUT, 'data.account.client_card_fields.exchange_vehicle.initial_cash' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleOffer_number OUT, 'data.account.client_card_fields.exchange_vehicle.offer_number' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleTransmission OUT, 'data.account.client_card_fields.exchange_vehicle.transmission' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleDrivingWheels OUT, 'data.account.client_card_fields.exchange_vehicle.drivingWheels' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleColor_exterior OUT, 'data.account.client_card_fields.exchange_vehicle.color_exterior' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleColor_interior OUT, 'data.account.client_card_fields.exchange_vehicle.color_interior' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleAllowed_mileage OUT, 'data.account.client_card_fields.exchange_vehicle.allowed_mileage' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleSecurity_deposit OUT, 'data.account.client_card_fields.exchange_vehicle.security_deposit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_card_fieldsExchange_vehicleEnd_contract_date OUT, 'data.account.client_card_fields.exchange_vehicle.end_contract_date' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountClient_number OUT, 'data.account.client_number' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountConfirmation_appt OUT, 'data.account.confirmation_appt' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountCredit OUT, 'data.account.credit' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountCsi OUT, 'data.account.csi' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountCsi_used OUT, 'data.account.csi_used' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountDefault_deliveryman_user_id OUT, 'data.account.default_deliveryman_user_id' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountDelivered_by OUT, 'data.account.delivered_by' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountDisable_communication_audio OUT, 'data.account.disable_communication_audio' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountDuplicates OUT, 'data.account.duplicates' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountGuest_action OUT, 'data.account.guest_action' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountEmail_client OUT, 'data.account.email_client' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountIn_turn OUT, 'data.account.in_turn' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountIn_turn_director_management OUT, 'data.account.in_turn_director_management' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLeads_other_division OUT, 'data.account.leads_other_division' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountLeadxpress_optionPriority OUT, 'data.account.leadxpress_option.priority' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountLeadxpress_optionReminderFrequency OUT, 'data.account.leadxpress_option.reminder.frequency' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountLeadxpress_optionReminderRecurrence OUT, 'data.account.leadxpress_option.reminder.recurrence' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLeadxpress_optionScheduleAccount OUT, 'data.account.leadxpress_option.schedule.account' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLeadxpress_optionScheduleAdvisor OUT, 'data.account.leadxpress_option.schedule.advisor' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountLimited_audio_access OUT, 'data.account.limited_audio_access' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountLogo OUT, 'data.account.logo' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountLogo_en OUT, 'data.account.logo_en' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountMandatory_coordinate OUT, 'data.account.mandatory_coordinate' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountManually_status OUT, 'data.account.manually_status' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountMerge_rule OUT, 'data.account.merge_rule' EXEC sp_OAMethod @jsonResponse, 'IntOf', @dataAccountMonth_start_day OUT, 'data.account.month_start_day' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountName OUT, 'data.account.name' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountNiotext OUT, 'data.account.niotext' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountNiotext_phone OUT, 'data.account.niotext_phone' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountPhone OUT, 'data.account.phone' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountPower_sport OUT, 'data.account.power_sport' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountProcess OUT, 'data.account.process' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountRecreative_special OUT, 'data.account.recreative_special' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountResult_date_validation OUT, 'data.account.result_date_validation' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_accessories OUT, 'data.account.sale_accessories' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_by_phone OUT, 'data.account.sale_by_phone' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_date_month OUT, 'data.account.sale_date_month' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_table_optionsAccessory_column OUT, 'data.account.sale_table_options.accessory_column' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_table_optionsCommercial_column OUT, 'data.account.sale_table_options.commercial_column' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_table_optionsDivision_grouped_total_column OUT, 'data.account.sale_table_options.division_grouped_total_column' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountSale_validation OUT, 'data.account.sale_validation' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountScan OUT, 'data.account.scan' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountStock_required_for_sale OUT, 'data.account.stock_required_for_sale' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountTake_over_director OUT, 'data.account.take_over_director' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountTrade_report OUT, 'data.account.trade_report' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountUnrestricted_assignment OUT, 'data.account.unrestricted_assignment' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountUnsubscribe OUT, 'data.account.unsubscribe' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountUntreated_lead OUT, 'data.account.untreated_lead' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountVehicle_model_text OUT, 'data.account.vehicle_model_text' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountVehicle_text OUT, 'data.account.vehicle_text' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountVerified_sale OUT, 'data.account.verified_sale' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountVin_decoder OUT, 'data.account.vin_decoder' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAccountWaiting_sale_date OUT, 'data.account.waiting_sale_date' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @dataAccountWaiting_sale_option OUT, 'data.account.waiting_sale_option' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataAdvisor OUT, 'data.advisor' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataBdc OUT, 'data.bdc' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataCommercial OUT, 'data.commercial' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataService_advisor OUT, 'data.service_advisor' EXEC sp_OAMethod @jsonResponse, 'StringOf', @dataService_agent OUT, 'data.service_agent' SELECT @i = 0 EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'data.service_process' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jsonResponse, 'I', @i SELECT @i = @i + 1 END SELECT @i = 0 EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'data.emails' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jsonResponse, 'I', @i EXEC sp_OAMethod @jsonResponse, 'IntOf', @id OUT, 'data.emails[i].id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @created_at OUT, 'data.emails[i].created_at' EXEC sp_OAMethod @jsonResponse, 'StringOf', @updated_at OUT, 'data.emails[i].updated_at' EXEC sp_OAMethod @jsonResponse, 'IntOf', @lead_id OUT, 'data.emails[i].lead_id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @address OUT, 'data.emails[i].address' EXEC sp_OAMethod @jsonResponse, 'StringOf', @v_type OUT, 'data.emails[i].type' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @valid OUT, 'data.emails[i].valid' SELECT @i = @i + 1 END SELECT @i = 0 EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'data.phones' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jsonResponse, 'I', @i EXEC sp_OAMethod @jsonResponse, 'IntOf', @id OUT, 'data.phones[i].id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @created_at OUT, 'data.phones[i].created_at' EXEC sp_OAMethod @jsonResponse, 'StringOf', @updated_at OUT, 'data.phones[i].updated_at' EXEC sp_OAMethod @jsonResponse, 'IntOf', @lead_id OUT, 'data.phones[i].lead_id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @extension OUT, 'data.phones[i].extension' EXEC sp_OAMethod @jsonResponse, 'StringOf', @number OUT, 'data.phones[i].number' EXEC sp_OAMethod @jsonResponse, 'StringOf', @v_type OUT, 'data.phones[i].type' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @valid OUT, 'data.phones[i].valid' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @validated OUT, 'data.phones[i].validated' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @mobile OUT, 'data.phones[i].mobile' SELECT @i = @i + 1 END SELECT @i = 0 EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'data.vehicles' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jsonResponse, 'I', @i EXEC sp_OAMethod @jsonResponse, 'IntOf', @id OUT, 'data.vehicles[i].id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @created_at OUT, 'data.vehicles[i].created_at' EXEC sp_OAMethod @jsonResponse, 'StringOf', @updated_at OUT, 'data.vehicles[i].updated_at' EXEC sp_OAMethod @jsonResponse, 'IntOf', @lead_id OUT, 'data.vehicles[i].lead_id' EXEC sp_OAMethod @jsonResponse, 'StringOf', @accessories OUT, 'data.vehicles[i].accessories' EXEC sp_OAMethod @jsonResponse, 'StringOf', @allowed_odometer OUT, 'data.vehicles[i].allowed_odometer' EXEC sp_OAMethod @jsonResponse, 'IntOf', @balance OUT, 'data.vehicles[i].balance' EXEC sp_OAMethod @jsonResponse, 'StringOf', @budget_max OUT, 'data.vehicles[i].budget_max' EXEC sp_OAMethod @jsonResponse, 'StringOf', @budget_min OUT, 'data.vehicles[i].budget_min' EXEC sp_OAMethod @jsonResponse, 'StringOf', @cash_down OUT, 'data.vehicles[i].cash_down' EXEC sp_OAMethod @jsonResponse, 'StringOf', @category OUT, 'data.vehicles[i].category' EXEC sp_OAMethod @jsonResponse, 'StringOf', @category_rv OUT, 'data.vehicles[i].category_rv' EXEC sp_OAMethod @jsonResponse, 'StringOf', @client_number OUT, 'data.vehicles[i].client_number' EXEC sp_OAMethod @jsonResponse, 'StringOf', @color_exterior OUT, 'data.vehicles[i].color_exterior' EXEC sp_OAMethod @jsonResponse, 'StringOf', @color_interior OUT, 'data.vehicles[i].color_interior' EXEC sp_OAMethod @jsonResponse, 'StringOf', @comment OUT, 'data.vehicles[i].comment' EXEC sp_OAMethod @jsonResponse, 'StringOf', @condition OUT, 'data.vehicles[i].condition' EXEC sp_OAMethod @jsonResponse, 'StringOf', @end_contract_date OUT, 'data.vehicles[i].end_contract_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @end_warranty_date OUT, 'data.vehicles[i].end_warranty_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @engine OUT, 'data.vehicles[i].engine' EXEC sp_OAMethod @jsonResponse, 'StringOf', @extended_warranty OUT, 'data.vehicles[i].extended_warranty' EXEC sp_OAMethod @jsonResponse, 'StringOf', @fuel OUT, 'data.vehicles[i].fuel' EXEC sp_OAMethod @jsonResponse, 'StringOf', @length_max OUT, 'data.vehicles[i].length_max' EXEC sp_OAMethod @jsonResponse, 'StringOf', @length_min OUT, 'data.vehicles[i].length_min' EXEC sp_OAMethod @jsonResponse, 'StringOf', @license_plate OUT, 'data.vehicles[i].license_plate' EXEC sp_OAMethod @jsonResponse, 'StringOf', @make OUT, 'data.vehicles[i].make' EXEC sp_OAMethod @jsonResponse, 'StringOf', @modality OUT, 'data.vehicles[i].modality' EXEC sp_OAMethod @jsonResponse, 'StringOf', @model OUT, 'data.vehicles[i].model' EXEC sp_OAMethod @jsonResponse, 'StringOf', @odometer OUT, 'data.vehicles[i].odometer' EXEC sp_OAMethod @jsonResponse, 'StringOf', @offer_number OUT, 'data.vehicles[i].offer_number' EXEC sp_OAMethod @jsonResponse, 'StringOf', @v_option OUT, 'data.vehicles[i].option' EXEC sp_OAMethod @jsonResponse, 'StringOf', @order_number OUT, 'data.vehicles[i].order_number' EXEC sp_OAMethod @jsonResponse, 'StringOf', @payment OUT, 'data.vehicles[i].payment' EXEC sp_OAMethod @jsonResponse, 'StringOf', @payment_frequency OUT, 'data.vehicles[i].payment_frequency' EXEC sp_OAMethod @jsonResponse, 'StringOf', @preparation OUT, 'data.vehicles[i].preparation' EXEC sp_OAMethod @jsonResponse, 'StringOf', @price OUT, 'data.vehicles[i].price' EXEC sp_OAMethod @jsonResponse, 'StringOf', @profit OUT, 'data.vehicles[i].profit' EXEC sp_OAMethod @jsonResponse, 'StringOf', @purchase_date OUT, 'data.vehicles[i].purchase_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @rate OUT, 'data.vehicles[i].rate' EXEC sp_OAMethod @jsonResponse, 'StringOf', @recall OUT, 'data.vehicles[i].recall' EXEC sp_OAMethod @jsonResponse, 'StringOf', @recorded_date OUT, 'data.vehicles[i].recorded_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @residual OUT, 'data.vehicles[i].residual' EXEC sp_OAMethod @jsonResponse, 'StringOf', @security_deposit OUT, 'data.vehicles[i].security_deposit' EXEC sp_OAMethod @jsonResponse, 'StringOf', @sleeping OUT, 'data.vehicles[i].sleeping' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @sold OUT, 'data.vehicles[i].sold' EXEC sp_OAMethod @jsonResponse, 'StringOf', @sold_by OUT, 'data.vehicles[i].sold_by' EXEC sp_OAMethod @jsonResponse, 'StringOf', @sold_date OUT, 'data.vehicles[i].sold_date' EXEC sp_OAMethod @jsonResponse, 'StringOf', @stock OUT, 'data.vehicles[i].stock' EXEC sp_OAMethod @jsonResponse, 'StringOf', @stock_state OUT, 'data.vehicles[i].stock_state' EXEC sp_OAMethod @jsonResponse, 'StringOf', @term OUT, 'data.vehicles[i].term' EXEC sp_OAMethod @jsonResponse, 'BoolOf', @tire OUT, 'data.vehicles[i].tire' EXEC sp_OAMethod @jsonResponse, 'StringOf', @transmission OUT, 'data.vehicles[i].transmission' EXEC sp_OAMethod @jsonResponse, 'StringOf', @trim OUT, 'data.vehicles[i].trim' EXEC sp_OAMethod @jsonResponse, 'StringOf', @v_type OUT, 'data.vehicles[i].type' EXEC sp_OAMethod @jsonResponse, 'StringOf', @url OUT, 'data.vehicles[i].url' EXEC sp_OAMethod @jsonResponse, 'StringOf', @value OUT, 'data.vehicles[i].value' EXEC sp_OAMethod @jsonResponse, 'StringOf', @vin OUT, 'data.vehicles[i].vin' EXEC sp_OAMethod @jsonResponse, 'StringOf', @warranty OUT, 'data.vehicles[i].warranty' EXEC sp_OAMethod @jsonResponse, 'StringOf', @weight OUT, 'data.vehicles[i].weight' EXEC sp_OAMethod @jsonResponse, 'StringOf', @year OUT, 'data.vehicles[i].year' EXEC sp_OAMethod @jsonResponse, 'StringOf', @year_max OUT, 'data.vehicles[i].year_max' EXEC sp_OAMethod @jsonResponse, 'StringOf', @year_min OUT, 'data.vehicles[i].year_min' SELECT @i = @i + 1 END SELECT @i = 0 EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'data.related_ids' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jsonResponse, 'I', @i SELECT @i = @i + 1 END EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonRequestBody EXEC @hr = sp_OADestroy @jsonResponse END GO |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.