API - global_id and AllowWebAccess

[FIMTooler]

We're using the PowerSchool hosted cloud solution.

Questions:

1. Is it possible to update a student's global_id and AllowWebAccess fields with an API call?
2. Can both global_id and AllowWebAccess fields be included in the results of a student record using either the v1 or table endpoints?

Details:

global_id is included with a student record queried via the v1 interface.  However when I send an update the response contains "warning" and "NON_UPDATEABLE" for "student/global_id".

AllowWebAccess is not included when student is queried via the v1 interface.  However if you query the student table ("ws/schema/table/students"), a value is returned, but there is no global_id.

Per https://support.powerschool.com/developer/#/page/data-dictionary#student, the global_id is from another table - PCAS_ExternalAccountMap.OpenIdUserAccountID.  From other posts I've seen, most "PCAS" tables\fields are not updatable.  Admittedly, I have not tried updating this via the table endpoint.

I'm currently querying all students within the district (ws/v1/district/student) and would really prefer to use a single endpoint to update student records, such as "ws/v1/student".

Although doable, it would be a big hassle to query students via both the v1 and table endpoints.  Same with writing back AllowWebAccess.  In addition to the code to query multiple endpoints and "join" the records together, I would also need to keep track of which endpoint to use per field when updating a student.



Side Note:  The row in the table for global_id is missing the "Actions Supported" column and the rest of the columns are not aligned properly. - https://support.powerschool.com/developer/#/page/data-dictionary#student

[NinaRi]

Hi @FIMTooler,

Thank you for posting in the PowerSchool Community! Currently, PowerSchool does not have a customer facing API to update these two values. They would need to be updated in the PowerSchool interface.

However, this is a great Enhancement Request that you can submit to the Product Engineers to review.  You can submit a request on our Feature Ideas Portal here. 

Please let us know if you have any questions. 

[FIMTooler]

Is there any other way to update these fields through some automated process without manual user intervention?

I've heard the terms Autocomm and Data Import Manager.  I've been told that Autocomm supports the AllowWebAccess field to be updated, but that Global ID is only "accessible for manual update via data import manager".  

I'm a very competent consultant but, I'm not familiar with PowerSchool at all.  Thus I don't know what Autocomm and Data Import Manager are, how each of them works, pros/cons of each.

[NinaRi]

Hi @FIMTooler,

You can update those fields using AutoComm or Data Import Manager. Here are a few articles here and here that explain the two different functions.  You want to make sure you are working with a Technical Support Contact within  the School District you are working with to view this documentation. 

Also, here’s a thread you may be able to access where other members are discussing a similar topic and can provide more insight on the pros and cons of each.

Please let us know if you have any more questions. We will be happy to help!

[RobertS7]

Please vote: SIS-I-13698 

[RolandP]

I agree, please go here https://help.powerschool.com/t5/PowerSchool-Ideas-Portal/ct-p/PowerSchool-Ideas-Portal and search for SIS-I-13698 (Thanks RobertS7) and vote!

This is a much needed feature.