Integration

Get Involved. Join the Conversation.

Topic

    Punit Desai
    iCal Expression Quaterly
    Topic posted October 22, 2019 by Punit DesaiGreen Ribbon: 100+ Points, tagged Cloud, Integration, Orchestration, PaaS 
    41 Views, 3 Comments
    Title:
    iCal Expression Quaterly
    Summary:
    Creating a iCal Expression in OIC which occur once in a quarter
    Content:

    Hi,

    I have the following scheduling requirement


    Q1 enddate = 29- Mar
    Q2 enddate = 28-Jun
    Q3 enddate = 30-Sep
    Q4 enddate = 31-Dec

    I want create a iCal schedule for my Integration which runs on the above mentioned date , it cannot be hard coded.

    thanks

    Comment

     

    • Kanchankumar Khedkar

      Hello Punit, 

      From your post, you are trying to schedule the request on every last working day of the quarter. 


      FREQ=MONTHLY;BYMONTH=3,6,9,12;BYDAY=MO,TU,WE,TH,FR;BYMONTHDAY=24,25,26,27,28,29,30,31;BYSETPOS=-1
      The rule is evaluated as follows:
      FREQ=MONTHLY;
      BYMONTH=3,6,9,12  : expand to 3rd, 6th 9th and 12th Month each year.
      BYMONTHDAY=24,25,26,27,28,29,30,31: expand to the 24th till 31st day of each month
      BYDAY=MO,TU,WE,TH,FR: filter by week day, retain only work days/remove weekend days
      BYSETPOS=-1: retain only the last record of the set

      Thus you will have last working day of every Quarter.

      You can test this iCal expression @ http://recurrence-expansion-service.appspot.com/ 
       
      However, I am don't think, OIC supports "BYSETPOS" yet. You can try raising SR to confirmation regarding the same.

    • Kanchankumar Khedkar

      You might have to find a work-around for the issue something like - Create an integration which has all the logic.  Create another integration which is scheduled to run Monthly from 28th till 31st.
      And then decide in this integration whether it is last working day of quarter or not, if it is then invoke previous integration. Please see if this is possible. 

      • Punit Desai

        Hi Kanchankumar,

         

        Thanks for your reply,

        I am considering this approach as a last option. I am looking for a solution if its possible within iCal.

         

        thanks

        Punit