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 must be UH Username, Email, or UH Number (with spaces replaced as _). Defaults to: UH_Number
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