Update config json parameters authored by Rich Moeller's avatar Rich Moeller
...@@ -22,7 +22,7 @@ By default, two backups configurations are defined, a merged document file conta ...@@ -22,7 +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"`) - `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 - `kwargs:` _(Optional)_ Use this to define kwargs for the PowerQuery retrieval
- `data:` _(Optional)_ Use this to define the data. The example below uses - `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: `"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: `"header": [
{"field1": "new_field_1"}, {"field1": "new_field_1"},
{"field2": "new_field_2"}, {"field2": "new_field_2"},
{"field3": "new_field_3"} {"field3": "new_field_3"}
... ...
......