Kuali Form Managers
Gets all OnBase document type configurations a user has access to, to supply Kuali Build to OnBase Document Type configuration form.
Configuration form: https://hawaii-sbx.kualibuild.com/app/builder/#/form/6035ce2d31df9a001faf668e
Integration: https://hawaii-sbx.kualibuild.com/app/builder/#/home/api-integrations/60bebd6213af54001f21955a/edit
App Script (under the kualibld account): https://script.google.com/d/1UEy4ZUmhbcrihGYVoak9-LEZjK_V2aVQZjJmak4edkz_FtLL3qjJ6Jzz/edit?usp=sharing
Merged Integrations (Kuali User & Generic Sort)
Gets spreadsheet data based on the 'sheetId' passed into the integration url as a query parameter. To specify which sheet to use add a query parameter 'sheet' and giving the sheet's name, this defaults to first sheet if nothing is supplied. 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. Optionally, sort the data by a column in a query parameter 'sortHeader' with the header name of the column specified.
If none of the optional parameters are provided, the script will grab all the sheet's data like normal.
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