Generate and output a CSV file based on the template file and the query for records.
You can process more records compared to “Output CSV”. Instead, there will be many Restrictions.
Some preparations are necessary in advance.
You will need the API key for gusuku. This API key is different from the API token of the Kintone app. The API key for gusuku can be issued and obtained from gusuku Admin.
You need to prepare a template file. For information on how to create a template file, see Excel/PDF Output Template Reference Manual.
In addition, a Kintone app is also needed to save the template. Add an Attachment field in the app you created, and prepare records so there is one record per template in this field.
In Customine customization, you obtain records that save the templates to be applied, and set parameters such as queries to obtain templates and output records with “Output CSV by Query.”
The generated CSV file will be in an uploaded state to Kintone. You can set the result of “Export CSV” by mapping fields such as “Add Record” and setting it as “=$1” to the attachment field.
If multiple sheets are in the template, only the active sheet (the sheet that was open when saving the Excel file) will be output.
Set Gusuku API Key, App, Search Condition, Template Record, Template Field, Charset, and File Name.
Specify the API key for gusuku.
Please note that this is not about the API token of the Kintone app.
Select which app to retrieve the data you want to output from.
Enter the search criteria (query) to obtain the data you want to output.
It is also possible to set the condition to “All records.”
You can choose the order, but processing may be quicker if you do not specify it. If not specified, it will be in ascending order of record ID.
Select the record containing the template file.
If there are no selected records at runtime, it will result in an error.
Select the Attachment field in the “Template Record” that contains the template file.
Only Attachment field can be selected. This parameter does not accept fields that are inside tables.
If no files are attached in the attachment field, an error will occur at runtime.
The file extension of the attached file must be .xlsx. If the file’s extension is other than that, an error will occur at runtime.
Select the character encoding for the output CSV file.
If you select UTF-8, it will be in the without BOM format. This format will cause garbled characters when you open the output file in Excel by double-clicking. To open the file in this format with Excel, you must first launch it with a new file and import it using Excel’s “Import External Data” feature.
Enter the file name to attach to the Attachment field.
Content not expressed in the CSV file, such as figures, images, and cell formatting, will be lost during output.
If the output process does not finish within 10 minutes, it will result in an error.
“Output CSV by Query” has the following limitations: “Output CSV” doesn’t have.
$FOREACH(0..9).)