Return column name for "DATE_TIME" inconsistent getting historic prices

When getting historic prices from the RDP API and I include the field "DATE_TIME" in my request sometimes I get back "DATE" in the column names and sometime "DATE_TIME". I assume this is because of intraday vs day and greater intervals but the inconsistency is not great when parsing the data:


1661755012944.png


1661755054333.png




Tagged:

Best Answer

  • nick.zincone
    nick.zincone admin
    Answer ✓

    Hi @gordon.konheiser

    The date format is how the backend service supplies the data and as you observed, is dependent on whether you are requesting for interday vs intraday. Clearly, the intraday you will need the time element. However, there was a design decision to not include the time element within interday as this would be redundant. That being said, you will need account for this when you are processing the response.

Answers

  • hi @gordon.konheiser ,

    If the endpoints you're using are /data/historical-pricing/v1/views/interday-summaries and /data/historical-pricing/v1/views/intraday-summaries/ . The difference in the responses are because the data are retrieved from the different endpoints (interday, intraday).

    If not, could you please provide the endpoint and request body used for further investigation?

  • hi @gordon.konheiser ,

    are you using RD library or RDP libraries to retrieve this data? if so, could you please provide the library used and its version, please?

  • Here you go :


    1661767317281.png