| ... | ... | @@ -29,12 +29,12 @@ By default, two backups configurations are defined, a merged document file conta |
|
|
|
},`
|
|
|
|
- `split:` Use this to split the output into multiple files based on one of the columns in the output. Use the display name defined in the header section if you defined one, otherwise use the PowerQuery field name. This is defined using a list format, like so: `
|
|
|
|
"split": [ "school_abbreviation", "grade_level" ]`
|
|
|
|
- `google:` _(Optional)_ Use this to configure your the file properties if you will be uploading the documents to Google Drive.
|
|
|
|
- `google:` _(Optional)_ Use this to configure the file properties if you will be uploading the documents to Google Drive.
|
|
|
|
- `file:` Define the file name here. If you used a split, the value in the column(s) you are splitting on will be prepended to the file name.
|
|
|
|
- `sheet:` _(Only if type of "sheet")_ Name of the tab for the sheet in the file to insert the data.
|
|
|
|
- `clear:` _(Only if type of "sheet")_ Boolean true or false if the sheet should be cleared prior to upload. _Note: Do not surround true or false with quotation marks here._
|
|
|
|
- `ref:` _(Only if type of "sheet")_ Enter the cell reference to begin inserting the data in the sheet. Normally "A1".
|
|
|
|
- `local:`
|
|
|
|
- `local:` _(Optional)_ Use this to configure the file properties if you will be creating a local document file in DOCX or XLSX format.
|
|
|
|
- `file:` Name of the DOCX (for type of `"mergedoc"`) or XLSX (for type of `"sheet"`) file for the file output.
|
|
|
|
- `sheet:` _(Only if type of "sheet")_ Name of the tab for the sheet in the file to insert the data.
|
|
|
|
- `clear:` _(Only if type of "sheet")_ Boolean true or false if the sheet should be cleared prior to upload. _Note: Do not surround true or false with quotation marks here._
|
| ... | ... | |
