> sf data query --query "SELECT User.Name, TeamMemberRole FROM AccountTeamMember WHERE AccountId =
>> '0015c00002p4RfIAAU' AND TeamMemberRole = 'Solutions Engineer'"
┌───────────────┬────────────────────┐
│ USER.NAME │ TEAMMEMBERROLE │
├───────────────┼────────────────────┤
│ Evgenij Renke │ Solutions Engineer │
└───────────────┴────────────────────┘
Total number of records retrieved: 1.
Querying Data... done
> sf data query --query "SELECT User.Name, TeamMemberRole FROM AccountTeamMember WHERE AccountId =
>> '0015c00002p4RfIAAU' AND TeamMemberRole = 'Solutions Engineer'" -r=json
{
"status": 0,
"result": {
"records": [
{
"attributes": {
"type": "AccountTeamMember",
"url": "/services/data/v66.0/sobjects/AccountTeamMember/01MKg000001DWcVMAW"
},
"User": {
"attributes": {
"type": "User",
"url": "/services/data/v66.0/sobjects/User/0055c00000B3ACOAA3"
},
"Name": "Evgenij Renke"
},
"TeamMemberRole": "Solutions Engineer"
}
],
"totalSize": 1,
"done": true
}
}> sf data query --query "SELECT User.Name, TeamMemberRole FROM AccountTeamMember WHERE AccountId =
>> '0015c00002p4RfIAAU'"
┌─────────────────┬────────────────────────────────────┐
│ USER.NAME │ TEAMMEMBERROLE │
├─────────────────┼────────────────────────────────────┤
│ Irshad Burtally │ Regional Senior Director │
│ Samuel Rowe │ Regional CSA Manager │
│ Holly Prado │ Enterprise Business Representative │
│ Evgenij Renke │ Solutions Engineer │
└─────────────────┴────────────────────────────────────┘
Total number of records retrieved: 4.
Querying Data... done
sf data create record --sobject AccountTeamMember --values "AccountId='0015c00002p4RfIAAU' UserId='0055c00000B3ACOAA3'
TeamMemberRole='Solutions Engineer'"
Reading the role
Reading all the roles of an account
Assign the role