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:
CA SDM Trabalhando com WebService
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
CA SDM::. CA SDM Web Service :: DoSelect method for contacts - How to use
CA SDM::. CA SDM Web Service :: Como faço para usar o método DoSelect
CA PAM::. CA SDM DoSelect reading cr - call_req - Process Example
CA PAM::. CA SDM WebService DoSelect - Process Example for read cr - call_req
CA PAM::. CA SDM Web Service DoSelect - chg and prp - Change Category properties
CA PAM::. CA SDM Web Service DoSelect - grc - ca_resource_class
CA PAM::. CA SDM Web Service DoSelect - pcat - Prob_Category
CA PAM::. CA SDM Web Service DoSelect - loc and ca_location
CA PAM::. CA SDM Web Service DoSelect - Process Example for read models
CA SDM::. Web Service Doselect - for model - mfrmod - ca_model_def - call Example
CA PAM::. CA SDM Web Service Doselect - Process Example
https://docops.ca.com/ca-service-management/14-1/en/reference/ca-service-desk-manager-reference-commands/objects-and-attributes/workflow-objects