GeeKs Blogging @ dotCOM

Siebel – EAI Siebel Adapter – Looping Multiple Records

by Nitin Jain

---

This is a follow-up post on the post, Siebel – Looping Multiple Records – III. We are looking at possibly more conventional methods to loop through multiple records in Siebel, than the SIA BC Utility Service.

We will make use of EAI Siebel Adapter’s QueryPage method to achieve the same. Knowledge of Siebel Workflow processes is essential to understanding this post.
The QueryPage method allows us to input an additional parameter, NumOutputObjects, to define the number of records that we want to output. Why not set this value to ‘1′?

Following is an outline of the Dummy Workflow I used to achieve this.

Following are the Custom Process Properties and their default values at the time of starting the workflow.

Process Property	Default Value
Last Record
New Query	Y
Number of Output Objects
Order Type
SiebelMessage
Status
XMLHierarchy

 

The outline of the Individual Steps is as follows.
1) START – The starting step in the workflow

2) Query Records

Business Service Name	EAI Siebel Adapter
Business Service Method	QueryPage

 

Input Arguments:

OutputIntObjectName	Literal	7.7 Order Entry Integration Object
PageSize	Literal	1

 

Output Arguments:

OutputIntObjectName	Output Argument	SiebelMessage
Last Record	Output Argument	LastPage
Number of Output Objects	Output Argument	NumOutputObjects
New Query	Literal	N

3) Convert to XML Hier

Business Service Name	EAI Integration Object to XML Hierarchy Converter
Business Service Method	IntObjHierToXMLHier

Input Arguments:

SiebelMessage

Process Property

SiebelMessage

Output Arguments:

XMLHierarchy

Output Argument

XMLHierarchy

4) Extract Values

Business Service Name	FINS Industry XML Query Service
Business Service Method	Execute

Input Arguments:

Status	Literal	.//Status
XMLHierarchy	Process Property	XMLHierarchy

Output Arguments:

Status

Output Argument

Status

We have covered the FINS Industry XML Business Service in detail here on GeeksBlogging@dotCOM.

5) Process Record Data

Sub Process

Dummy Processing Sub Process

Input Arguments:
As per requirement

Output Arguments:
As per requirement

6) Last Record?

Decision Point

Branch Conditions:

Process Property

All Must Match(Ignore Case)

Last Record

FALSE

7) END – The Standard Siebel END Step

The Workflow ends successfully. We have successfully retrieved the data from each of the successive records one by one, and passed on the data for further processing to a Sub-process.

This post wouldn’t be complete without referring the source which gave me my first hints to implementing this. Thanks, Alex.

Related posts:

1. Siebel – SIA BC Utility Service – Loop multiple records This is a vanilla business service which provides an extensive...
2. Siebel – Looping Multiple Records – III Looping through multiple records is a requirement we come across...
3. Siebel – Looping multiple records – Query and Process In my last post, I discussed as to how we...
4. Siebel – Looping multiple records – Update records Hi, We often come across a requirement where we need...
5. EAI Siebel Adapter BS – Upsert Multiple Child Records EAI Siebel Adapter finds its usage in almost all integration...
6. Siebel – FINS Industry XML Query Service “Extracting values from a tag deep down in the Hierarchy.”...
7. Siebel – EAI Siebel Adapter Search Spec Hi, I can bet that for anybody who has worked...