0 Replies Latest reply: Dec 26, 2016 9:22 PM by james eckstein RSS

    Looping through dates in API call.

    james eckstein

      I have a load statement like this

       

      Data:

      Load

           Dim_1,

           Dim_2,

           Met_1,

           Met_2

      From

      [

      [http://localhost:5526start-date%3d  yesterday  %26end-date%3d  today  %26metrics

      (qvx);

       

      I need to make yesterday and today variables and loop them through the following date range.

       

      2015-08-31 through today 2016-12-26.

       

      The variables need to be in these date format YYYY-MM-DD.

       

      so

      the 1st pull should be                     yesterday=2015-08-31 today=2015-09-01

      the 2nd pull should be                    yesterday=2015-09-01 today=2015-09-02

      the 3rd pull should be                     yesterday=2015-09-02 today=2015-09-03

       

      this pattern should continue until      yesterday=2016-12-25 today=2016-12-26

       

      Thanks in advance.