API result fields in a different order

Harold.Alfaro · August 28

Hello Team,

A client is asking why the instruments and fields received from an extraction, in some case they are shuffled or in a different order as when the API was made.

Example:

API call sent with MXN=, EUR=, GBP=, COP= in this order, and the results came back with GBP=, MXN=, EUR=, COP=

Thanks in advance!

Gurpreet · August 28

Hello @Harold.Alfaro

The question isn't clear - are you referring to multiple calls, one for each instrument, or a single API call with multiple instruments. Please share the API call details,

Harold.Alfaro · August 29

https://community.developers.refinitiv.com/discussion/comment/127617#Comment_127617

Hi Gurpreet, sorry if it wasn´t clear enough.

It´s a single API call with multiple instruments where the call was sent with the instruments in a specific order and when the results came back, they were in a different order.

Same thing with the fields… Let´s say I send an API call with the following fields in this order: Instrument ID, Trade Date, Close Price, and when the results came back it shows Trade Date, Instrument ID, Close Price.

Hope this clarifies.

Gurpreet · August 29

Since you haven't posted the API call, I presume that you are using the IdentifierList with multiple InstrumentIdentifiers. The data from identifiers might be in different order, since there might be multiple rows of data associated with each. I tried a quick test with the TimeAndSales ExtractionRequest, and see that the field order was preserved.

If there is a request to change the message structure, you should raise it up to the product team for the product enhancement.

Harold.Alfaro · August 29

https://community.developers.refinitiv.com/discussion/comment/127630#Comment_127630

Here is an example

From what you are saying, the system will retrieve the data as it is found in the server and not how it is requested in the API call. Am I correct?

Gurpreet · September 2

https://community.developers.refinitiv.com/discussion/comment/127633#Comment_127633

I tried the exact request message, and received the fields and instruments in the order as requested. What is the response message that you are getting?

Either way, trying to rely on the order while extracting data for an instrument would be a poor programming choice. The app should get the instrument name from the response JSON object, and then extract the pricing data from that same object.

Harold.Alfaro · September 3

https://community.developers.refinitiv.com/discussion/comment/127679#Comment_127679

Thank you, Gurpreet!

No error or warning messages in the extraction notes.

I think I was able to figure out the client´s request… There are two legacy RICs that are not current and those are the ones showing in a different order.

API results put those RICs (HKR= and VEF=) at the end of the results when in fact they aren´t at the moment of submitting the request.

The reason for those instruments moved to the end, is because there is no current data available? Can you confirm?