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