Mail Merge with Data File (Single Doc)

Use this action in generating document by merging a template file and a file containing data. The template can be in word format, containing mail merge fields, or PDF containing form fields. This action generates only a single document

The file containing data can be either in excel format or JSON format.

Parameters

Template FileFile, Required

Document template file. Supported file formats are Word and PDF files

Template File TypeOptions, Required

Template file type. This field helps in defining the template type of the file. The available options are Word and PDF.

Template File NameString

Name for the Template file. Also the name to be given to the list of generated files

Merge Data FileFile, Required

File containing data for template. This can be excel or json file.

Sample Excel Data:
excel sample

Sample Json Structure (List Array):
[[“FieldName1”,”FieldName2”,”FieldName3”], [“FieldValue1”,”FieldValue2”,”FieldValue3”]].

json array

(OR)

Sample Json Structure (List Object):
json array

File Type of DataOptions, Required

Type of file given for containing data. The available options are Excel and Json

Output

FileUrl

The file contains the generated document. The output file type depends on the template type.

File NameString

File Name without extension

Full File NameString

File Name with extension

File ExtensionString

File extension