This example is for v4.10.0+ and v5.7.0+.
Get the immediate and total membership counts for a group. Convert the arbitrary input JSON to a bean, convert a bean to the output
Config
grouperGshTemplate.membershipCountV1beanInputs.allowWsFromNoOwner = true grouperGshTemplate.membershipCountV1beanInputs.displayErrorOutput = true grouperGshTemplate.membershipCountV1beanInputs.groupUuidCanRun = test\u003AtemplateRunners grouperGshTemplate.membershipCountV1beanInputs.gshTemplate = // grouperGshTemplate.membershipCountV1beanInputs.runAsType = GrouperSystem grouperGshTemplate.membershipCountV1beanInputs.securityRunType = specifiedGroup grouperGshTemplate.membershipCountV1beanInputs.templateDescription = count membership immediate and total of group grouperGshTemplate.membershipCountV1beanInputs.templateName = membershipCountV1 bean inputs
GSH script
//uncomment to compile in eclipse (and last line) // these are standard imports, can be commented out in script but needed in eclipse import java.util.LinkedHashMap; import java.util.Map; import edu.internet2.middleware.grouper.GrouperSession; import edu.internet2.middleware.grouper.SubjectFinder; import edu.internet2.middleware.grouper.app.gsh.GrouperGroovyRuntime; import edu.internet2.middleware.grouper.app.gsh.template.GshTemplateOutput; import edu.internet2.middleware.grouper.app.gsh.template.GshTemplateRuntime; import edu.internet2.middleware.grouper.misc.GrouperStartup; import edu.internet2.middleware.grouper.util.GrouperUtil; import edu.internet2.middleware.grouperClient.jdbc.GcDbAccess; import edu.internet2.middleware.subject.Subject; //public class Test25membershipCountV1beanInputs { public class WsInputBean { private String groupName; public String getGroupName() { return groupName; } public void setGroupName(String groupName) { this.groupName = groupName; } } public class WsOutputBean { private int totalMembershipCount; private int immediateMembershipCount; public int getTotalMembershipCount() { return totalMembershipCount; } public void setTotalMembershipCount(int totalMembershipCount) { this.totalMembershipCount = totalMembershipCount; } public int getImmediateMembershipCount() { return immediateMembershipCount; } public void setImmediateMembershipCount(int immediateMembershipCount) { this.immediateMembershipCount = immediateMembershipCount; } } // public static void main(String[] args) { // // GrouperStartup.startup(); // // GrouperSession gsh_builtin_grouperSession = GrouperSession.startRootSession(); // Subject gsh_builtin_subject = SubjectFinder.findByIdentifierAndSource("mchyzer", "pennperson", true); // GrouperGroovyRuntime grouperGroovyRuntime = new GrouperGroovyRuntime(); // GshTemplateOutput gsh_builtin_gshTemplateOutput = new GshTemplateOutput(); // GshTemplateRuntime gsh_builtin_gshTemplateRuntime = new GshTemplateRuntime(); Map<String, Object> wsInput = gsh_builtin_gshTemplateRuntime.getWsInput(); WsInputBean wsInputBean = GrouperUtil.jsonConvertFromMap(wsInput, WsInputBean.class); String groupName = wsInputBean.getGroupName(); String effectiveQuery = "select count(*) from grouper_memberships_lw_v where group_name = ? and list_name = 'members'"; int effectiveCount = new GcDbAccess().sql(effectiveQuery).addBindVar(groupName).selectList(Integer.class).get(0); String immediateQuery = "select count(*) from grouper_memberships_v where group_name = ? and list_name = 'members' and membership_type = 'immediate'"; int immediateCount = new GcDbAccess().sql(immediateQuery).addBindVar(groupName).selectList(Integer.class).get(0); WsOutputBean wsOutputBean = new WsOutputBean(); wsOutputBean.setTotalMembershipCount(GrouperUtil.intValue(effectiveCount)); wsOutputBean.setImmediateMembershipCount(GrouperUtil.intValue(immediateCount)); gsh_builtin_gshTemplateOutput.setWsOutput(wsOutputBean); // } // //}
Sample WS call
Request
POST https://grouperWs.school.edu/grouper-ws/servicesRest/2.6.0/gshTemplateExec Content-Type: application/json Authorization: sas9f8d7sa9df87asd98f { "WsRestGshTemplateExecRequest":{ "configId":"membershipCountV1beanInputs", "wsInput":{ "groupName":"test:testGroup" } } }
Response
STATUS: 200 x-grouper-resultcode: SUCCESS x-grouper-resultcode2: NONE x-grouper-success: T { "WsGshTemplateExecResult": { "resultMetadata": { "resultCode": "SUCCESS", "resultMessage": "Success for: clientVersion: 4.0.0, configId: membershipCountV1beanInputs, ownerType: null , inputs: null\n, actAsSubject: null, paramNames: \n, params: null", "success": "T" }, "responseMetadata": { "millis": "673", "serverVersion": "4.0.0" }, "transaction": true, "gshValidationLines": [], "gshOutputLines": [], "gshExitCode": 0, "wsOutput": { "totalMembershipCount": 12, "immediateMembershipCount": 10 } } }