| ... | ... | @@ -22,11 +22,11 @@ By default, two backups configurations are defined, a merged document file conta |
|
|
|
- `name:` Enter the query name from the PowerQuery here (for example `"org.psugIL.PowerSchool.Backup.studentsFull"`)
|
|
|
|
- `kwargs:` _(Optional)_ Use this to define kwargs for the PowerQuery retrieval
|
|
|
|
- `data:` _(Optional)_ Use this to define the data. The example below uses
|
|
|
|
- `header:` _(Optional)_ Use this to re-order or define specific columns to retrieve from the PowerQuery. This is in a dictionary format with the PowerQuery field name on the left and the display name on the right, like so: `"header:" { "first_name": "first", "last_name": "last" }` You can also use this to re-name columns. This is in a dictionary format with the PowerQuery field name on the left and the display name on the right, like so: `"header": [
|
|
|
|
{"field1": "new_field_1"},
|
|
|
|
{"field2": "new_field_2"},
|
|
|
|
{"field3": "new_field_3"}
|
|
|
|
],`
|
|
|
|
- `header:` _(Optional)_ Use this to re-order or define specific columns to retrieve from the PowerQuery. This is in a dictionary format with the PowerQuery field name on the left and the display name on the right, like so: `"header:" { "first_name": "first", "last_name": "last" }` You can also use this to re-name columns. This is in a dictionary format with the PowerQuery field name on the left and the display name on the right, like so: `"header": {
|
|
|
|
"field1": "new_field_1",
|
|
|
|
"field2": "new_field_2",
|
|
|
|
"field3": "new_field_3"
|
|
|
|
},`
|
|
|
|
- `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.
|
| ... | ... | @@ -79,11 +79,11 @@ By default, two backups configurations are defined, a merged document file conta |
|
|
|
"kwargs": {
|
|
|
|
"data": "{\"$q\": \"students.school_abbreviation==CHMS\"}"
|
|
|
|
},
|
|
|
|
"header": [
|
|
|
|
{"field1": "new_field_1"},
|
|
|
|
{"field2": "new_field_2"},
|
|
|
|
{"field3": "new_field_3"}
|
|
|
|
],
|
|
|
|
"header": {
|
|
|
|
"field1": "new_field_1",
|
|
|
|
"field2": "new_field_2",
|
|
|
|
"field3": "new_field_3"
|
|
|
|
},
|
|
|
|
"split": "school_name"
|
|
|
|
}
|
|
|
|
},
|
| ... | ... | |
