To update a PWYW schedule you will be

  1. Getting a list of instances using the event template ID, and converting that to a CSV
  2. Updating the CSV to insert the new times for the PWYW schedule
  3. Creating a new postman call, and using it to
  4. Update the instances with the new data


A new base PUT call must be made for each client and event template, since that is unique to each event and most of the data is unchanging from instance to instance. Please work with Kadee or Jesse to confirm that the PUT call in step 3 is formatted correctly before completing this process.


Step 1: Getting a list of instances using the event template ID, and converting that to a CSV

  1. Get template ID from Backoffice and confirm the farthest date out that needs to be modified
  2. Start a session in Postman
  3. Open "Get Event instances for template ID"
    1. Update parameters to include event range start date in startTime, end range end date in endTime, and template ID
    2. Run
    3. Save as a JSON
  4. Using https://www.convertcsv.com/json-to-csv.htm
    1. Choose file
    2. Select UTF-8 as the encoding
    3. Skip step 2
    4. Click convert to CSV
    5. Download result

Step 2: Updating the CSV to insert the new times for the PWYW schedule

  1. Open the file in excel
  2. Find column heading "flexPays/0/startTime"
    1. Copy the column into a new sheet tab
    2. Using find and replace, change the time (T##:##:##-##:##) to the new start time in UTC
      1. eg: T11:00:00-04:00 changes to T00:00:00-04:00
    3. Paste it back over the original column
  3. Find column heading "flexPays/0/endTime"
    1. Use the same process to change to the new end time
    2. Paste it back over the original column
  4. Save the changes, keeping the file as a CSV

Step 3: Make New postman call

  1. open Event Script collection and open the edit event instance script template call
  2. Open get eventinstance call
  3. get an instance ID from backoffice, run the event instance get call for that ID
  4. copy the response, paste the response into the body of the template
  5. Alter the body to change certain fields to be a dynamic variable. Always change the following
    1. the first line to: "id": "{{id}}
    2. Start date
    3. end date
    4. flex pay start and end
    5. any other values you edited in the prior step
    6. save changes.

Step 4: Update the instances with the new data

  1. Confirm your env and session are both pointing to Prod (or the correct env)
  2. Next to the "Event Scripts" Collection, click the menu and select run collection
  3. unselect the template, and leave the new call you made selected
  4. Upload your file; the number of iterations will update automatically
  5. open advanced setting, select save responses
  6. Click run
  7. Confirm that you get 200 OK responses, spot check any 400 Bad Request lines as needed