AnsweredAssumed Answered

web service "getGroupMemberListValues" always return empty list

Question asked by chison.cai on Jun 25, 2018
Latest reply on Jun 25, 2018 by pier-olivier.tremblay

web service "getGroupMemberListValues" always return empty list in CA SDM 17.1

 

request xml:

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<soapenv:Header/>
<soapenv:Body>
<ser:getGroupMemberListValues>
<sid>1536403501</sid>
<whereClause>group.last_name != 'abc'</whereClause>
<numToFetch>1</numToFetch>
<attributes>
<string>group.last_name</string>
<string>member.userid</string>
</attributes>
</ser:getGroupMemberListValues>
</soapenv:Body>
</soapenv:Envelope>

 

response xml:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<getGroupMemberListValuesResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<getGroupMemberListValuesReturn xmlns="">&lt;?xml version="1.0" encoding="UTF-8"?>&lt;UDSObjectList/></getGroupMemberListValuesReturn>
</getGroupMemberListValuesResponse>
</soapenv:Body>
</soapenv:Envelope>

 

 

I am sure the groups are already created with members added.

I can capture the sql with sql profile as below.

 

exec sp_executesql N'SELECT grpmem.id FROM grpmem, ca_contact WHERE grpmem.group_id = ca_contact.contact_uuid AND ca_contact.last_name != @P1',N'@P1 nvarchar(4000)',N'abc'

 

 

 

I can executed the sql manually and get the results.

 

Why the response list is empty?

Outcomes