Bulk updates to Item Security
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!
Comments