... | ... | @@ -22,8 +22,7 @@ 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
|
|
|
- `headers:` _(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" }`
|
|
|
- `headers (renaming option)` _(Optional)_ 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: `"headers (renaming option)": [
|
|
|
- `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: `"headers (renaming option)": [
|
|
|
{"field1": "new_field_1"},
|
|
|
{"field2": "new_field_2"},
|
|
|
{"field3": "new_field_3"}
|
... | ... | @@ -80,12 +79,7 @@ By default, two backups configurations are defined, a merged document file conta |
|
|
"kwargs": {
|
|
|
"data": "{\"$q\": \"students.school_abbreviation==CHMS\"}"
|
|
|
},
|
|
|
"headers": [
|
|
|
"field1",
|
|
|
"field2",
|
|
|
"field3"
|
|
|
],
|
|
|
"headers (renaming option)": [
|
|
|
"header": [
|
|
|
{"field1": "new_field_1"},
|
|
|
{"field2": "new_field_2"},
|
|
|
{"field3": "new_field_3"}
|
... | ... | |