InstrumentListsImportFromBytes request example

filip.balas
filip.balas Explorer
in DSS

Hello,

I can't get /Extractions/InstrumentListsImportFromBytes working. Geting 400 Bad request all the time. I was not able to find any example for this method - example request would be helpful I guess.

API documentation says byte[] but there's no encoding mentioned, so I've asumed Base64. Here's my request:

{"FileBytes":"XXX==","Settings":{"ImportCreatedUserInstrumentsIntoList":true,"PredefinedAction":"Add","AllowDuplicateInstruments":true,"PredefinedName":"2016_09_13_09_47_39_tr_instrumentList.csv","ImportUserInstruments":true},"FileName":"2016_09_13_09_47_39_tr_instrumentList.csv"}

I was refering to this source:

https://hosted.datascopeapi.reuters.com/RestApi.Help/Context/Operation?ctx=Extractions&ent=InstrumentList&opn=ImportFromBytes

Thanks for any remarks.

Filip

Tagged:

Best Answer

Answers

  • Christiaan Meihsl
    Christiaan Meihsl LSEG

    FileBytes must be in Base64 format.

    If it is not (like XXX===) you will get the following error:

    System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.

  • filip.balas
    filip.balas Explorer

    Resolved. Thank You for the answers.

    Using Veerapath's working request I was able to find that the issue elsewhere.

    There's a typo in the API documentation:

    /Extractions/InstrumentListsImportFromBytes vs

    /Extractions/InstrumentListImportFromBytes

    I should have read the response more carefully.

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    https://community.developers.refinitiv.com/discussion/comment/8423#Comment_8423

    Thank you for pointing this out. The typo issue has been escalated to the relevant team.

  • Christiaan Meihsl
    Christiaan Meihsl LSEG

    @filip.balas

    Just a few additional thoughts:

    Using this call you are storing an instrument list on the DSS server, permanently (well, until you decide to modify or delete it). This is mainly useful if you want to re-use the list later on. Storing an instrument list on the DSS server can be done in other ways, there are some examples in the tutorials here, in particular the REST API Tutorial 8 and the .Net SDK tutorial 2.

    Depending on your use case, storing the list on the DSS server might not be required. Using On Demand queries you can pass the instrument list as a parameter, without storing it on the server. On Demand queries hide some of the complexity in the background, making you coding easier. To see examples of how that can be done, again refer to the tutorials here, in particular the REST API Tutorials 2 & 7, and the .Net SDK tutorials 6 & 7.

    The best choice depends on what you are trying to achieve.

  • Troy Dalldorf
    Troy Dalldorf LSEG

    Not including import and export examples was an oversight on our part. We have scheduled to include these examples in the 10.8 release.

  • filip.balas
    filip.balas Explorer
    https://community.developers.refinitiv.com/discussion/comment/8426#Comment_8426

    Exactly crossed my mind when I moved to Extraction part. Thank You.

Categories