Chilkat Examples

ChilkatHOME.NET Core C#Android™AutoItCC#C++Chilkat2-PythonCkPythonClassic ASPDataFlexDelphi ActiveXDelphi DLLGoJavaLianjaMono C#Node.jsObjective-CPHP ActiveXPHP ExtensionPerlPowerBuilderPowerShellPureBasicRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++VB.NETVBScriptVisual Basic 6.0Visual FoxProXojo Plugin

SQL Server Web API Examples

Primary Categories

ABN AMRO
AWS Secrets Manager
AWS Security Token Service
AWS Translate
Activix CRM
Adyen
Alibaba Cloud OSS
Amazon Cognito
Amazon DynamoDB
Amazon MWS
Amazon Pay
Amazon Rekognition
Amazon SP-API
Amazon Voice ID
Aruba Fatturazione
Azure Maps
Azure Monitor
Azure OAuth2
Azure Storage Accounts
Backblaze S3
Banco Inter
Belgian eHealth Platform
Bitfinex v2 REST
Bluzone
BrickLink
Bunny CDN
CallRail
CardConnect
Cerved
ClickBank
Clickatell
Cloudfare
Constant Contact
DocuSign
Duo Auth MFA
ETrade
Ecwid
Egypt ITIDA
Egypt eReceipt
Etsy
Facebook
Faire
Frame.io
GeoOp
GetHarvest
Global Payments
Google People
Google Search Console
Google Translate
Hungary NAV Invoicing
IBM Text to Speech
Ibanity
IntakeQ
Jira
Lightspeed
MYOB
Magento
Mailgun
Mastercard

MedTunnel
MercadoLibre
MessageMedia
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
Moody's
Okta OAuth/OIDC
OneLogin OIDC
OneNote
OpenAI ChatGPT
PRODA
PayPal
Paynow.pl
Peoplevox
Populi
QuickBooks
Rabobank
Refinitiv
Royal Mail OBA
SCiS Schools Catalogue
SII Chile
SMSAPI
SOAP finkok.com
SendGrid
Shippo
Shopify
Shopware
Shopware 6
SimpleTexting
Square
Stripe
SugarCRM
TicketBAI
Trello
Twilio
Twitter API v2
Twitter v1
UPS
UniPin
VoiceBase
Vonage
WaTrend
Walmart v3
Wasabi
WhatsApp
WiX
WooCommerce
WordPress
Xero
Yahoo Mail
Yapily
Yousign
ZATCA
Zendesk
Zoom
_Miscellaneous_
eBay
effectconnect
hacienda.go.cr

 

 

 

(SQL Server) Activix CRM Create a Lead

Demonstrates how to create a lead and returns the created lead.

For more information, see https://docs.crm.activix.ca/api/resources/lead

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

// 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
    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
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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_9_5_0.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
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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.