GetWSJRates

Returns the official interest rates as published in the Wall Street Journal for a specific day.

AsOfDate:

URL

Already have an account? Please
Already have an account? Please
Already have an account? Please
Already have an account? Please
Select Output Fields Select None
ArrayOfWSJRate
WSJRate
Outcome
Message
Identity
Delay
AsOfDate
RateType
Value
EffectiveDate
RequestDate
LastCondition
MaturityInMonths
Maturity
Description
High
Low
Change

Hit Calculation

Requests against this operation count as one hit.


Authentication

In order to authenticate calls to our APIs, you must pass the token either:

  • As the _Token parameter in the query string of a REST request, or
  • In the Username value in the soap header of a SOAP request.
You can manage your API Tokens from your account page.


Sample Code

Because they use open standards, Xignite’s APIs are easily accessible from any development environment without requiring any software installation. There are many flexible ways to integrate our APIs in your apps. The sections below provide sample code in popular programming languages you can easily copy, paste, and re-use.

Sample Code for GetWSJRates

ASPX/ASP.NET

<%@ Page Language="vb" %>
<%@ Import Namespace="System.Net" %>
<!-- here, XigniteGE is the name of this assembly-->
<%@ Import Namespace="XigniteGE" %>
<HTML>
<HEAD>
<script language="vb" runat="server">
' declare the return object globally so that you can reuse it around the page
Dim objWSJRate() As WSJRate
' call the service inside the Page_Load routine
Sub Page_Load(obj as object, e as eventargs)
' create an instance of the web service
Dim objGEService As New XigniteGE()
' add authentication info
Dim objHeader As New RemoteGE.Header = new Header();
objHeader.Username = "YOUR_TOKEN" objWSJRate.HeaderValue = objHeader

' call the operation and load the return object
objWSJRate = objGEService.
GetWSJRates("11/20/2024")
If Not objWSJRate Is Nothing Then
Select Case objWSJRate(0).Outcome
Case OutcomeTypes.RegistrationError
' add processing for handling subscription problems, e.g.
Response.Write("Our subscription to this service has expired.")
Case OutcomeTypes.RequestError
' add processing for handling request problems, e.g.
' you could pass back the info message received from the service
Response.Write(objWSJRate(0).Message)
Case OutcomeTypes.SystemError
' add processing for handling system problems, e.g.
Response.Write("Service is unavailable at this time.")
End Select
Else
' add error processing here
' this condition could be caused by an HTTP error (404,500...)
Response.Write("Service is unavailable at this time.")
End If
End Sub
</script>
</HEAD>
<BODY>
<TABLE>
<TR>
<TD>
<!-- add processing for displaying the results, e.g. -->
<!-- since the return class contains an array-->
<!-- we just display its first element-->
<!-- each instance and its values can be easily accessed-->
<!-- display the value for objArrayOfWSJRate(0).Value-->
<!-- other values could be consumed in the same manner-->
<%Response.Write(objArrayOfWSJRate(0).Value)%>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

C# (CSharp)

This code could be used in any type of application (Windows, console ...). Here, RemoteGE is the web reference to the web service. Note that the default name for a web reference is generally "com.xignite.www". You will need to rename your web reference to use to use this code.

RemoteGE.XigniteGE objGEService;
objGEService = new RemoteGE.XigniteGE();
// add authentication info
RemoteGE.Header objHeader = new RemoteGE.Header();
objHeader.Username = "YOUR_TOKEN";
objGEService.HeaderValue = objHeader;

RemoteGE.WSJRate[] objWSJRate;
objWSJRate = objGEService.
GetWSJRates("11/20/2024");

if (objWSJRate == null)
{
// add error processing here
// this condition could be caused by an HTTP error (404,500...)
Console.Write("Service is unavailable at this time.");
}
else
{
switch(objWSJRate[0].Outcome)
{
case RemoteGE.OutcomeTypes.Success:
// add processing for displaying the results, e.g.
// since the return class contains an array
// we just display its first element
// each instance and its values can be easily accessed
// display the value for objWSJRate[0].Value
// other values could be consumed in the same manner
Console.Write(objWSJRate[0].Value);
break;
default:
// add processing for handling request problems, e.g.
// you could pass back the info message received from the service
Console.Write(objWSJRate[0].Message);
break;
}
}

Java

This section assumes that you have Axis installed on your machine and that you are fairly familiar with it.

Because all our web services return complex types, the best way to use Axis (Apache Axis2 1.4+) is to first generate a proxy class using the 'WSDL2Java' tool'. By default, the tool will put all generated classes into the package "com.xignite.www.services".

You should then compile the classes (including the axis dependencies):


C:\axis>java org.apache.axis.wsdl.WSDL2Java http://www.xignite.com/xGE.asmx?WSDL
C:\axis>javac com\xignite\*.java
C:\axis>
C:\axis>YOUR_AXIS_INSTALLATION\bin\wsdl2java.bat -ap -uri http://www.xignite.com/xGE.asmx?WSDL
C:\axis>javac -classpath "YOUR_AXIS_INSTALLATION/lib/*" com/xignite/www/services/*.java

You can then create your source file. See below


After creating your source file, you can compile it like this:

C:\axis>javac -classpath .;"YOUR_AXIS_INSTALLATION/lib/*" XigniteGEDemo.java

// By default, all of the classes auto-generated by the Axis2 
// "WSDL2Java" tool are placed into the package "com.xignite.www.services"
// for our Xignite WSDL, so we need an import.
import com.xignite.www.services.XigniteGEXigniteGESoapStub; import com.xignite.www.services.XigniteGEXigniteGESoapStub.*;
public class XigniteGEDemo {
public static void main(String[] args) throws Exception { // Instantiate the XigniteGE proxy
// proxy object using the Helper class.
// This class was autogenerated by the WSDL2Java tool

try { XigniteGEXigniteGESoapStub stub = new XigniteGEXigniteGESoapStub(); // Instantiate the return class from the operation
// This class was autogenerated by the WSDL2Java tool
GetWSJRates getWSJRatesArguments = new GetWSJRates(); getWSJRatesArguments.setAsOfDate("11/20/2024");
// Add authentication info
HeaderE header = new HeaderE(); Header myHeader = new Header(); myHeader.setUsername("YOUR_TOKEN"); header.setHeader(myHeader);

GetWSJRatesResponse response = stub.getWSJRates(getWSJRatesArguments, header); WSJRate[] objWSJRate = response.getGetWSJRatesResult().getWSJRate(); // objWSJRate is pointing to the result of the operation
if (objWSJRate[0].getOutcome() == OutcomeTypes.RegistrationError) { // code to handle registration errors
System.out.println(OutcomeTypes.RegistrationError.toString() + ": " + objWSJRate[0].getMessage()); } else if (objWSJRate[0].getOutcome() == OutcomeTypes.RequestError) { // code to handle request errors
System.out.println(OutcomeTypes.RequestError.toString() + ": " + objWSJRate[0].getMessage()); } else if (objWSJRate[0].getOutcome() == OutcomeTypes.SystemError) { // code to handle system errors
System.out.println(OutcomeTypes.SystemError.toString() + ": " + objWSJRate[0].getMessage()); } else // Success
{ for(int i = 0; i < objWSJRate.length; i++) { System.out.println(objWSJRate[i].getArrayOfWSJRate().getValue()); } } } catch (Exception ex) { // add exception handling code here

} } }

Perl/SoapLite

This section assumes that you have SOAP::Lite for Perl installed on your machine and that you are fairly familiar with it. But just in case your are not:

You can then use a text editor to create the source code below. You can execute it by running:


C:\perl\perl demo.pl

Note that there are some unique steps to follow to use SOAP::Lite with .Net web Services. For detailed info, check this article on MSDN.

Here is a sample source for this operation.
# the maptype instruction is critical for compatibility 
use SOAP::Lite maptype => {};
use Data::Dumper;

# this is our namespace
my $namespace = 'http://www.xignite.com/services/';

# declare the service using the namespace, the SOAP action and the uri
my $service = SOAP::Lite
-> uri($namespace)
-> on_action( sub { join '/', 'http://www.xignite.com/services', $_[1] } )
-> proxy('http://www.xignite.com/xGE.asmx');

# .Net requires the method, header, and attributes to be fully qualified
my $method = SOAP::Data->name('GetWSJRates')
->attr({xmlns => $namespace});

# this section is required for authentication
# you can skip it if you use IP-based authentication
my $header = SOAP::Header->name(Header => {
Username => '<your username here>'})->uri($namespace)->prefix('');

# same here, you can omit $header if you use IP-based authentication

my @params = ( $header,
SOAP::Data->name(AsOfDate => "11/20/2024")->uri($namespace));
# you can now call the service
my $result = $service->call($method => @params);
if ($result->fault)
{
print $result->faultstring;
}
else
{
# here we parse the output using the main return class
# and one of its attributes
# Uncoment the line below to print the full result object graph:
# print Dumper($result);
# since the output is an array, we must loop through the returned instances
foreach my $instance ($result->valueof('//WSJRate'))
{
print $instance->{'objArrayOfWSJRate[0]/Value'}, "\n";
}
}

PHP/NuSoap

NuSoap is one of the three major SOAP implementations for PHP: PEAR::SOAP, NuSOAP, and PHP-SOAP.

If you use PHP, we recommend you use NuSoap to access our web services. NuSoap uses our web services for demonstration in their own documentation and it works well.

This section assumes that you have PHP installed on your machine and that you are fairly familiar with it. We have tested this implementation for PHP 4.2.1 on Windows 2000. It should also work with more recent versions on more recent platforms. Note that PHP 5.0 supports SOAP natively (without extension), please follow their documentation for upgrade or code changes required.

To install NuSoap, download the latest package from this location. You can unzip the package in your PHP application directory. The package includes libraries (/lib) and samples (/samples). The sample code below is based on the wsdlclient1.php sample.

If you use one of the older version or PHP (i.e. 4.2.1) , you will need to comment out one line in the /lib/nusoap.php file. That section is not supported in earlier version. The line to comment out is line 1877 as shown below.


1876 // set response timeout
1877 //socket_set_timeout( $this->fp, $response_timeout);

You can then create your source file.


<?php
// need to use the NuSoap extension
require_once('../lib/nusoap.php');

// if you access the internet through a proxy server
$proxyhost = isset($_POST['proxyhost']) ? $_POST['proxyhost'] : '';
$proxyport = isset($_POST['proxyport']) ? $_POST['proxyport'] : '';
$proxyusername = isset($_POST['proxyusername']) ? $_POST['proxyusername'] : '';
$proxypassword = isset($_POST['proxypassword']) ? $_POST['proxypassword'] : '';

// define the SOAP client using the url for the service
$client = new soapclient('http://www.xignite.com/xGE.asmx?WSDL',
true, $proxyhost, $proxyport, $proxyusername, $proxypassword);

// assess the results
$err = $client->getError();
if ($err) {
echo '<h2>Constructor error</h2><pre>' . $err . '</pre>';
}

// create an array of parameters
$param = array(
"AsOfDate" => "11/20/2024");
// call the service, passing the parameters and the name of the operation
$result = $client->call('GetWSJRates', array('parameters' => $param), '', '', false, true);
// assess the results
if ($client->fault) {
echo '<h2>Fault</h2><pre>';
print_r($result);
echo '</pre>';
} else {
$err = $client->getError();
if ($err) {
echo '<h2>Error</h2><pre>' . $err . '</pre>';
} else {
// display the results
echo '<h2>Result</h2><pre>';
// this function exposes the complete structure of the return class
print_r($result);
echo '</pre>';
}
}
// print the SOAP request
echo '<h2>Request</h2><pre>' . htmlspecialchars($client->request, ENT_QUOTES) . '</pre>';
// print the SOAP response
echo '<h2>Response</h2><pre>' . htmlspecialchars($client->response, ENT_QUOTES) . '</pre>';
// print the PHP debugging trace
echo '<h2>Debug</h2><pre>' . htmlspecialchars($client->debug_str, ENT_QUOTES) . '</pre>';
?>

PHP

<?php
// Initialize CURL resource
$ch = curl_init();
// Set URL for service, replace placeholder USER_TOKEN with valid API token
curl_setopt($ch, CURLOPT_URL, 'http://www.xignite.com/xGE.json/GetWSJRates?AsOfDate=11/20/2024&_token=USER_TOKEN');
// Set response type as string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// Execute curl request
$output = curl_exec($ch);
// Close curl resource
curl_close($ch);
print($output) ?>

Ruby

This section assumes that you have some knowledge of the Ruby language, and in particular the SOAP library Savon version 2.

require 'rubygems'
require 'savon'
require 'pp'

url = "http://www.xignite.com/xGE.asmx?WSDL"

soap_header = { "Header" => { "@xmlns" => "http://www.xignite.com/services/", "Username" => "YOUR_TOKEN" } }
client = Savon.client(wsdl: url, :soap_header => soap_header, convert_request_keys_to: :none, env_namespace: 'soap')
response = client.call(:get_wsjrates, message: {
"@xmlns" => "http://www.xignite.com/services/",
AsOfDate: '11/20/2024'
})

pp response.to_hash

VB.NET

Dim objGEService As New RemoteGE.XigniteGE()
Dim objHeader As New RemoteGE.Header = new RemoteGE.Header();
objHeader.Username = "YOUR_TOKEN" objGE.HeaderValue = objHeader

Dim objWSJRate() As RemoteGE.WSJRate _
= objGEService.GetWSJRates("11/20/2024")

If Not objWSJRate Is Nothing Then
Select Case objWSJRate(0).Outcome
Case RemoteGE.OutcomeTypes.RegistrationError
' display the error to facilitate diagnostics, e.g.
Console.WriteLine(objWSJRate(0).Message)
Case RemoteGE.OutcomeTypes.RequestError
' add processing for handling request problems, e.g.
' you could pass back the info message received from the service
Console.WriteLine(objWSJRate(0).Message)
Case RemoteGE.OutcomeTypes.SystemError
' add processing for handling system problems, e.g.
Console.WriteLine("Service is unavailable at this time.")
Case Else
' add processing for displaying the results, e.g.
' since the return class contains an array
' we just display its first element
' each instance and its values can be easily accessed
' display the value for objWSJRate(0).Value
' other values could be consumed in the same manner
Console.WriteLine(objWSJRate(0).Value)
End Select
Else
' add error processing here
' this condition could be caused by an HTTP error (404,500...)
Console.WriteLine("Service is unavailable at this time.")
End If

VB6

' this DOM object will contain the result of the call
Dim objResult As IXMLDOMSelection
' create an instance of the soap toolkit
Dim objService As New MSSOAPLib30.SoapClient30
' if your network uses a proxy server, add this line
objService.ConnectorProperty("ProxyServer") = "ip of your proxy server"
' SOAP headers are not supported in the toolkit, so we will fake it with this handler
Dim objHeader As ClientHeaderHandler
Set objHeader = New ClientHeaderHandler
' set the username and passwords to your values
objHeader.Username = "YOUR_TOKEN"
Set objService.HeaderHandler = objHeader

' point the the toolkit to the WSDL
objService.mssoapinit "http://www.xignite.com/xGE.asmx?WSDL"

' load the result into the DOM object
Set objResult = objService.GetWSJRates("11/20/2024")

' you can access the properties this way:
' where objResult(5).nodeName is the name of the 5th field of the instance returned
' and objResult(5).Text is the value
MsgBox objResult(5).nodeName & " = " & objResult(5).Text


' you must also add this class to your code.
' it will create the SOAP header to pass with your request
Class Module "ClientHeaderHandler"
Option Explicit
Implements IHeaderHandler

Private m_uid As String
Private m_pwd As String
Private m_tracer As String

Property Let Username(ByVal value As String)
m_uid = value
End Property

Property Let Password(ByVal value As String)
m_pwd = value
End Property

Property Let Tracer(ByVal value As String)
m_tracer = value
End Property

Private Function iHeaderHandler_ReadHeader( _
ByVal par_reader As MSSOAPLib30.ISoapReader, _
ByVal par_HeaderNode As MSXML2.IXMLDOMNode, _
ByVal par_object As Object) As Boolean
iHeaderHandler_ReadHeader = False
End Function

Private Function iHeaderhandler_willWriteHeaders() As Boolean
iHeaderhandler_willWriteHeaders = True
End Function

Private Sub iHeaderHandler_WriteHeaders( _
ByVal par_serializer As MSSOAPLib30.ISoapSerializer, _
ByVal par_object As Object)

Dim XigniteHeaderString As String

XigniteHeaderString = "<Header xmlns="http://www.xignite.com/services/"> " & _
"<Username>" & m_uid & "</Username>" & _
"<Password>" & m_pwd & "</Password>" & _
"<Tracer>" & m_tracer & "</Tracer>" & _
"</Header>"

par_serializer.WriteXml XigniteHeaderString
End Sub

XSLT

When working with XSL, you only need to worry about properly dealing with namespaces.

The general principle in working with XSL is to apply the stylesheet (the XSL document) to the output of the web service (XML document). The code required to accomplish this varies based on your envirobment. For instance, using VB.Net it would be:

Dim objSOAPClient
Dim objTemplate As New System.Xml.Xsl.XslTransform()
objTemplate.Load(<url_of_XSL_template>)
objTemplate.Transform(<url_of_input_document>,<url_of_output_document>)

In the code above, you want to replace the <url_of_input_document> with the following URL.

http://www.xignite.com/xGE.asmx/GetWSJRates?AsOfDate=11/20/2024


And this is how you could write the XSL stylesheet. Note that all node names are prefixed.

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xi="http://www.xignite.com/services/"
version="1.0" exclude-result-prefixes="xi">
<xsl:template match="xi:ArrayOfWSJRate">
<table>
<xsl:for-each select="xi:WSJRate">
<tr>
<td>
<xsl:value-of select="xi:Value"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template></xsl:stylesheet>

The sample code is provided "as is" without any express or implied warranty. You are solely responsible for obtaining any necessary licenses or ownership rights, including for Xignite APIs and open source code, to use this sample code. Xignite has no obligation to test, certify, or support its use.


Sample Requests

All Xignite APIs support multiple, easy-to-use, open standard protocols. You can place requests against the API using a simple REST request using POST or GET or you can place a request using SOAP. The sections below show how properly formed requests and corresponding outputs look like for each protocol.

SOAP Request for GetWSJRates

Request

POST http://www.xignite.com/xGE.asmx HTTP/1.1
Host: www.xignite.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.xignite.com/services/GetWSJRates"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Header> <Header xmlns="http://www.xignite.com/services/"> <Username>string</Username> <Password>string</Password> <Tracer>string</Tracer> <IHeader_Username>string</IHeader_Username> <IHeader_Password>string</IHeader_Password> <IHeader_Tracer>string</IHeader_Tracer> </Header> </soap:Header> <soap:Body> <GetWSJRates xmlns="http://www.xignite.com/services/"> <AsOfDate>string</AsOfDate> </GetWSJRates> </soap:Body> </soap:Envelope>

Response

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetWSJRatesResponse xmlns="http://www.xignite.com/services/"> <GetWSJRatesResult> <WSJRate> <Common> <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> <WSJRate> <Common> <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> </GetWSJRatesResult> </GetWSJRatesResponse> </soap:Body> </soap:Envelope>

REST GET Request for GetWSJRates

Request

GET http://www.xignite.com/xGE.asmx/GetWSJRates?
AsOfDate=string HTTP/1.1 Host: www.xignite.com

Response

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfWSJRate xmlns="http://www.xignite.com/services/">
  <WSJRate>
    <Common>
      <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> <WSJRate> <Common> <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> </ArrayOfWSJRate>

REST POST Request for GetWSJRates

Request

POST http://www.xignite.com/xGE.asmx/GetWSJRates HTTP/1.1
Host: www.xignite.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

AsOfDate=string

Response

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfWSJRate xmlns="http://www.xignite.com/services/">
  <WSJRate>
    <Common>
      <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> <WSJRate> <Common> <Outcome>Success or SystemError or RequestError or RegistrationError
</Outcome> <Message>string</Message> <Identity>string</Identity> <Delay>double</Delay> </Common> <AsOfDate>string</AsOfDate> <RateType>PrimeRate or DiscountRate or FederalFunds or CallMoney
or CommercialPaper or EuroCommercialPaper or DealerCommercialPaper
or CertificatesofDeposit or BankersAcceptances or LondonLateEurodollars
or LIBOR or EuroLibor or EURIBOR or ForeignPrimeRates
or TreasuryBills or OvernightRepurchaseRate or FreddieMac
or FannieMae or MerrillLynchReadyAssetsTrust or ConsumerPriceIndex
or EuroDollars or LIBORSwaps or BarclaysCapitalUSCorpIndexesDoubleARated
or TIIE28 or TelerateLibor1Month or TelerateLibor3Month
or FederalReserveDiscountBoston or FederalReserveDiscountNewYork
or FederalReserveDiscountPhiladelphia or FederalReserveDiscountCleveland
or FederalReserveDiscountRichmond or FederalReserveDiscountAtlanta
or FederalReserveDiscountChicago or FederalReserveDiscountStLouis
or FederalReserveDiscountMinneapolis or FederalReserveDiscountKansasCity
or FederalReserveDiscountDallas or FederalReserveDiscountSanFrancisco
or MarketRateMO or FormulaRateTN or ConnecticutDepositRateIndex
or TBills6MonthInEffect6MonthsPriorToTheTransaction
or TennesseeMaximumEffectiveRateOfInterest or None
or Libor1Month or Libor3Months</RateType> <Value>double</Value> <EffectiveDate>string</EffectiveDate> <RequestDate>string</RequestDate> <LastCondition>string</LastCondition> <MaturityInMonths>int</MaturityInMonths> <Maturity>string</Maturity> <Description>string</Description> <High>double</High> <Low>double</Low> <Change>double</Change> </WSJRate> </ArrayOfWSJRate>

Knowledge Base Search

Find answers to your questions - search our FAQs by keyword.

Loading FAQs...

Here are our most popular FAQs. Alternatively you can search our FAQs by using the search box above or Browse our FAQs.

Contact Support

Ticket Response Time
Enterprise Plan - 2 business hours
Premium Plan - 4 business hours
Standard Plan - 1 business day


Alternate methods of contact:

support@xignite.com
Toll-free (866) 965-7627 Option 1
US (650) 655-3700 Option 1

Request a Consultation

We're here to assist you with your questions
Talk to an expert now

Output Descriptions

Outputs

NameDescriptionAlways Present
ArrayOfWSJRate
An array ofWSJRates.No
WSJRate
Each instance represents a WSJ interest rate.Yes
OutcomeThe outcome of the call. Possible values are: Success, SystemError, RequestError and RegistrationError.Yes
MessageA short message describing the error if the Outcome field contains RequestError, RegistrationError, or SystemError. An informational message is sometimes provided when Outcome is Success.No
IdentityA description of how the call was authenticated. Possible values are: IP, Cookie, Header and Request.Yes
DelayReports the time it took for the server to complete a request, in a decimal format measured in seconds (Example: 0.0016). This does not take into account any network latency experienced by the caller.Yes
AsOfDateNo
RateTypeThe rate type.Yes
ValueThe value for the rate. Not provided if High and Low are provided.No
EffectiveDateThe effective date for the rate (last time the rate changed).Yes
RequestDateNo
LastConditionNo
MaturityInMonthsNo
MaturityThe maturity for the rate.No
DescriptionThe description for the rate.Yes
HighThe high value for the rate.No
LowThe low value for the rate.No
ChangeNo