GeoCoder C# Code Snippet

//Add a service to your application https://trial.serviceobjects.com/gcr/GeoCoder.asmx?WSDL
GCRClient_Primary = new GCRLibraryClient("DOTSGCR");
response = GCRClient_Primary.GetBestMatch_V3(Address, City, State, PostalCode, licenseKey);
         
if (response.Error != null)
{
    //Process Error
}
else
{
    //Process Response     
}

GeoCoder Java Code Snippet

BestMatch_V3Response resp = null;
BestMatchInfo result = null;
Error error = null;
// Create soap request
GCRLibraryLocator locator = new GCRLibraryLocator();
// use ssl
locator.setDOTSGeoCoderEndpointAddress("https://trial.serviceobjects.com/gcr/GeoCoder.asmx");
IGCRLibrary gcr = locator.getDOTSGeoCoder();
DOTSGeoCoderStub soap = (DOTSGeoCoderStub)gcr;
soap.setTimeout(5000);// set timeout
resp = soap.getBestMatch_V3(address, city, state, postalcode, key);
result = resp.getGetBestMatch_V3Result();
error = resp.getError();
if(resp == null || (error != null && error.getTypeCode() == "3"))
{
    throw new Exception();
}
  
//Process Results
if(error == null){
    //DOTS GeoCode Results 
}
//Process Errors
else{
    //DOTS GeoCode Error Results   
}

GeoCoder PHP Code Snippets

<?php
// Set these values per web service <as needed>
$wsdlUrl = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx?WSDL";
 
$params['Address'] = $address;
$params['City'] = $city;
$params['State'] = $state;
$params['PostalCode'] = $postalCode;
$params['LicenseKey'] = $LicenseKey;
 
$soapClient = new SoapClient($wsdlUrl, array( "trace" => 1 ));
$result = $soapClient->GetBestMatch_V3($params);
if (!isset($result->GetBestMatch_V3Result ->Error)) {
    foreach($result->GetBestMatch_V3Result ->BestMatchInfo as $k=>$v) {
        echo $k . ", " . $v;
    }
} else {
    foreach($result->GetBestMatch_V3Result ->Error as $k=>$v) {
        echo $k . ", " . $v;
    }
}
?>

GeoCoder RoR Code Snippets

class RequestsController < ApplicationController
     
    def show
        @request = Request.find(params[:id])
        #Formats inputs into a hash to pass to Soap Client
        #Hash Keys must be named as they are shown here.
        message =   {
                    "Address" => @request.address,
                    "City" => @request.city,
                    "State" => @request.state,
                    "PostalCode" => @request.postalcode,
                    "LicenseKey" => @request.licensekey,
                    }
         
        #Implemented to make the code more readable when accessing the hash        
        @agusresponse = :get_best_match_v3_response
        @agusresult = :get_best_match_v3_result
        @aguserror = :error
        #Set Primary and Backup URLs here as needed
        dotsAGUSPrimary = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx?WSDL"
        dotsAGUSBackup = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx?WSDL"
 
        begin
            #initializes the soap client. The convert request keys global is necessary to receive a response from the service.
            client = Savon.client(  wsdl: dotsAGUSPrimary,
                                    element_form_default: :qualified,
                                    convert_request_keys_to: :camelcase
                                 )
            #Calls the with given inptus and converts response to a hash.
            response = client.call(:get_best_match_v3, message: message).to_hash
            #Checks to see what results came back from the service
            processresults(response)           
             
        #If an error occurs during the call, this will use the Backup url and attempt to retrieve data.
        rescue Savon::Error => e
            begin
            backupclient = Savon.client(    wsdl: dotsAGUSBackup,
                                            element_form_default: :qualified,
                                            convert_request_keys_to: :camelcase
                                       )
            #Sets the response to the backclient call to the operation and converts response to a hash.
            response = backupclient.call(:get_best_match_v3, message: message).to_hash
            processresults(response)
            #If the backup url failed, this will display the error received from the server
            rescue Savon::Error =>error
                @status = error
                @displaydata = {"error" => "A Big Error Occured"}
            end
        end
    end
    private
    def processresults(response)   
            #Processes Error Response from soap Client 
     
            #Processes Valid response from soap client 
         
    end
end

Address Geocode US Python Code Snippet

mAddress =  Address.get()
 if mAddress is None or  mAddress == "":
     mAddress = " "
 mCity = City.get()
 if mCity is None or mCity == "":
     mCity = " "
 mState = State.get()
 if mState is None or mState == "":
     mState = " "
 mPostalCode = PostalCode.get()
 if mPostalCode is None or mPostalCode == "":
     mPostalCode = " "
 mLicenseKey = LicenseKey.get()
 if mLicenseKey is None or mLicenseKey == "":
     mLicenseKey = " "
 
 #Set the primary and backup URLs as needed
 primaryURL = 'https://sws.serviceobjects.com/gcr/GeoCoder.asmx?WSDL'
 backupURL = 'https://sws.serviceobjects.com/gcr/GeoCoder.asmx?WSDL'
 
 #This block of code calls the web service and prints the resulting values to the screen
 try:
     client = Client(primaryURL)
     result = client.service.GetBestMatch_V3(Address=mAddress, City=mCity, State=mState, PostalCode=mPostalCode, LicenseKey=mLicenseKey)
     #Loops through either the error result or proper result and displays values to the screen.
     #Handel response and check for errors
 
 #Tries the backup URL if the primary URL failed
 except:
     try:
         client = Client(backupURL)
         result = client.service.GetBestMatch_V3(Address=mAddress, City=mCity, State=mState, PostalCode=mPostalCode, LicenseKey=mLicenseKey)
     #Handel response and check for errors
 
     #If the backup call failed then this will display an error to the screen
     except:
         Label(swin.window, text='Error').pack()
         print (result)

Address GeoCoder ColdFusion Code Snippet

<!--Makes Request to web service --->
<cfscript>
        try
        {
            if (isDefined("form.Action") AND Action neq "")
            {
                wsresponse = CreateObject("webservice", "https://sws.serviceobjects.com/gcr/GeoCoder.asmx?WSDL");                          
                outputs = wsresponse.getBestMatch_V3("#Address#", "#City#", "#State#", "#PostalCode#" ,"#LicenseKey#");
            }
        }
    catch(any Exception){
        try
            {
                if (isDefined("form.Action") AND Action neq "")
                {
                    wsresponse = CreateObject("webservice", "https://sws.serviceobjects.com/gcr/GeoCoder.asmx?WSDL");                          
                    outputs = wsresponse.getBestMatch_V3("#Address#", "#City#", "#State#", "#PostalCode#" ,"#LicenseKey#");
                }
            }
            catch(any Exception)   
                {
                 writeoutput("An Error Has Occured. Please Reload and try again #Exception.message#");              
                }
        }
</cfscript>

Address GeoCoder VB Code Snippet

Try
    Dim ws As New AGUS.DOTSGeoCoderSoapClient
    Dim response As AGUS.Location_V3
    response = ws.GetBestMatch_V3(Address.Text, City.Text, State.Text, PostalCode.Text, LicenseKey.Text)
    If (response.Error Is Nothing) Then
        ProcessValidResponse(response)
    Else
        ProcessErrorResponse(response.Error)
    End If
 
Catch
    ''Set the Primary and Backup Service References as necessary
    Try
        Dim wsbackup As New AGUS.DOTSGeoCoderSoapClient
        Dim response As AGUS.Location_V3
        response = wsbackup.GetBestMatch_V3(Address.Text, City.Text, State.Text, PostalCode.Text, LicenseKey.Text)
        If (response.Error Is Nothing) Then
            ProcessValidResponse(response)
        Else
            ProcessErrorResponse(response.Error)
        End If
    Catch ex As Exception
        resultsLabel.Visible = True
        resultsLabel.Text = ex.Message
         
    End Try
End Try

Address GeoCoder Apex Code Snippet

wwwServiceobjectsCom.Location_V3 result;
try{
wwwServiceobjectsCom.DOTSGeoCoderSoap client = new wwwServiceobjectsCom.DOTSGeoCoderSoap();
result = client.GetBestMatch_V3([Address], [City], [State], [PostalCode], [LicenseKey]);
}
catch(Exception ex){
 //If the first request failed try the failover endpoint
wwwServiceobjectsCom.DOTSGeoCoderSoap backupClient = new wwwServiceobjectsCom.DOTSGeoCoderSoap();
//The backup environment will be provided to you upon purchasing a production license key
backupClient.endpoint_x = 'https://trial.serviceobjects.com/AGUS/api.svc/soap';
result = backupClient.GetBestMatch_V3([Address], [City], [State], [PostalCode], [LicenseKey]);
}

Address GeoCoder TSQL Code Snippet

SET @requestBody ='<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">'+
                   '<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">'+
                   '<GetBestMatch_V3 xmlns="https://www.serviceobjects.com/">'+
                   '<Address>' + @address + '</Address>'+
                   '<City>' + @City + '</City>'+
                   '<State>' + @State + '</State>'+
                   '<PostalCode>' + @postalcode + '</PostalCode>'+
                   '<LicenseKey>' + @key + '</LicenseKey>'+
                   '</GetBestMatch_V3>'+
                   '</s:Body>'+
                   '</s:Envelope>'
SET @requestLength = LEN(@requestBody)
    --If a production key is purchased, this will execute the failover
IF @isLiveKey = 1
BEGIN
    EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
    EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', 'https://sws.serviceobjects.com/gcr/GeoCoder.asmx', false
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'HOST', 'sws.serviceobjects.com'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Type', 'text/xml; charset=UTF-8'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'SOAPAction', '"https://www.serviceobjects.com/GetBestMatch_V3"'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Length', @requestLength
    EXEC sp_OAMethod @obj, 'send', NULL, @requestBody
    EXEC sp_OAGetProperty @obj, 'Status', @responseCode OUTPUT
    EXEC sp_OAGetProperty @obj, 'StatusText', @statusText OUTPUT
    EXEC sp_OAGetProperty @obj, 'responseText', @response OUTPUT
             
    --Checks the Response for a fatal error or if null.
    IF @response IS NULL
    BEGIN
        EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
        EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', 'https://swsbackup.serviceobjects.com/gcr/GeoCoder.asmx', false
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'HOST', 'swsbackup.serviceobjects.com'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Type', 'text/xml; charset=UTF-8'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'SOAPAction', '"https://www.serviceobjects.com/GetBestMatch_V3"'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Length', @requestLength
        EXEC sp_OAMethod @obj, 'send', NULL, @requestBody
        EXEC sp_OAGetProperty @obj, 'Status', @responseCode OUTPUT
        EXEC sp_OAGetProperty @obj, 'StatusText', @statusText OUTPUT
        EXEC sp_OAGetProperty @obj, 'responseText', @response OUTPUT
    END
END

GeoCoder C# Rest Code Snippet

string mainURL = WEB_SERVICE_PRIMARY_URL + address + "/" + city + "/" + state + "/" + postalCode + "/" + licenseKey + "?format=json";
            string backupURL = WEB_SERVICE_BACKUP_URL + address + "/" + city + "/" + state + "/" + postalCode + "/" + licenseKey + "?format=json";
            try
            {
                result = HttpGet(mainURL);
                //NULL ERROR || FATAL ERROR RETURNED -- TRY BACKUP
                if (result == null || (result.Error != null && result.Error.Number == "3"))
                {
                    return HttpGet(backupURL);
                }
                else
                {
                    return result;
                }
            }
            catch (Exception e)
            {   //ERROR IN MAIN URL - USING BACKUP
                return HttpGet(backupURL);
            }

GeoCoder Java Rest Code Snippet

JSONObject results = RestClient(mainURL);  
try {
    if (ErrorMessages != null || (results.getJSONObject("Location_V3").has("Error") && results.getJSONObject("Location_V3").getJSONObject("Error").get("Number") == "3")) {
        // BACKUP
        results = RestClient(backupURL);
    }
} catch (JSONException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}
 
return results;

GeoCoder PHP Rest Code Snippets

$URL = "https://trial.serviceobjects.com/GCR/api.svc/GetBestMatch_V3?".rawurlencode($Address)."/".rawurlencode($City)."/".rawurlencode($State)."/".rawurlencode($PostalCode)."/".rawurlencode($LicenseKey)."?format=json";
    // The actual backup url will be provided to you once you purchase a license key
    $backupURL = "https://trial.serviceobjects.com/rest/GCR/api.svc/BestMatchInfo/V3/".rawurlencode($Address)."/".rawurlencode($City)."/".rawurlencode($State)."/".rawurlencode($PostalCode)."/".rawurlencode($LicenseKey)."?format=json";
    // Get cURL resource
    $curl = curl_init();
    curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $URL, CURLOPT_USERAGENT => 'Service Objects Address Validation 3'));
    //Https peer certification validation turned off
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($curl, CURLOPT_CONNECTTIMEOUT_MS, $TIMEOUT); //timeout in milliseconds
    // Send the request & save response to $resp
    $resp = curl_exec($curl);
    $status = curl_getinfo($curl);
    $decoded = json_decode($resp, TRUE);
    if($resp == FALSE ||
    (isset ($decoded['Error']) != NULL &&
    $decoded['Error']['Number'] == 3) ||
    (isset($status) && $status['http_code'] != 200))
    {
        // the first service has failed over
        // create a new request to the backURL
        $curl2 = curl_init();
        curl_setopt_array($curl2, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $backupURL, CURLOPT_USERAGENT => 'Service Objects Email Validation 3'));
        //Https peer certification validation turned off
        curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($curl2, CURLOPT_CONNECTTIMEOUT_MS, $TIMEOUT); //timeout in milliseconds
        // Send the request & save response to $resp
        $resp = curl_exec($curl2);
        $decoded = json_decode($resp, TRUE);
        if($resp == false)
        {
            echo "<b> Both rest calls failed </b>";
            curl_close($curl2);
            return;
        }
    }

GeoCoder RoR Rest Code Snippets

@request = Request.find(params[:id])
#This sets the default timeout for HTTParty get operation. This must be set in order to use the gem
default_timeout = 10
address = @request.address
city = @request.city
state = @request.state
postalcode = @request.postalcode
licensekey = @request.licensekey
#Set Primary and Backup URLs as needed. This method encodes and standardizes the URI to pass to the REST service.
primaryURL = URI.encode("https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=" + address + "&City=" + city + "&State=" + state + "&PostalCode=" + postalcode + "&LicenseKey=" + licensekey)
backupURL = URI.encode("https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=" + address + "&City=" + city + "&State=" + state + "&PostalCode=" + postalcode + "&LicenseKey=" + licensekey)
 
#These are set to access the hash that is returned
@agresult ="Location_V3"
@agerror = "Error"
  #Begins the call the RESTful web service
begin
  response = HTTParty.get(primaryURL, timeout: default_timeout)
  #processes the response to display to the screen
   
  #Passes the response returned from HTTParty and processes them depending on the results
  processresults(response)
   
 rescue StandardError => e
      begin
      #uses the backupURl in the event that the service encountered an error
      response = HTTParty.get(backupURL, timeout: default_timeout)
     
    #processes the response returned from using the backupURL
      processresults(response)
    #If the backup url railed this will raise an error and display the
    #error message returned from the HTTParty gem.
      rescue StandardError => error
          @status = error.message
          @displaydata = {"Error" => "A Big Error Occured"}
      end
end

Address Geocode US Python Code Snippet

 primaryURL = 'https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?'
 backupURL = 'https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?'
 #The Requests package allows the user to format the path parameters like so instead of having to manually insert them into the URL
 inputs = {'Address': mAddress, 'City': mCity, 'State': mState, 'PostalCode': mPostalCode, 'LicenseKey': mLicenseKey}
 try:
     result = requests.get(primaryURL, params=inputs)
     #Parses the XML response from the service into a python dictionary type
     outputs = xmltodict.parse(result.content)
     #checks the output for Errors and displays the info accordingly
     if 'Error' in outputs['Location_V3']:
         #loops through the response from the service and prints the values to the screen.
         for key, value in outputs['Location_V3']['Error'].iteritems():
             Label(swin.window, text=str(key) + " : " + str(value)).pack()
     else:
         #Removes unnecessary entries that were parsed into the python dictionary from XML response of service
         outputs['Location_V3'].pop("@xmlns:xsi", None)
         outputs['Location_V3'].pop("@xmlns:xsd", None)
         outputs['Location_V3'].pop("@xmlns", None)
         for key, value in outputs['Location_V3'].iteritems():
             Label(swin.window, text=str(key) + " : " + str(value)).pack()
 #Attempts to use the backupURL if the call to the primary URL failed
 except:
     try:
         result = requests.get(backupURL, params=inputs)
         #Parses the XML response from the service into a python dictionary type
         outputs = xmltodict.parse(result.content)
         #checks the output for Errors and displays the info accordingly
         if 'Error' in outputs['Location_V3']:
             #loops through the response from the service and prints the values to the screen.
             for key, value in outputs['Location_V3']['Error'].iteritems():
                 Label(swin.window, text=str(key) + " : " + str(value)).pack()
         else:
             #Removes unnecessary entries that were parsed into the python dictionary from XML response of service
             outputs['Location_V3'].pop("@xmlns:xsi", None)
             outputs['Location_V3'].pop("@xmlns:xsd", None)
             outputs['Location_V3'].pop("@xmlns", None)
             for key, value in outputs['Location_V3'].iteritems():
                 Label(swin.window, text=str(key) + " : " + str(value)).pack()

Address GeoCoder ColdFusion Code Snippet

<!--Makes Request to web service --->
<cfIf isDefined("form.Action") AND Action neq "" >
    <cftry>
        <cfset primaryURL = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=#Address#&City=#City#&State=#State#&PostalCode=#PostalCode#&LicenseKey=#LicenseKey#">
        <cfhttp url="#primaryURL#"
        method="get"
        result="response">
        <cfset outputs = XmlParse(response.FileContent)>
        <cfcatch>
            <cftry>
                <cfset backupURL = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=#Address#&City=#City#&State=#State#&PostalCode=#PostalCode#&LicenseKey=#LicenseKey#">
                <cfhttp url="#backupURL#"
                method="get"
                result="response">
                <cfset outputs = XmlParse(response.FileContent)>             
                <cfcatch >
                    <cfoutput >
                        The Following Error Occured: #response.StatusCode#
                    </cfoutput>
                </cfcatch>
            </cftry>
        </cfcatch>
    </cftry>
</cfif>

Address GeoCoder VB Rest Code Snippet

Try
    'encodes the URLs for the get Call. Set the primary and back urls as necessary
    Dim primaryurl As String = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=" + address + "&City=" + city + "&State=" + state + "&PostalCode=" + postalcode + "&LicenseKey=" + licensekey
    Dim backupurl As String = "https://trial.serviceobjects.com/gcr/GeoCoder.asmx/GetBestMatch_V3?Address=" + address + "&City=" + city + "&State=" + state + "&PostalCode=" + postalcode + "&LicenseKey=" + licensekey
    Dim wsresponse As AGUSResponse.Location_V3 = httpGet(primaryurl)
 
    'checks if a response was returned from the service, uses the backup url if response is null or a fatal error occured.
    If wsresponse Is Nothing OrElse (wsresponse.[Error] IsNot Nothing AndAlso wsresponse.[Error].Number = "3") Then
        wsresponse = httpGet(backupurl)
    End If
    If wsresponse.[Error] IsNot Nothing Then
        ProcessErrorResponse(wsresponse.[Error])
    Else
        ProcessSuccessfulResponse(wsresponse)
 
    End If
Catch ex As Exception
    'Displays the relevant error mesasge if both backup and primary urls failed.
    StatusLabel.Text = ex.Message
    StatusLabel.Visible = True
End Try

Address GeoCoder TSQL Rest Code Snippet

SET @requestBody ='<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">'+
                   '<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">'+
                   '<GetBestMatch_V3 xmlns="https://www.serviceobjects.com/">'+
                   '<Address>' + @address + '</Address>'+
                   '<City>' + @City + '</City>'+
                   '<State>' + @State + '</State>'+
                   '<PostalCode>' + @postalcode + '</PostalCode>'+
                   '<LicenseKey>' + @key + '</LicenseKey>'+
                   '</GetBestMatch_V3>'+
                   '</s:Body>'+
                   '</s:Envelope>'
SET @requestLength = LEN(@requestBody)
    --If a production key is purchased, this will execute the failover
IF @isLiveKey = 1
BEGIN
    EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
    EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', 'https://sws.serviceobjects.com/gcr/GeoCoder.asmx', false
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'HOST', 'sws.serviceobjects.com'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Type', 'text/xml; charset=UTF-8'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'SOAPAction', '"https://www.serviceobjects.com/GetBestMatch_V3"'
    EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Length', @requestLength
    EXEC sp_OAMethod @obj, 'send', NULL, @requestBody
    EXEC sp_OAGetProperty @obj, 'Status', @responseCode OUTPUT
    EXEC sp_OAGetProperty @obj, 'StatusText', @statusText OUTPUT
    EXEC sp_OAGetProperty @obj, 'responseText', @response OUTPUT
             
    --Checks the Response for a fatal error or if null.
    IF @response IS NULL
    BEGIN
        EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
        EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', 'https://swsbackup.serviceobjects.com/gcr/GeoCoder.asmx', false
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'HOST', 'swsbackup.serviceobjects.com'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Type', 'text/xml; charset=UTF-8'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'SOAPAction', '"https://www.serviceobjects.com/GetBestMatch_V3"'
        EXEC sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Length', @requestLength
        EXEC sp_OAMethod @obj, 'send', NULL, @requestBody
        EXEC sp_OAGetProperty @obj, 'Status', @responseCode OUTPUT
        EXEC sp_OAGetProperty @obj, 'StatusText', @statusText OUTPUT
        EXEC sp_OAGetProperty @obj, 'responseText', @response OUTPUT
    END
END