Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequest', @resp OUT, 'POST', '=true'
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
RETURN
END
DECLARE @sbResponseBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "additionalLabel": "Private With Customers",
-- "announcement": null,
-- "bannerPhoto": {
-- "bannerPhotoUrl": "https://<my_domain>/profilephoto/0F9/B",
-- "bannerPhotoVersionId": null,
-- "url": "/services/data/v58.0/chatter/groups/0F9.../banner-photo"
-- },
-- "canHaveChatterGuests": true,
-- "community": null,
-- "description": "Created via API",
-- "emailToChatterAddress": "0F9...@post.2o-i6mbeaq.eu25.chatter.salesforce.com",
-- "fileCount": 0,
-- "id": "0F9...",
-- "information": {
-- "text": null,
-- "title": null
-- },
-- "isArchived": false,
-- "isAutoArchiveDisabled": false,
-- "isBroadcast": false,
-- "lastFeedElementPostDate": "2023-11-22T11:29:05.000Z",
-- "memberCount": 1,
-- "motif": {
-- "color": "1B96FF",
-- "largeIconUrl": "/img/icon/groups64.png",
-- "mediumIconUrl": "/img/icon/groups32.png",
-- "smallIconUrl": "/img/icon/groups16.png",
-- "svgIconUrl": null
-- },
-- "myRole": "GroupOwner",
-- "mySubscription": {
-- "id": "0FB...",
-- "url": "/services/data/v58.0/chatter/group-memberships/0FB..."
-- },
-- "name": "New Chatter Group (Private Access)",
-- "owner": {
-- "additionalLabel": null,
-- "communityNickname": "User1696423780773910041",
-- "companyName": "Salesforce",
-- "displayName": "Name",
-- "firstName": "Firstname",
-- "id": "005...",
-- "isActive": true,
-- "isInThisCommunity": true,
-- "lastName": "Name",
-- "motif": {
-- "color": "1B96FF",
-- "largeIconUrl": "/img/icon/profile64.png",
-- "mediumIconUrl": "/img/icon/profile32.png",
-- "smallIconUrl": "/img/icon/profile16.png",
-- "svgIconUrl": null
-- },
-- "mySubscription": null,
-- "name": "Name",
-- "outOfOffice": {
-- "message": ""
-- },
-- "photo": {
-- "fullEmailPhotoUrl": "https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0IogXzXAXaYKJnuWCNQmXymRq?fromEmail=1",
-- "largePhotoUrl": "https://<my_domain>/profilephoto/729.../F",
-- "mediumPhotoUrl": "https://<my_domain>/profilephoto/729.../M",
-- "photoVersionId": "729...",
-- "smallPhotoUrl": "https://<my_domain>/profilephoto/729.../T",
-- "standardEmailPhotoUrl": "https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0Ioi-dtynkoFWsl46as__TDFU?fromEmail=1",
-- "url": "/services/data/v58.0/connect/user-profiles/005.../photo"
-- },
-- "reputation": null,
-- "title": null,
-- "type": "User",
-- "url": "/services/data/v58.0/chatter/users/005...",
-- "userType": "Internal"
-- },
-- "pendingRequests": 0,
-- "photo": {
-- "fullEmailPhotoUrl": "https://<my_domain>/img/userprofile/default_group_profile_200_v2.png?fromEmail=1",
-- "largePhotoUrl": "https://<my_domain>/profilephoto/0F9/F",
-- "mediumPhotoUrl": "https://<my_domain>/profilephoto/0F9/M",
-- "photoVersionId": null,
-- "smallPhotoUrl": "https://<my_domain>/profilephoto/0F9/T",
-- "standardEmailPhotoUrl": "https://<my_domain>/img/userprofile/default_group_profile_45_v2.png?fromEmail=1",
-- "url": "/services/data/v58.0/chatter/groups/0F9.../photo"
-- },
-- "type": "CollaborationGroup",
-- "url": "/services/data/v58.0/chatter/groups/0F9...",
-- "visibility": "PrivateAccess"
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @additionalLabel nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @additionalLabel OUT, 'additionalLabel'
DECLARE @announcement nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @announcement OUT, 'announcement'
DECLARE @BannerPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @BannerPhotoUrl OUT, 'bannerPhoto.bannerPhotoUrl'
DECLARE @BannerPhotoVersionId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @BannerPhotoVersionId OUT, 'bannerPhoto.bannerPhotoVersionId'
DECLARE @v_Url nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Url OUT, 'bannerPhoto.url'
DECLARE @canHaveChatterGuests int
EXEC sp_OAMethod @jResp, 'BoolOf', @canHaveChatterGuests OUT, 'canHaveChatterGuests'
DECLARE @community nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @community OUT, 'community'
DECLARE @description nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'description'
DECLARE @emailToChatterAddress nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @emailToChatterAddress OUT, 'emailToChatterAddress'
DECLARE @fileCount int
EXEC sp_OAMethod @jResp, 'IntOf', @fileCount OUT, 'fileCount'
DECLARE @id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @id OUT, 'id'
DECLARE @Text nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Text OUT, 'information.text'
DECLARE @Title nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Title OUT, 'information.title'
DECLARE @isArchived int
EXEC sp_OAMethod @jResp, 'BoolOf', @isArchived OUT, 'isArchived'
DECLARE @isAutoArchiveDisabled int
EXEC sp_OAMethod @jResp, 'BoolOf', @isAutoArchiveDisabled OUT, 'isAutoArchiveDisabled'
DECLARE @isBroadcast int
EXEC sp_OAMethod @jResp, 'BoolOf', @isBroadcast OUT, 'isBroadcast'
DECLARE @lastFeedElementPostDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @lastFeedElementPostDate OUT, 'lastFeedElementPostDate'
DECLARE @memberCount int
EXEC sp_OAMethod @jResp, 'IntOf', @memberCount OUT, 'memberCount'
DECLARE @Color nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Color OUT, 'motif.color'
DECLARE @LargeIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @LargeIconUrl OUT, 'motif.largeIconUrl'
DECLARE @MediumIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MediumIconUrl OUT, 'motif.mediumIconUrl'
DECLARE @SmallIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @SmallIconUrl OUT, 'motif.smallIconUrl'
DECLARE @SvgIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @SvgIconUrl OUT, 'motif.svgIconUrl'
DECLARE @myRole nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @myRole OUT, 'myRole'
DECLARE @Id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Id OUT, 'mySubscription.id'
DECLARE @mySubscriptionUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @mySubscriptionUrl OUT, 'mySubscription.url'
DECLARE @name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'name'
DECLARE @AdditionalLabel nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @AdditionalLabel OUT, 'owner.additionalLabel'
DECLARE @CommunityNickname nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @CommunityNickname OUT, 'owner.communityNickname'
DECLARE @CompanyName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @CompanyName OUT, 'owner.companyName'
DECLARE @DisplayName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @DisplayName OUT, 'owner.displayName'
DECLARE @FirstName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @FirstName OUT, 'owner.firstName'
DECLARE @ownerId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ownerId OUT, 'owner.id'
DECLARE @IsActive int
EXEC sp_OAMethod @jResp, 'BoolOf', @IsActive OUT, 'owner.isActive'
DECLARE @IsInThisCommunity int
EXEC sp_OAMethod @jResp, 'BoolOf', @IsInThisCommunity OUT, 'owner.isInThisCommunity'
DECLARE @LastName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @LastName OUT, 'owner.lastName'
DECLARE @MotifColor nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MotifColor OUT, 'owner.motif.color'
DECLARE @MotifLargeIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MotifLargeIconUrl OUT, 'owner.motif.largeIconUrl'
DECLARE @MotifMediumIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MotifMediumIconUrl OUT, 'owner.motif.mediumIconUrl'
DECLARE @MotifSmallIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MotifSmallIconUrl OUT, 'owner.motif.smallIconUrl'
DECLARE @MotifSvgIconUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MotifSvgIconUrl OUT, 'owner.motif.svgIconUrl'
DECLARE @MySubscription nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MySubscription OUT, 'owner.mySubscription'
DECLARE @Name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'owner.name'
DECLARE @Message nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Message OUT, 'owner.outOfOffice.message'
DECLARE @FullEmailPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @FullEmailPhotoUrl OUT, 'owner.photo.fullEmailPhotoUrl'
DECLARE @LargePhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @LargePhotoUrl OUT, 'owner.photo.largePhotoUrl'
DECLARE @MediumPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @MediumPhotoUrl OUT, 'owner.photo.mediumPhotoUrl'
DECLARE @PhotoVersionId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @PhotoVersionId OUT, 'owner.photo.photoVersionId'
DECLARE @SmallPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @SmallPhotoUrl OUT, 'owner.photo.smallPhotoUrl'
DECLARE @StandardEmailPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @StandardEmailPhotoUrl OUT, 'owner.photo.standardEmailPhotoUrl'
DECLARE @PhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @PhotoUrl OUT, 'owner.photo.url'
DECLARE @Reputation nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Reputation OUT, 'owner.reputation'
DECLARE @ownerTitle nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ownerTitle OUT, 'owner.title'
DECLARE @v_Type nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'owner.type'
DECLARE @ownerUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ownerUrl OUT, 'owner.url'
DECLARE @UserType nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @UserType OUT, 'owner.userType'
DECLARE @pendingRequests int
EXEC sp_OAMethod @jResp, 'IntOf', @pendingRequests OUT, 'pendingRequests'
DECLARE @photoFullEmailPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoFullEmailPhotoUrl OUT, 'photo.fullEmailPhotoUrl'
DECLARE @photoLargePhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoLargePhotoUrl OUT, 'photo.largePhotoUrl'
DECLARE @photoMediumPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoMediumPhotoUrl OUT, 'photo.mediumPhotoUrl'
DECLARE @photoPhotoVersionId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoPhotoVersionId OUT, 'photo.photoVersionId'
DECLARE @photoSmallPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoSmallPhotoUrl OUT, 'photo.smallPhotoUrl'
DECLARE @photoStandardEmailPhotoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoStandardEmailPhotoUrl OUT, 'photo.standardEmailPhotoUrl'
DECLARE @photoUrl nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @photoUrl OUT, 'photo.url'
DECLARE @v_type nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'type'
DECLARE @url nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @url OUT, 'url'
DECLARE @visibility nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @visibility OUT, 'visibility'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/chatter/groups?name=New Chatter Group (Private Access)&visibility=PrivateAccess&description=Created via API&information=Private Information&isArchived=false&isAutoArchiveDisabled=false&isBroadcast=false&canHaveChatterGuests =true
Postman Collection Item JSON
{
"name": "List of Groups - POST",
"event": [
{
"listen": "prerequest",
"script": {
"exec": [
""
],
"type": "text/javascript"
}
},
{
"listen": "test",
"script": {
"exec": [
""
],
"type": "text/javascript"
}
}
],
"protocolProfileBehavior": {
"disabledSystemHeaders": {}
},
"request": {
"method": "POST",
"header": [
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/chatter/groups?name=New Chatter Group (Private Access)&visibility=PrivateAccess&description=Created via API&information=Private Information&isArchived=false&isAutoArchiveDisabled=false&isBroadcast=false&canHaveChatterGuests\t=true",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"chatter",
"groups"
],
"query": [
{
"key": "name",
"value": "New Chatter Group (Private Access)"
},
{
"key": "visibility",
"value": "PrivateAccess",
"description": "PrivateAccess—Only members of the group can see posts to this group.\nPublicAccess—All users within the community can see posts to this group.\nUnlisted—Reserved for future use."
},
{
"key": "description",
"value": "Created via API"
},
{
"key": "information",
"value": "Private Information",
"description": "If the group is private, the “Information” section is visible only to members."
},
{
"key": "isArchived",
"value": "false"
},
{
"key": "isAutoArchiveDisabled",
"value": "false",
"description": "true if automatic archiving is turned off for the group, false otherwise. Defaults to false. If true, if there are no posts or comments for 90 days the group is archived."
},
{
"key": "isBroadcast",
"value": "false",
"description": "true if only group owners and managers can create posts in the group, false otherwise."
},
{
"key": "canHaveChatterGuests\t",
"value": "true",
"description": "true if this group allows Chatter customers, false otherwise. After this property is set to true, it cannot be set to false."
}
]
},
"description": "A list of all the groups in the organization. Get information about groups or create a group.\n\nhttps://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/connect_resources_groups_ListOfGroups.htm"
},
"response": [
{
"name": "Successful List of Groups - POST",
"originalRequest": {
"method": "POST",
"header": [
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/chatter/groups?name=New Chatter Group (Private Access)&visibility=PrivateAccess&description=Created via API&information=Private Information&isArchived=false&isAutoArchiveDisabled=false&isBroadcast=false&canHaveChatterGuests\t=true",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"chatter",
"groups"
],
"query": [
{
"key": "name",
"value": "New Chatter Group (Private Access)"
},
{
"key": "visibility",
"value": "PrivateAccess",
"description": "PrivateAccess—Only members of the group can see posts to this group.\nPublicAccess—All users within the community can see posts to this group.\nUnlisted—Reserved for future use."
},
{
"key": "description",
"value": "Created via API"
},
{
"key": "information",
"value": "Private Information",
"description": "If the group is private, the “Information” section is visible only to members."
},
{
"key": "isArchived",
"value": "false"
},
{
"key": "isAutoArchiveDisabled",
"value": "false",
"description": "true if automatic archiving is turned off for the group, false otherwise. Defaults to false. If true, if there are no posts or comments for 90 days the group is archived."
},
{
"key": "isBroadcast",
"value": "false",
"description": "true if only group owners and managers can create posts in the group, false otherwise."
},
{
"key": "canHaveChatterGuests\t",
"value": "true",
"description": "true if this group allows Chatter customers, false otherwise. After this property is set to true, it cannot be set to false."
}
]
}
},
"status": "Created",
"code": 201,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Wed, 22 Nov 2023 11:29:04 GMT"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=63072000; includeSubDomains"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "X-Robots-Tag",
"value": "none"
},
{
"key": "Cache-Control",
"value": "no-cache,must-revalidate,max-age=0,no-store,private"
},
{
"key": "Content-Type",
"value": "application/json;charset=UTF-8"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"additionalLabel\": \"Private With Customers\",\n \"announcement\": null,\n \"bannerPhoto\": {\n \"bannerPhotoUrl\": \"https://<my_domain>/profilephoto/0F9/B\",\n \"bannerPhotoVersionId\": null,\n \"url\": \"/services/data/v58.0/chatter/groups/0F9.../banner-photo\"\n },\n \"canHaveChatterGuests\": true,\n \"community\": null,\n \"description\": \"Created via API\",\n \"emailToChatterAddress\": \"0F9...@post.2o-i6mbeaq.eu25.chatter.salesforce.com\",\n \"fileCount\": 0,\n \"id\": \"0F9...\",\n \"information\": {\n \"text\": null,\n \"title\": null\n },\n \"isArchived\": false,\n \"isAutoArchiveDisabled\": false,\n \"isBroadcast\": false,\n \"lastFeedElementPostDate\": \"2023-11-22T11:29:05.000Z\",\n \"memberCount\": 1,\n \"motif\": {\n \"color\": \"1B96FF\",\n \"largeIconUrl\": \"/img/icon/groups64.png\",\n \"mediumIconUrl\": \"/img/icon/groups32.png\",\n \"smallIconUrl\": \"/img/icon/groups16.png\",\n \"svgIconUrl\": null\n },\n \"myRole\": \"GroupOwner\",\n \"mySubscription\": {\n \"id\": \"0FB...\",\n \"url\": \"/services/data/v58.0/chatter/group-memberships/0FB...\"\n },\n \"name\": \"New Chatter Group (Private Access)\",\n \"owner\": {\n \"additionalLabel\": null,\n \"communityNickname\": \"User1696423780773910041\",\n \"companyName\": \"Salesforce\",\n \"displayName\": \"Name\",\n \"firstName\": \"Firstname\",\n \"id\": \"005...\",\n \"isActive\": true,\n \"isInThisCommunity\": true,\n \"lastName\": \"Name\",\n \"motif\": {\n \"color\": \"1B96FF\",\n \"largeIconUrl\": \"/img/icon/profile64.png\",\n \"mediumIconUrl\": \"/img/icon/profile32.png\",\n \"smallIconUrl\": \"/img/icon/profile16.png\",\n \"svgIconUrl\": null\n },\n \"mySubscription\": null,\n \"name\": \"Name\",\n \"outOfOffice\": {\n \"message\": \"\"\n },\n \"photo\": {\n \"fullEmailPhotoUrl\": \"https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0IogXzXAXaYKJnuWCNQmXymRq?fromEmail=1\",\n \"largePhotoUrl\": \"https://<my_domain>/profilephoto/729.../F\",\n \"mediumPhotoUrl\": \"https://<my_domain>/profilephoto/729.../M\",\n \"photoVersionId\": \"729...\",\n \"smallPhotoUrl\": \"https://<my_domain>/profilephoto/729.../T\",\n \"standardEmailPhotoUrl\": \"https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0Ioi-dtynkoFWsl46as__TDFU?fromEmail=1\",\n \"url\": \"/services/data/v58.0/connect/user-profiles/005.../photo\"\n },\n \"reputation\": null,\n \"title\": null,\n \"type\": \"User\",\n \"url\": \"/services/data/v58.0/chatter/users/005...\",\n \"userType\": \"Internal\"\n },\n \"pendingRequests\": 0,\n \"photo\": {\n \"fullEmailPhotoUrl\": \"https://<my_domain>/img/userprofile/default_group_profile_200_v2.png?fromEmail=1\",\n \"largePhotoUrl\": \"https://<my_domain>/profilephoto/0F9/F\",\n \"mediumPhotoUrl\": \"https://<my_domain>/profilephoto/0F9/M\",\n \"photoVersionId\": null,\n \"smallPhotoUrl\": \"https://<my_domain>/profilephoto/0F9/T\",\n \"standardEmailPhotoUrl\": \"https://<my_domain>/img/userprofile/default_group_profile_45_v2.png?fromEmail=1\",\n \"url\": \"/services/data/v58.0/chatter/groups/0F9.../photo\"\n },\n \"type\": \"CollaborationGroup\",\n \"url\": \"/services/data/v58.0/chatter/groups/0F9...\",\n \"visibility\": \"PrivateAccess\"\n}"
}
]
}
