function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Daniel GudzikDaniel Gudzik 

Get groupId and memberId when using /sobjects/groupmember/updated API ?

Hi,

Is it possible to get groupId and memberId when getting a group memberId from /sobjects/groupmember/updated API ?

I am using this API to get notified regarding deleted group members.
The response is just groupMemberId, but since it was already deleted, its not in the groupMember table anymore.
How can I get the information about this ID (groupID, memberID) ?

Thanks in advance!
Raj VakatiRaj Vakati
Yes .. you can able to query them like below
  
List<GroupMember> members = [ SELECT Id, GroupId, UserOrGroupId 
                            FROM GroupMember ]

Or 
  
List<GroupMember> members = [ SELECT Id, GroupId, UserOrGroupId 
                            FROM GroupMember 
                            WHERE GroupId IN (SELECT id FROM Group where Id = :groupId) ];

List<Id> ids = new List<Id>();
for(GroupMember member: members) {
   ids.add(member.UserOrGroupId);
}
List<Group> lstGroup = [SELECT Name, RelatedId, Type, Id From Group WHERE Id IN:ids];

https://salesforce.stackexchange.com/questions/143577/groupmember-types-of-a-public-group/143580
Daniel GudzikDaniel Gudzik
Hi,

Thanks for your answer!

I had a mistake in my question. I meant that I'm using the "Deleted" API.
/sobjects/groupmember/deleted
So I will not receive the information about the ID in select from GroupMember since it was deleted.
Is there any other way to get info about the deleted records?
Daniel GudzikDaniel Gudzik
Hi,

I deleted a group member and executed the following query in postman:
...salesforce.com/services/data/v45.0/sobjects/groupmember/deleted?start=2019-03-04T18%3A40%3A00Z&end=2019-03-25T13%3A00%3A50Z

Response:
{
    "deletedRecords": [
        {
            "deletedDate": "2019-03-25T10:18:34.000+0000",
            "id": "0111t0000005jvMAAQ"
        }
    ],
    "earliestDateAvailable": "2018-12-16T17:17:00.000+0000",
    "latestDateCovered": "2019-03-25T02:16:00.000+0000"
}
Then I queried for this group member with ALL ROWS:
 
1...salesforce.com/services/data/v45.0/query?q=SELECT Id,groupId,userOrGroupId FROMgroupMember where id='0111t0000005jvMAAQ' ALL ROWS
But the response is as follows:
[
    {
        "message": "ALL ROWS not allowed in this context",
        "errorCode": "MALFORMED_QUERY"
    }
]
What wrong have I done?
Any suggestions to get the group ID and member ID of the deleted record using API (in postman, not in Java code)

Thanks in advance!