...
Generic google app script that pulls data from any specified spreadsheet. If none of the optional parameters are provided, the script will grab all the sheet's data like normal.
Kuali Build Integration url endpoint: https://script.google.com/macros/s/AKfycbwTdQX6BcX-su8ZXwGd9PozxJci94c-mpJ4yjwBhQrr7zjNuljAg8nCQayGi8AMRoHAGA/exec
Google App Script Name (under the kualibld account): Generic Script
If none of the optional parameters are provided, the script will grab all the sheet's data like normal.
Parameters
| Parameter Name | Required | Description | Valid Values | Default |
|---|---|---|---|---|
| sheetId | Y | Google spreadsheet id | ||
| sheet | N | Sheet name to pull data from a specific sheet in the spreadsheet | first sheet | |
| env | N | The environment to get Kuali Build user data from |
| prod |
| filterColumn | N | Column header name that will be used to lookup the Kuali User record using the GraphQL API. The json will include the specified user's Kuali user ID, displayName, email, username, and schoolId. |
| UH_Number |
| sortHeader | N | Column header name to sort the returned data on |
...