Clarity Service Management

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

01-10-2017 11:24 AM

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

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

02-09-2017 04:40 AM

Thanks TMACUL,

 

I already got the status the ticket and your status description. The wiki that you sent me It is very helpful.

 

Regards

 

Matheus Isquierdo

02-08-2017 09:06 PM

Hi Matheus,

 

 I build this example, can be helpfull.

CA PAM::. CA SDM WebService DoSelect - Process Example for read cr - call_req 

 

Regards

02-08-2017 07:51 AM

Hi Matheus,

 

Thank you, we need to share knowledge.

 

How Do I know all object types?

 

Are you talking about SDM? I have already published some objects, any way, it's need to look the object using  bop_sinfo 

or using WIKI CA SDM Objects - CA Service Management - 14.1 - CA Technologies Documentation 

or a document from 12.6: Technical Reference Guide 

 

I will develop an example for this, but from memory I believe it to be as follows:

 

 

<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>cr</objectType>
<whereClause>ref_num='123456'</whereClause>
<maxRows>1</maxRows>
<attributes>
<!--1 or more repetitions:-->
<string>id</string>
<string>status</string>
</attributes>
</ser:doSelect>
</soapenv:Body>
</soapenv:Envelope>

 

 

Regards

02-07-2017 01:28 PM

TMACUL Great Doc,

 

I didnt a full documentation about this service.

How Do I know all object types?

In my case I need get a status ticket. How can I do this?

 

Regards

 

Matheus

01-30-2017 08:04 AM

01-10-2017 05:20 PM

Thanks for sharing this (and all the other tips) with the community Tiago!

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

Related Entries and Links

No Related Resource entered.