Skip to main content
A
anupams0001
February 2, 2022
Question

Bulk Update in Calendar using Calendar IO

  • February 2, 2022
  • 2 replies
  • 0 views

Hi 

My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 3, 2022

    Please post node configurations and expression code. That iteration you mention, is that MNI or a foreach?

    A
    anupams0001Author
    February 3, 2022

    Hi 

    This excel_data is the data subset which is the data from excel sheet. And i am able to parse this data subset and i can extract the date and update type (working and non working days).

    This foreach loop . In this i am trying to read the each row in the excel sheet. And i am parsing it to the expression rule and MNI is also enabled in the import appian calendar smart service. Also this rule works fine for just the first row It updates the first row in the calendar but it doesnt update the  next rows.

    Terms & ConditionsAccessibility statement