topic Re: Autosend Student Email in Community Forum

Autosend Student Email

ssaguindel — Mon, 29 Jan 2024 18:45:00 GMT

I am trying to set up Autosend our students' contact info, specifically the email field to a vendor's SFTP server, but cannot find the correct "[table].field" to place in the list of fields. Data export manager shows the student contact fields that I need, but I need this done nightly through SFTP.

Does anyone know the [table-name].field-name to use in the Autosend feature?

Re: Autosend Student Email

CindyM8 — Mon, 29 Jan 2024 19:06:30 GMT

There is a PowerQuery DAT you can use for sending the student email:

~(*powerquery;query=com.powerschool.core.dats.students.student_email)

Re: Autosend Student Email

JanaLerner1 — Mon, 29 Jan 2024 19:35:30 GMT

Hi, Cindy. I have another question sort of related to this. We would like to use the first contact in unlimited contacts on a custom screen. I was told I would need to use a power query but I've never done that before. Can you please give me an example of a power query that would pull data onto a custom screen? Thank you so much!

Re: Autosend Student Email

CindyM8 — Mon, 29 Jan 2024 19:38:49 GMT

Hello, you might find the developer resources on PowerQuery helpful:

https://support.powerschool.com/developer/#/page/powerquery-dat

And check out episode 125 of the Insider:

https://help.powerschool.com/t5/Insider-Videos/PowerSchool-Insider-Episode-125-September-9-2022/ta-p/402870