How to frame json request for fetching RIC values for multiple ISIN values using java?

meera_c

This is the json request:

JSONObject searchJSONObject = new JSONObject();

searchJSONObject.put(
"SearchRequest",
new JSONObject()

.put("IdentifierType", "Isin")

.put("Identifier",
new JSONArray().put("ISIN1").put("ISIN2"))

.put("PreferredIdentifierType", "Ric"));

I am getting the following error:

org.apache.http.client.HttpResponseException: Bad Request

Is this the correct way to frame the request? If not, how else can it be done?

Find more posts tagged with

isin

tick-history-rest-api

Accepted answers

Christiaan Meihsl

@meera_c, your code generates an array of instruments, but as pointed out by Veerapath, if you want several they should all be in a single string.

This is the request generated by the code in your query:

{"SearchRequest":{"PreferredIdentifierType":"Ric","Identifier":["ISIN1","ISIN2"],"IdentifierType":"Isin"}}

This is what is required:

{"SearchRequest":{"PreferredIdentifierType":"Ric","Identifier":"ISIN1, ISIN2","IdentifierType":"Isin"}}

So the code should be along these lines:

JSONObject searchJSONObject = new JSONObject()
    .put("SearchRequest", new JSONObject()
        .put("IdentifierType", "Isin")
        .put("Identifier", "ISIN1, ISIN2")
        .put("PreferredIdentifierType", "Ric"));

But again, as mentioned in my previous comment, using InstrumentSearch for more than 1 ISIN has severe limitations, I do not recommend using it that way.

All comments

Christiaan Meihsl

@meera_c, you can start by downloading the Java samples, available under the downloads tab. That will give you a good framework for experimenting, and a set of working requests. The samples are described in a readme file, and there is also some information here.

The programming without SDK tutorial explains how the HTTP requests that interact with the TRTH REST API are built in Java.

Finally, calls to convert ISINs to RICs are explained in full detail in this article.

veerapath.rungruengrayubkul

I guess that the endpoint is InstrumentSearch. Please correct me if i'm wrong.

You can add multiple identifiers in the "Identifier" parameter with comma-separated.

The code should be:

.put("Identifier", "ISIN1,ISIN2")

For more information, please see the Search by RIC - HTTP request section in this tutorial.

meera_c

Thanks for the information! However, I was only able to find information regarding convertion of ISIN to RIC for a single ISIN in one json request. What I would like to know is, if its possible to convert multiple ISIN to RIC using a single json request?

meera_c

Thanks for your help! However i am still facing the same issue, that its not a valid json request.

Christiaan Meihsl

@meera_c, this will work ... up to a point. There are limitations:

The string that contains all the identifiers cannot exceed a length of 50 characters (if it does, an error will be returned).
The output is not configurable, and does not contain the input ISIN. As there are many RICs for an ISIN, you will not be able to easily map your input ISINs to the output RICs.

For ISIN to RIC conversion I would not use InstrumentSearch for more than 1 ISIN.

Christiaan Meihsl

@meera_c, your code generates an array of instruments, but as pointed out by Veerapath, if you want several they should all be in a single string.

This is the request generated by the code in your query:

{"SearchRequest":{"PreferredIdentifierType":"Ric","Identifier":["ISIN1","ISIN2"],"IdentifierType":"Isin"}}

This is what is required:

{"SearchRequest":{"PreferredIdentifierType":"Ric","Identifier":"ISIN1, ISIN2","IdentifierType":"Isin"}}

So the code should be along these lines:

JSONObject searchJSONObject = new JSONObject()
    .put("SearchRequest", new JSONObject()
        .put("IdentifierType", "Isin")
        .put("Identifier", "ISIN1, ISIN2")
        .put("PreferredIdentifierType", "Ric"));

But again, as mentioned in my previous comment, using InstrumentSearch for more than 1 ISIN has severe limitations, I do not recommend using it that way.

EXPLORE OUR SITES