Help

Autosend Student Email

ssaguindel
Rookie

Autosend Student Email

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?

3 Replies
CindyM8
Elite

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

 

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


CM

JanaLerner1
Professional

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
Elite

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


CM