For a deeper look into our Elektron API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
7 3 0 2

i am getting a JSONDecodeError when calling in .FTSE in websockets

i am getting a JSONDecodeError when calling in .FTSE in websockets. This appears to be due to invalid raw json being returned. - i,e we are getting key:value pairs where there is no value. i,e it is blank and does not have null.

Other instruments appear ok like BARC.L

e,g using .FTSE u can see the missing null from ACT_FLAG fields.

"THEO_LHDAT" : null,

"THEO_LLDAT" : null,

"ACT_FLAG1" : ,

"ACT_FLAG2" : ,

"ACT_FLAG3" : ,

"ACT_FLAG4" : ,

"ACT_FLAG5" : ,

"GEN_VAL1" : 6590.10,

"GEN_VAL2" : 7716.74,

Using BARC.L these fields are populated in correct json format using null

"ACT_FLAG1":null,

"ACT_FLAG2":null,

"ACT_FLAG3":null,

"ACT_FLAG4":null ,

"ACT_FLAG5":null

treprdp-apiwebsocketsrrto
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
24.7k 54 17 14

Hello @ranjit.talukdar

This issue is "TREP-1568" issue which has been fixed in ADS 3.2.1

TREP-1568; Invalid JSON if RMTES STRING Contains all NULL Characters
  RMTES_STRING fields in RWF containing all null characters (0x00) would not correctly display in JSON.

This issue occurs when ADS 3.2.0 receives null characters (0x00) for the RMTES string field from Elektron.

It can be occurred with any RICs and any string type Fields that got null string data

(0x00) from Market/Exchange or Feed.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2

we are using TREP 3.2.0

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2

alternatively they should return a least a string encapsulated blank

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
24.7k 54 17 14

Hello @ranjit.talukdar

Referring to this post, this issue has been fixed in ADS 3.2.1 L1. I did a quick test with ADS 3.2.1 L1, .FTSE returns data fine. Please upgrade your TREP to 3.2.1 L1 version.

My example .FTSE data from ADS 3.2.1L1 is shown below:

"THEO_LLDAT": null,
"ACT_FLAG1": null,
"ACT_FLAG2": null,
"ACT_FLAG3": null,
"ACT_FLAG4": null,
"ACT_FLAG5": null,
"GEN_VAL1": 6648.86,
"GEN_VAL2": 7730.28,
"GEN_VAL3": null,
"GEN_VAL4": 7689.57,
"GV1_TEXT": "TRI   ",
"GV2_TEXT": "Pr.Cls",
"GV3_TEXT": null,
"GV4_TEXT": "Of.Cls",
"NM_IND": "      ",
"SEQNUM": null,
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2

thanks - we are planning an uopgrade of the infra but in the mean time an application is pushing to go live before we upgrade using data views.

could you help confirm for me the total list of fids affected by this issue?

many thanks

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2

appreciate if someone can respond on this one and provide a definitive list of the affected fids.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
7 3 0 2

Thanks @Wasin Waeosri

but is it possible to provide a list of these FIDS? or do u mean it can actually affect any fid that might be blank on a particular day/time for whatever reason?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
24.7k 54 17 14

Hello @ranjit.talukdar

I suggest you contact the TREP support team to help you on this ADS's TREP-1568 issue question via the https://my.thomsonreuters.com/ContactUsNew link. Please input "ADS" in the "Select Product" as the picture below:


capture.png (6.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.