Autosend Student Email

[ssaguindel]

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?

[CindyM8]

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

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

[JanaLerner1]

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!

[CindyM8]

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...