question

Upvotes
Accepted
msk avatar image
1 ●0 ●1 ●1

RDP data/datagrid/beta1/ BUG misaligned rows

When I query "https://api.refinitiv.com/data/datagrid/beta1/" with fields that have structured layout, the returned result is not aligned properly. The content of columns in each row seems to be linked randomly. A comparaison with excel confirmes the bug. This behaviour can be reproduced on many rics and many fields, so it's probably a bug in the api and not related to the content I am querying.

Example:

m_in = {
universe: ["ACCP.PA"],
fields : ["TR.TPEstValue.calcdate", "TR.TPEstValue.date", "TR.TPEstValue.brokername", "TR.TPEstValue"],
parameters={"SDate": "2022-07-01", "EDate": "2022-07-22"}
}
r = requests.post(url,headers={"Authorization": "Bearer " +TOKEN}, json=m_in)
m_out = json.loads(r.text)
df = pd.DataFrame(m_out["data"], columns=["ric", "calcdate", "date", "brokername", "value"])
df.sort_values(["calcdate", "date"])

The last 5 rows (once converted from json and sorted by calcdate,date)

calcdate    date                brokername                   value
2022-07-22  2022-06-27T03:15:00   Permission Denied 25632    NaN
2022-07-22  2022-06-28T00:05:00    Permission Denied 1120    NaN
2022-07-22  2022-06-28T06:26:00      Permission Denied 32    NaN
2022-07-22  2022-06-30T06:00:00  Permission Denied 398136    NaN
2022-07-22  2022-07-06T06:34:00                  ODDO BHF    NaN

Excel :

=@TR("ACCP.PA","TR.TPEstValue","SDate=2022-07-01 EDate=2022-07-22 RH=calcdate;date;brokername SORTA=calcdate;date")

Last 5 rows (issue is on all rows)

calcdate   date             brokername                value
22/07/2022 27/06/2022 03:15 Permission Denied 25632   38
22/07/2022 28/06/2022 00:05 Permission Denied 1120    33
22/07/2022 28/06/2022 06:26 Permission Denied 32      36
22/07/2022 30/06/2022 06:00 Permission Denied 398136  31
22/07/2022 06/07/2022 06:34 ODDO BHF                  32
rdp
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.

raksina.samasiri avatar image   raksina.samasiri

<AHS>

Case 11450789 is still in progress, extend the triage

aramyan.h avatar image   aramyan.h raksina.samasiri

Case 11450789 is still in progress, extend the triage

aramyan.h avatar image   aramyan.h aramyan.h

Case 11450789 is still in progress, extend the triage

raksina.samasiri avatar image   raksina.samasiri

<AHS>
Case 11450789 is still in progress, extend the triage

wasin.w avatar image   wasin.w

<AHS>

Case 11450789 is still in progress, extend the triage for a month.

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


raksina.samasiri avatar image   raksina.samasiri

<AHS>

https://jira.refinitiv.com/browse/ADC-57499

1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

Hi @msk ,

We've reproduced and can confirm that the issue persists, we're currently contacting the related team regarding this issue and will keep you updated. Thank you for reporting this

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.

raksina.samasiri avatar image   raksina.samasiri

<private comment>

Hi @msk ,

For your reference, here's case number 11450789 which was raised regarding this issue and the issue is being investigated, you will be contacted by the support team soon.

wasin.w avatar image wasin.w

Hello @msk

I have checked case 11450789. The case is closed with the following resolution

Upon collaborating with our Content Specialists and Devs, I was able to confirm that the returned data is correctly aligned.

In the below screenshot, the “output” param value contains (“Col,T|Va,Row,In,date|”)

a1.png

sample response:

a2.png

In a nutshell, we need to add values/parameters to the output to make it a unique record. In this case, we need to add Broker and Analyst

I would also like to add that RDP DataGrid endpoints are still in the beta phase.

Lastly, for the error code that returns Permission Denied, you need to have a specific license added to your logins to gain access to the requested data. You can either reach out to your Refinitiv contact/ Account manager

a1.png (71.9 KiB)
a2.png (112.1 KiB)

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.