get_data returning only 1 row even after adding start date and end date

in Excel have data for all dayes. Python api get_data giving only 1 data record.

Same result after adding start and end date.


image

Best Answer

  • Hi @bibin.jose,

    History is not captured for every field available. For example, you are requesting for CF_BID which is a realtime field coming from the realtime database. Instead, you will want to find which fields history is available within the Data Item Browser. For example, I requested for this simple query for bid value and the date of the bid:

    image

    Within the Data Item Browser, you can find the fields that may suit your requirements and determine which one has historical values.