SQL Server
SQL Server
Activix CRM Create a Lead
See more Activix CRM Examples
Demonstrates how to create a lead and returns the created lead.Chilkat SQL Server Downloads
-- 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)
DECLARE @success int
SELECT @success = 0
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
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
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonRequestBody OUT
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 @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @http, 'HttpJson', @success OUT, 'POST', @url, @jsonRequestBody, 'application/json', @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @jsonRequestBody
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Response Status Code: ' + @iTmp0
DECLARE @jsonResponse int
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 @http
EXEC @hr = sp_OADestroy @jsonRequestBody
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @jsonResponse
RETURN
END
-- 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 @resp
EXEC @hr = sp_OADestroy @jsonResponse
END
GO