IT Process Automation

View Only

Back to Library

PAM::. CA SDM WebService Loop Contacts - Process Example

Recommend

Feb 07, 2017 02:20 PM

TMACUL

CA PAM - Using CA SDM Webservice - loop contacts

01. Do Select

01.A - WSDL Wizard

01.B - 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>
 <string>string2__</string>
 </attributes>
</impl:doSelect>

01.C - Dynamic Parameters

SessionID
objectType__ ===> "cnt"
whereClause__
maxRows__
string__ ==> "persistent_id"
string2__ ==> "userid"

01.D - Call Results

Extract SOAP response body first-level elements to individual Dataset
Extract SOAP response body to Dataset variable
Strip XML Namespaces from Response

On Strip XML Namespaces from Response

XPath expression
- //doSelectReturn
Dataset variable
- SelectReturn
Type
- String

02. Xpath

02.A

Expression
- XML
Strip XML Namespaces from Response
- AttrValue
Type
- XML Fragment Array

02.B Post Execution Code

var intCounter = 0;

Process.intSize = Process[OpName].AttrValue.length;

for(var intCounter=0; intCounter<Process.intSize; intCounter++)
{
 Process.CntPersid.size++
 Process.CntUserid.size++
 
 Process.CntPersid[intCounter] = applyXPath(Process[OpName].AttrValue[intCounter], "//AttrName[text()='persistent_id']/../AttrValue/text()");
 Process.CntUserid[intCounter] = applyXPath(Process[OpName].AttrValue[intCounter], "//AttrName[text()='userid']/../AttrValue/text()");
}