Useful Scripts for the Intapp Collaboration and Content Platform

Sometimes, you need to run a script to Bulk Update security on a list of Matters in the ICCP Platform.

Below is a very simple Shell script (runnable on a Mac) which reads a list of Matter Codes in a CSV File, and uses a CURL statement to call onto the ICCP API, updating the Security for each Matter by granting Contribute Access to a group called "ELT" .

Remember to update the XXXXXXX items with your actual values!

counter=0
 
 while IFS=, read -r matterCode
 
 do
 
 Echo "$counter - Setting Security on $matterCode"
 
 curl -X post --header "Content-Type: application/json" --header "Accept:application:json" --header "APIKey: XXXXXXXXXXXXXXXXXXXXX" -d"{'Usernames':['ELT'],'RoleId':'1073741827','Type':'Matter','Code':'$matterCode','SPHostUrl':'https://XXXXXXXXXXXXXXXX.sharepoint.com/sites/Custodian'}" "https://custodian01.repstor.com/api2/Security/GrantAccessByCode"
 
 counter=$((counter+1))
 done < listofcodes.csv
 
 Echo "\n\nCOMPLETE"

The accompanying CSV file, called listofcodes.csv, just needs to contain a list of the Matter Codes which need to be updated, e.g.:

TILD0
 TIMB1
 TIRO2
 TMPM3
 TOMH2
 TONI1
 TOTA2
 TOTA4
 TOWE5
 TRAC4
 TRAV3
 TRIA1
 

Easy!