CA SDM::. CA SDM Web Service :: DoSelect method

Document created by TMACUL Champion on Jan 10, 2017
Version 1Show Document
  • View in full screen mode

How to use DoSelect method?

 

 

 

Parameter

Type

Description

SID

Integer

Identifies the session retrieved from logging in.

objectType

String

Identifies the object type (factory) to query.

whereClause

String

(Optional) Identifies the where clause for the query.

maxRows

Integer

Indicates the maximum number of rows to return. Specify -1 to return all rows.

Note: Regardless of the integer specified, CA SDM will return a maximum of 250 rows per call.

attributes

String[]

Identifies the attribute list for which to fetch values. Dotted-attributes are permitted. If this field is blank, all value-based attributes are returned. These attributes cannot be defined as LOCAL in the majic definition file. LOCAL attributes are temporal; they have no database storage

Technical Reference Guide

 

http://<server name>:8080/axis/services/USD_R11_WebService?wsdl

<element name="doSelect">

<complexType>
<sequence>
<element name="sid" type="xsd:int"/>
<element name="objectType" type="xsd:string"/>
<element name="whereClause" type="xsd:string"/>
<element name="maxRows" type="xsd:int"/>
<element name="attributes" type="impl:ArrayOfString"/>
</sequence>
</complexType>
</element>
<element name="doSelectResponse">
<complexType>
<sequence>
<element name="doSelectReturn" type="xsd:string"/>
</sequence>
</complexType>
</element>

 

Request Example 01:

 

 

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<soapenv:Header/>
<soapenv:Body>
<ser:doSelect>
<sid>1060337273</sid>
<objectType>cnt</objectType>
<whereClause>userid='ServiceDesk'</whereClause>
<maxRows>1</maxRows>
<attributes>
<!--1 or more repetitions:-->
<string>last_name</string>
<string>first_name</string>

</attributes>
</ser:doSelect>
</soapenv:Body>
</soapenv:Envelope>

 

Answer example 01:

 

<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>
<doSelectResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<doSelectReturn xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?><UDSObjectList>
<UDSObject>
<Handle>cnt:171E5C822F5AA4409145FC5220142A50</Handle>
<Attributes>
<Attribute DataType="2002">
<AttrName>last_name</AttrName>
<AttrValue>Desk</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>first_name</AttrName>
<AttrValue>Service</AttrValue>
</Attribute>
</Attributes>
</UDSObject>
</UDSObjectList>]]></doSelectReturn>
</doSelectResponse>
</soapenv:Body>
</soapenv:Envelope>

 

Request Example 02:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<soapenv:Header/>
<soapenv:Body>
<ser:doSelect>
<sid>1060337273</sid>
<objectType>cnt</objectType>
<whereClause>userid='ServiceDesk'</whereClause>
<maxRows>1</maxRows>
</ser:doSelect>
</soapenv:Body>
</soapenv:Envelope>

Answer example 02:

 

<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>
<doSelectResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<doSelectReturn xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?><UDSObjectList>
<UDSObject>
<Handle>cnt:171E5C822F5AA4409145FC5220142A50</Handle>
<Attributes>
<Attribute DataType="2002">
<AttrName>pgroups</AttrName>
<AttrValue>(0)</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>userid</AttrName>
<AttrValue>ServiceDesk</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>schedule</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>ldap_dn</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>supervisor_contact_uuid</AttrName>
<AttrValue>A991913C0FCECE4FB7884C404329EFA9</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>contact_num</AttrName>
<AttrValue>123456</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>sap_personID</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>auto_bias_isswf</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>tenant_group</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>phone_number</AttrName>
<AttrValue>+551141666999</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>last_name</AttrName>
<AttrValue>ServiceDesk</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>access_type</AttrName>
<AttrValue>400001</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>admin_org</AttrName>
<AttrValue>954FF545E5E3994EB4C6EA67884ABA7B</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>last_mod_by</AttrName>
<AttrValue>ServiceDesk</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>fax_phone</AttrName>
<AttrValue>1141666999</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>middle_name</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2004">
<AttrName>delete_time</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>version_number</AttrName>
<AttrValue>9</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>combo_name2</AttrName>
<AttrValue>ServiceDesk,,</AttrValue>
</Attribute>
<Attribute DataType="2009">
<AttrName>id</AttrName>
<AttrValue>171E5C822F5AA4409145FC5220142A50</AttrValue>
</Attribute>
<Attribute DataType="2004">
<AttrName>creation_date</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>billing_code</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>company</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>vendor</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_ws4</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_ws3</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_ws2</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_ws1</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>type</AttrName>
<AttrValue>2307</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>notes</AttrName>
<AttrValue>Privileged User(NX_PARADIGMUSER)</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>beeper_phone</AttrName>
<AttrValue>1141666999</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>room_location</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>confirm_save</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_urgency4</AttrName>
<AttrValue>4</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_urgency3</AttrName>
<AttrValue>3</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_urgency2</AttrName>
<AttrValue>2</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_urgency1</AttrName>
<AttrValue>1</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>email_address</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>timezone</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>integration_cnt</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>service_type</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>dept</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>available</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>first_name</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>alt_phone</AttrName>
<AttrValue></AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>creation_user</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>audit_userid</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>currency_type</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>position</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>pemail_address</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2001">
<AttrName>exclude_registration</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_method4</AttrName>
<AttrValue>1800</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_method3</AttrName>
<AttrValue>1800</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>delete_flag</AttrName>
<AttrValue>0</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_method2</AttrName>
<AttrValue>1800</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>web_url</AttrName>
<AttrValue>http://<servername>:8080/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cnt+SKIPLIST=1+QBE.EQ.id=171E5C822F5AA4409145FC5220142A50</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>notify_method1</AttrName>
<AttrValue>1800</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>mobile_phone</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2006">
<AttrName>cost</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2009">
<AttrName>linked_id_usp_contact</AttrName>
<AttrValue>171E5C822F5AA4409145FC5220142A50</AttrValue>
</Attribute>
<Attribute DataType="2002">
<AttrName>combo_name</AttrName>
<AttrValue>ServiceDesk</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>domain</AttrName>
<AttrValue>21803</AttrValue>
</Attribute>
<Attribute DataType="2001">
<AttrName>auto_bias_crwf</AttrName>
<AttrValue/>
</Attribute>

<Attribute DataType="2002">
<AttrName>alias</AttrName>
<AttrValue>ServiceDesk</AttrValue>
</Attribute>
<Attribute DataType="2001">
<AttrName>auto_bias_wf</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2004">
<AttrName>last_mod_dt</AttrName>
<AttrValue>1483022818</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>location</AttrName>
<AttrValue/>
</Attribute>
<Attribute DataType="2002">
<AttrName>persistent_id</AttrName>
<AttrValue>cnt:171E5C822F5AA4409145FC5220142A50</AttrValue>
</Attribute>
<Attribute DataType="2005">
<AttrName>organization</AttrName>
<AttrValue>B4815FDBC33BAD42B05C7A96AA2FEF83</AttrValue>
</Attribute>
</Attributes>
</UDSObject>
</UDSObjectList>]]></doSelectReturn>
</doSelectResponse>
</soapenv:Body>
</soapenv:Envelope>

 

 

 

 

 

Know more:

TEC1910026 - How to retrieve CA Service Desk Manager (SDM) contacts - userid or name using ServiceDesk WebServices without requesting a handle 

How to Test/Access CA SDM Web Service :: Login method 

CA Service Desk WebService 

1 person found this helpful

Attachments

    Outcomes