Pega Constellation: Download excel template

The business has Excel templates for bulk processing. They want users to be able to download a template when they click a Template link and then use that same template for bulk upload.

How can this requirement be implemented in Pega Constellation 25.1? Specifically, how can a user download a predefined Excel template from a link or button in a Constellation application?

Are you uploading the Binary file as a template at first place? Are you using pxParseExcel to parse the data for your bulk upload?

Yes.

  1. Created a binary file with excel template.
  2. Created an activity to download the file:

using this activity able to download the excel. (Tested)

  1. Need to call this activity from the UI. To achieve this, I tried calling the activity from a Data Transform and then invoking that Data Transform on the radio button’s value change event. I also tried the same approach with a checkbox, but neither worked
  2. I need to provide a link to the user so that, when they click it, an Excel template is downloaded automatically.

@suchitad does this help? Import Excel data to case (and show them in Constellation UI) - #23 by MarioM17642831

Able to solve this.. Thanks