Loyalty and Rewards

Loyalty and rewards templates let you create and update rewards in bulk by ingesting reward data from an FTP or SFTP location on a schedule. Each template provides a pre-configured block sequence for a specific loyalty or rewards use case. You select a template, configure the block details for your environment, and deploy the dataflow.

The following templates are available for loyalty and rewards.

Create rewards

Use this template to create or update rewards in bulk from a source file. The template reads reward records from a CSV file, maps each record to the reward schema, and calls the Capillary reward creation API for every record.

Use case

A brand preparing a seasonal loyalty campaign needs to load hundreds of new rewards into its catalog before the campaign goes live. The reward details are exported from the brand's merchandising system to a CSV file. This template reads the file, transforms each row into the reward format, and creates every reward in a single scheduled run.

The template runs seven blocks in sequence: it reads the source file over SFTP, decrypts the content, converts the CSV rows to JSON, applies two transforms to map the data to the reward schema, filters out header or invalid rows, and posts each reward to the reward creation API.

Block configuration

The following table lists the blocks in the Create rewards template, describes what each block does, and provides the configured values for each field.