topic Update Users Table via API in Community Forum

Update Users Table via API

derekwhjones — Wed, 24 Sep 2025 17:36:10 GMT

Is there a way to update parts of the Users table via the PowerSchool API? In particular I want to change the teacherloginid.

I've tried making a PUT to both /ws/schema/table/users and /ws/v1/staff but both give a 405 method not allowed.

Is there something I'm missing or is this table just not modifiable via the API?

Re: Update Users Table via API

JeffG9 — Wed, 24 Sep 2025 18:04:46 GMT

You could do a Quick Import into the Teachers table. I imagine it would be a lot easier.

Re: Update Users Table via API

derekwhjones — Thu, 25 Sep 2025 11:42:57 GMT

Thanks for the quick reply!

Can quick imports be automated? The reason I'm hoping to do it with an API is because the teacherloginid is regularly being set incorrectly for new staff (tilde followed by numbers and letters instead of first.last) and I was hoping to check for this and correct it nightly without any manual intervention. I thought quick imports needed to be done manually through the UI but if not it might work.

Re: Update Users Table via API

JeffG9 — Thu, 25 Sep 2025 12:40:40 GMT

Ah, no they cannot. You can automate some stuff, but I don't think what you are asking about can be. I've attached a pdf about the old autosend/autocomm "hairpin" method, just so you have it.