question

Upvotes
Accepted
3 0 1 4

How can get fetch datagrid fields thru RDP?

Hi,


I'm trying to fetch SH_SAL_RES field thru RDP's api /data/datagrid/beta1/


the body I used is

{

"universe": [

"008560.KS"

],

"fields": [

"SH_SAL_RES"

]

}

and result is


{

"error": {

"code": 218,

"description": "The formula must contain at least one field or function."

}

}


The screenshot for more information is

스크린샷-2023-04-23-174259.png

.


It gives me error.


The python code I'm trying to replicate is


df, err = ek.get_data(

instruments = ['008560.KS'],

fields = ['SH_SAL_RES']

)


Thank you.

eikon-data-apirdp-api#productapirefinitiv-data-platformrdp
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.

@JPGMR

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

@JPGMR

Hi,

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

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
78.8k 250 52 74

@JPGMR

Thanks for reaching out to us.

As I know, the RDP Datagrid endpoint doesn't support real-time fields (SH_SAL_RES) the fields that don't have the TR. prefixed.

You may try another endpoint instead, such as /data/pricing/snapshots/v1/.

https://api.refinitiv.com/data/pricing/snapshots/v1/?universe=/008560.KS&fields=SH_SAL_RES

I used the delayed RIC (/008560.KS) because I don't have permission to access 008560.KS.

The output is:

1682300330764.png

I hope that this information is of help.


1682300330764.png (36.4 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.

Hi,


Thank you for reply. I currently have workspace license and using RDP to fetch data.


I found that it seems snapshot api is not permitted for workspace license.


I'm curios if there is another endpoint which can fetch information.


It's kind of weird that Refinitiv is blocking this RDP api since the data fetching from workspace api is same.

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.