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

Document created by TMACUL Champion on Jan 10, 2017Last modified by TMACUL Champion on Nov 23, 2018
Version 2Show 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:

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

1 person found this helpful

Attachments

    Outcomes