Configure an Assembly with the PrismAnalytics Subassembly

To send CSV data to Prism Analytics, your assembly must contain a

PrismAnalytics

component that:

Receives CSV data as input, either in the rootpart of the message or as a variable.

Receives a variable containing a JSON description of the CSV data.

Has a number of parameters configured correctly.

Configure your assembly to obtain a source CSV file or source CSV files. Depending on the method you use to acquire the CSV data, you might need to provide a variable name or set a MIME type.

As you complete the task, consider:

CSV Acquisition Method	Notes
sftp-out component	Specify the CSV filename in the component's Input File Pattern property. You can use wildcards. Use the component's get method to retrieve a single file or its mget method to retrieve multiple files. Studio adds the CSV data to the message rootpart. No variable name is required. Studio automatically sets the MIME type correctly.
Retrieval or listener service	Studio adds the CSV data to a variable. Name the variable using the wd.prism.component.csv.input.varname parameter. Studio automatically sets the MIME type correctly.
Any other method	Studio adds the CSV data to the message rootpart or to a variable. If applicable, name the variable using the wd.prism.component.csv.input.varname parameter. Set the MIME type of the rootpart or the variable to: text/csv plain/csv application/zip

Create a text message on the

Message Builder

tab of a

write

step and add the JSON text that describes the data. Output a variable. Example:

temp.schema

You can add the JSON text directly to the

Message Builder

. Alternatively, you can write it in the tool of your choice and paste it in.

Configure the

PrismAnalytics

component's parameters:

Parameter	Description
wd.prism.component.schema.varname	The variable containing the JSON schema that describes the data.
wd.prism.component.table.name	The name of the Prism table. Table names: Must be unique in the Data Catalog. Can contain up to 255 characters. Can only include alphanumeric and underscore characters. Must start with a letter. Can't end with an underscore character.
wd.prism.component.client.id	The Client ID assigned to the API client by Workday. Access the View API Clients report, then view the API Clients for Integrations tab.
wd.prism.component.client.secret	The Client Secret assigned to the API client by Workday. Access the View API Clients report, then view the API Clients for Integrations tab.
wd.prism.component.refresh.token	The Refresh Token assigned to the API client by Workday. Access the View API Clients report, then view the API Clients for Integrations tab.
wd.prism.component.operation	The operation performed on the Prism table. Replace is the only option currently supported. It creates a table or replaces one of the same name.
wd.prism.component.csv.input.varname	(Optional.) The variable containing the CSV input. Not required if you're adding the CSV data to the message rootpart. Studio doesn't automatically select this parameter for inclusion when you add a PrismAnalytics component to an assembly. Select it manually if required or add it later on the component's Parameters tab.
wd.prism.component.table.description	(Optional.) A description for the table. Can contain up to 255 characters.
wd.prism.component.table.description.display.name	(Optional.) The display name for the table. Can contain up to 255 characters.
wd.prism.component.table.field.varname	(Optional.) Defines a Prism table. Write the definition to a variable then pass it to this parameter using vars['variable-name’].

Deploy and launch the integration.