...
Parameters:
sheetId - Google spreadsheet id
sheet (optional) - Optional sheet name to use a specific sheet in the spreadsheet. Defaults to: the first sheet.
env (optional) - The environment to get Kuali Build user data from. Defaults to: 'prod', to use sandbox provide 'sbx'.
filterColumn (optional) - Header name in spreadsheet that contains UH usernames or numbers (replace spaces with _).
sortHeader (optional) - Optional header name (with spaces replaced as _) to sort the returned data by.
Form with integration: https://hawaii-sbx.kualibuild.com/app/builder/#/form/6092f3d40171db001d1e2c17
Integration: https://hawaii-sbx.kualibuild.com/app/builder/#/home/api-integrations/60ef394a6c22e777ffbd6317/edit
App Script (under the kualibld account): https://script.google.com/d/1j8cRYVP29UVW9jfh8HAR8so0uc-NIaLw1j0xVCO2WPphhEdJmYPUrNAi/edit?usp=sharing
Kuali User Integration
Gets spreadsheet data based on the sheetId passed into the integration url as a query parameter. Supplying a filterColumn as a query parameter where the value is the Header name of the column with UH usernames or numbers. With filterColumn passed in, the app script will query Kuali Build's GraphQL API with the UH username or number and add the user's Kuali Build information such as: ID (to use in a Kuali User integration), displayName, email, username, and schoolId to the returned data.
Parameters:
sheetId - Google spreadsheet id.
filterColumn - Header name in spreadsheet that contains UH usernames or numbers (replace spaces with _).
env (optional) - The environment to get Kuali Build user data from. Defaults to: 'prod', to use sandbox provide 'sbx'.
Form with integration: https://hawaii-sbx.kualibuild.com/app/builder/#/form/6092f3d40171db001d1e2c17
Integration: https://hawaii-sbx.kualibuild.com/app/builder/#/home/api-integrations/60cd03b49f1e546cd126c665/edit
App Script (under the kualibld account): https://script.google.com/d/149fkn2ZTEuy0ldQuA3YqlVzly7hEAJ_1jgzk6h-go3fT565T03Vs1mkR/edit?usp=sharing
Generic Sort Integration
Gets spreadsheet data based on the sheetId from query parameter and optionally sort data by a column. You can specify which sheet to use on the spreadsheet by the 'sheet' query parameter with the sheet's name with spaces replaced as _. sortHeader parameter is for the header name with spaces replaced as _ to sort the data by.
Parameters:
sheetId - Google spreadsheet id.
sheet (optional) - Optional sheet name (with spaces replaced as _) to use a specific sheet in the spreadsheet. Defaults to the first sheet.
sortHeader (optional) - Optional header name (with spaces replaced as _) to sort the returned data by.
Integration: https://hawaii-sbx.kualibuild.com/app/builder/#/home/api-integrations/60e60c673ab3ce001d5ecf44/edit
App Script (under the kualibld account): https://script.google.com/home/projects/1Jh7A1TVE6G1Utv_buYf0Gd4uK1aTi9ZuhcOxRhup8B5zOJ-GBM9T0UZo/edit