Null result on GDP API R Timeseries request

Question

question

economics01

1 ●0 ●0 ●1

Null result on GDP API R Timeseries request

Hi all!

I'm trying to pull some GDP time series data (RIC: aIDCGDPPD/A) in R using the eikonapir package. However, my request is returning null values (see below). I have a feeling this is because something in my request is incorrect, but I can't figure out what. Can

The 'ECONOMIC.Timestamp' and 'ECONOMIC.Value' fields are taken from my search in the Excel formula builder. Can anyone tell me whats wrong?

> GDPqq <- eikonapir::get_timeseries("aIDCGDPPD/A", 
                                   start_date='2020-01-02T15:04:05-07:00',  # start date
                                   end_date='2022-06-06T15:04:05-07:00', # end date
                                   fields=list('ECONOMIC.Timestamp', 'ECONOMIC.Value'),
                                   interval = "quarterly",
                                   debug = T)
[1] "Request *************************************"
{"Entity":{"E":["TimeSeries"],"W":{"rics":[["aIDCGDPPD/A"]],"fields":[["ECONOMIC.Timestamp"],["ECONOMIC.Value"]],"interval":["quarterly"],"startdate":["2020-01-02T15:04:05-07:00"],"enddate":["2022-06-06T15:04:05-07:00"]}}} 
[1] "Response *************************************"
[1] "{\"timeseriesData\":[{\"dataPoints\":[[null,null],[null,null],[null,null],[null,null],[null,null]],\"fields\":[{\"name\":\"ECONOMIC.Timestamp\",\"type\":\"\\u003cnil\\u003e\"},{\"name\":\"ECONOMIC.Value\",\"type\":\"\\u003cnil\\u003e\"}],\"ric\":\"aIDCGDPPD/A\",\"statusCode\":\"Normal\"}]}"
[1] "Response status *************************************"
[1] 200

eikon refinitiv-dataplatform-eikon workspace workspace-data-api api eikon-data-api-r

Jun 23, 2021 at 02:00 AM

10 |1500

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

wasin.w Jul 06, 2021 at 03:46 AM

Hello @economics01

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,

AHS

Jirapongse Jul 13, 2021 at 05:01 AM

@economics01

Hi,

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

Thanks,

AHS

Answer 1 · 2021-06-23T07:55:18Z

Jirapongse

78.8k ●250 ●52 ●74

@economics01

The get_timeseries method can be used to only retrieve "default" historical view data.

Typically, it returns the OPEN, HIGH, LOW, CLOSE fields.

Please share the formula created by the Excel formula builder to retrieve the 'ECONOMIC.Timestamp' and 'ECONOMIC.Value' fields.

1624433904849.png (34.1 KiB)

Jun 23, 2021 at 07:55 AM

10 |1500

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

Jirapongse Jun 23, 2021 at 09:08 AM

@economics01

The code should look like this:

GDPqq <- get_timeseries("aIDCGDPPD/A", 
           start_date='2020-01-02T15:04:05-07:00',  # start date
           end_date='2022-06-06T15:04:05-07:00', # end date
           fields=list('*'),
           interval = "quarterly")
GDPqq

The output is:

1624439291165.png (40.9 KiB)

Answer 2 · 2021-06-23T08:42:12Z

chavalit-jintamalit

18.2k ●21 ●13 ●21

Hi @economics01

You can add interval = 'quarterly' parameter in your request and remove the field name (to get all available fields)

ahs1.png (26.3 KiB)

Jun 23, 2021 at 08:42 AM

10 |1500

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

Q&A Forum

question

Null result on GDP API R Timeseries request

2 Answers

Write an Answer

question

Null result on GDP API R Timeseries request

2 Answers

Write an Answer

Related Questions