Connecting PowerSchool Data to Google Sheets Part 3: Set the PowerQuery to API Mode
Google Apps Script, PowerSchool, PSUGS, PowerQueries, API, TheKitchenSink
If you need to learn how to install the Plugin and test it, go back to Part 2.
Step 1: Add the Access Elements to the “plugins.xml” File
This is where most people make mistakes. In this example, the work is easy. When you create more complex PQs for API usage (PQ-APIs), you need to remember this rule: Every table and field you need to use (not show just access and use) must have permissions set. If you need the StudentID to connect to a field in another table, but you are not showing the StudentID, it still needs permission.
You want to select from name= to “Jim Parsons”> and paste.
name="PowerQuery Example (Birthdays)"
version="1.0">
<oauth></oauth>
<access_request>
<field table="STUDENTS" field="STUDENT_NUMBER" access="ViewOnly" />
<field table="STUDENTS" field="LASTFIRST" access="ViewOnly" />
<field table="STUDENTS" field="GRADE_LEVEL" access="ViewOnly" />
<field table="STUDENTS" field="DOB" access="ViewOnly" />
<field table="STUDENTS" field="ENROLL_STATUS" access="ViewOnly" />
</access_request>
<publisher name="Jim Parsons">Save the file, and and make a new ZIP. You need to repeat the process of uploading the plugin, and when prompted, simply agree to update it and ignore the version warning. This was covered in Part 2.
Step 2: Enable the API Access for the Plugin
Go into, “Plugin Management Dashboard” and click on the Birthday Plugin.
Click “Data Provider Configuration”
Copy the Client ID and Client Secret to a text file and set the page size to 1000 (we will not actually need the page size for this example, but you might in the future).
When you are done click “Submit”
Now we need to collect one more string of data. Before you exit the PowerQuery details, expand the “Permission Resources” and copy, “org.psugcal.example.students.birthdays”
Save that with the keys in the same file.
This is the end of the plugin setup and prep work. :)
Get the Google Code and do Part 4
Copyright © Domain Seven LLC. All rights reserved.
For permissions to use or share any content behind our paywall, please email us at: tonydeprato@domain7.tech .
