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
- `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"}
......
......