Invoke_Service_Desk_Web_Service Operator

[Anon Anon]

Hi,

 

Setup

Server 1: SDM 12.9

Server 2: PAM 4.2

Server 3: MS SQL 2008R2

 

I am implementing a PAM processes to fetch several attributes from CA Service Desk. (ref_num, customer.userid, etc). Connectivity between SDM and PAM is ok. I have the ability to change the status of a ticket using Set_Request_Status Operator.

I am using Invoke_Service_Desk_Web_Service Operator to fetch attributed from SDM. Following is the configuration of the Invoke_Service_Desk_Web_Service Operator.

 

 

Inline Text

<impl:doSelect xmlns:impl="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

<sid>sid__</sid>

<objectType>objectType__</objectType>

<whereClause>whereClause__</whereClause>

<maxRows>maxRows__</maxRows>

<attributes>

<string>string__</string>

</attributes>

</impl:doSelect>

 

Dynamic Parameters

 

sid__	Process.Invoke_Service_Desk_Web_Servic_1.ServiceDeskSessionID	String Value
objectType__	cr	String Value
whereClause__	persid='Process.persid'	String Value
maxRows__	100	Integer Value
string__	ref_num	String Value

 

 

I executed the process through SDM. And the process was Blocked.

Am I configuring the operator correctly?

 

My requirement is to fetch data from SDM by using either Invoke_Service_Desk_Web_Service Operator or Select_Object Operator.

 

Thanks in advance.

 

Cheers!

Kasun

[buian01]

Your issue is the Where Clause. "persid" is the not the correct attribute name. It is "persistent_id".

 

Andy

[Anon Anon]

Dear Andy,

 

Thanks a lot for your support. Your solution was a success. Yet I'm not getting the required variable from SDM. Following is the  Inline Text.

 

<impl:doSelect xmlns:impl="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

  <sid>Process.Invoke_Service_Desk_Web_Servic_2.ServiceDeskSessionID</sid>

  <objectType>cr</objectType>

  <whereClause>persistent_id='Process.persid'</whereClause>

  <maxRows>100</maxRows>

  <attributes>

    <string>customer.combo_name</string>

  </attributes>

</impl:doSelect>

 

Please guide me to configure this. Thanks in advance.

 

Cheers!

Kasun

[buian01]

Kasun,

 

I have never used Process dataset variables in the Inline Text. I would put the dynamic variables back in the inline text for the "sid" and "whereclause" attributes.

 

Andy 

[Anon Anon]

Andy,

 

Thanks for the reply. I just wanna know how that you will import variables from SDM. How will you configure dynamic variables for that?

Thanks in advance.

 

Kasun