Skip to main content

How to Query Page in Integration Object IO and get desired number of records using EAI Siebel Adapter business service in Siebel Workflow

Why Pagination in Siebel Inbound Web Service?

When creating Inbound Web Services in Siebel for external system consumption data might be huge and web service either take time or timeout when invoking. So in this scenario we need to introduce the pagination. When calling the web service external system will request the page size meaning number of rows in one request.

Prerequisite:

IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to execute query in Siebel Workflow.

Process:

Add new Business Service step in Siebel Workflow, set its properties as below:

Business Service Name: EAI Siebel Adapter
Business Service Method: QueryPage

Set the values of Input Arguments as below:

Input Argument: OutputIntObjectName
Type: Literal
Value: IO Name

Input Argument: SearchSpec
Type: Expression
Value: "[IC Name.Field Name] = '" + [&Process Property Name] + "'"

Sample Expression: "[IC Name.Field Name] = '"+LookupValue("LOV_TYPE","Value")+"' AND [IC Name.Field Name] >= '" + [&ProcessProperty 1] + "' AND [IC Name.Field Name] = '" + [&ProcessProperty 2] + "' AND [CIC Name.Field Name] = '" + [&ProcessProperty 3] + "'"

Input Argument: StartRowNum
Type: Literal
Value: 1

Note: This will defines from were records will start.

Input Argument: PageSize
Type: Literal
Value: 10

Note: This will define how many records will return in current query.
 
Set the values of Output Arguments as below:

Property Name: SiebelMsg 
Type: Output Argument
Output Argument: SiebelMessage

SiebelMsg is a process property with type hierarchical.



Can be used without "SearchSpec". Siebel can only return 10,000 records if there are more records siebel will give error (There were more rows than could be returned) so this is very handy also if you have connection issue to avoid connection time out error this method can be used by defining low number of records fetched in one request.
 
See Also:
 

Labels:

Comments

Post a Comment

Popular posts from this blog

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.
Post a Comment
Read more

How to call Popup Applet through Server Script in Siebel

Background: Based on the requirements you need to show data or reports on a popup applet. You can invoke popup applet using workflow (below business service will be used in business service step), applet server script or browser script and using vanilla method and setting field user properties. Procedure: Below is the script for calling popup applet through server script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperati...
Post a Comment
Read more

How to create and publish Inbound Web Service in Siebel based on Workflow

Inbound Web Services: The Inbound Web Service allows an external system to call a Siebel published Web Service. You can publish a business service or a business process as a Web Service and generate a Web Service Definition Language (WSDL) file that an external system can import. The Inbound Web Services can only be published from Siebel C using SOAP-RPC binding. Source: Oracle Docs What Is The Difference Between Web Services and APIs? An API is an interface that allows you to build on the data and functionality of another application, while a web service is a network-based resource that fulfills a specific task. Yes, there’s overlap between the two: all web services are APIs, but not all APIs are web services. Both web services and APIs are — at their core — very useful and very much used today. However, it’s the web services associated with SOAP and/or Service Oriented Architecture which are falling out of favor. Source: NordicApis Process: Prepare the workflow which will serve as Si...
Post a Comment
Read more