Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Master for RUN Web Service (REST)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Master for RUN Web Service (REST)
 Login/Join
 
Platinum Member
posted
I have created a master from the REST adapter for the RUN service. Somehow, when I am using the master I am getting error. I know that these masters are standard. I am wondering if someone can put the master and acx for the RUN web service. I will greatly appreciate.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Virtuoso
posted Hide Post
Hi WFConslutant

What error are you getting? Can you post the master and your code so we can help debug this.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
Hi Chuck,

I have posted masters below.

I am running the sign on call first and then calling the run. Looks like it is executing the schedule. However, I am not sure if I am doing it right. Also, I am not finding luck trying to pass parameters to schedule form the fex.

Signon call
------------

TABLE FILERS_SIGNON
PRINT
RETURNCODE
RETURNDESC
IF IBIRS_USERNAME EQ 'uid'
IF IBIRS_PASSWORD EQ 'pwd'
ON TABLE HOLD
END
-RUN

Run call
--------
TABLE FILE RS_RUN
PRINT
RETURNCODE
RETURNDESC
IBIRS_PATH
IF IBIRS_PATH EQ 'IBFS:/WFC/Repository/RSD/schedules/schedule1.sch'
ON TABLE HOLD
END
-RUN

Master for the signon
---------------------
FILENAME=RS_SIGNON, SUFFIX=REST , $
SEGMENT=M6ILO, SEGTYPE=S0, $
GROUP=HEADER, ALIAS=Header, ELEMENTS=3, $
FIELDNAME=IBIRS_ACTION, ALIAS=IBIRS_action, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='signOn', $
FIELDNAME=IBIRS_USERNAME, ALIAS=IBIRS_userName, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=IBIRS_PASSWORD, ALIAS=IBIRS_password, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=M6ILO, POSITION=__RESPONSE, $
FIELDNAME=IBFSRPC, ALIAS=ibfsrpc, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
PROPERTY=ELEMENT, $
FIELDNAME=IBFSPARAMS, ALIAS=ibfsparams, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ELEMENT, $
FIELDNAME=SIZE, ALIAS=size, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSPARAMS, PROPERTY=ATTRIBUTE, $
FIELDNAME=_JT, ALIAS=_jt, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=LANGUAGE, ALIAS=language, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=LOCALIZEDDESC, ALIAS=localizeddesc, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=NAME, ALIAS=name, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=RETURNCODE, ALIAS=returncode, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=RETURNDESC, ALIAS=returndesc, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=SUBRETURNCODE, ALIAS=subreturncode, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=TYPE, ALIAS=type, USAGE=A30, ACTUAL=A30,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $


Master for RUN
------------------
FILENAME=M6ILO, SUFFIX=REST , $
SEGMENT=M6ILO, SEGTYPE=S0, $
GROUP=HEADER, ALIAS=Header, ELEMENTS=9, $
FIELDNAME=IBIRS_PATH, ALIAS=IBIRS_path, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=IBIRS_ACTION, ALIAS=IBIRS_action, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='run', $
FIELDNAME=IBIRS_CLIENTPATH, ALIAS=IBIRS_clientPath, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='__null', $
FIELDNAME=IBIRS_HTMLPATH, ALIAS=IBIRS_htmlPath, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='__null', $
FIELDNAME=IBIRS_USERNAME, ALIAS=IBIRS_userName, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='__null', $
FIELDNAME=IBIRS_PASSWORD, ALIAS=IBIRS_password, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='__null', $
FIELDNAME=IBIRS_ARGS, ALIAS=IBIRS_args, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='__null', $
FIELDNAME=IBIRS_RANDOM, ALIAS=IBIRS_random, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=IBIRS_SERVICE, ALIAS=IBIRS_service, USAGE=A255, ACTUAL=A255, ACCESS_PROPERTY=(NEED_VALUE),
XDEFAULT='ibfs', $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=M6ILO, POSITION=__RESPONSE, $
FIELDNAME=IBFSRPC, ALIAS=ibfsrpc, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL),
PROPERTY=ELEMENT, $
FIELDNAME=IBFSPARAMS, ALIAS=ibfsparams, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ELEMENT, $
FIELDNAME=SIZE, ALIAS=size, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSPARAMS, PROPERTY=ATTRIBUTE, $
FIELDNAME=_JT, ALIAS=_jt, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=LANGUAGE, ALIAS=language, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=NAME, ALIAS=name, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=RETURNCODE, ALIAS=returncode, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=RETURNDESC, ALIAS=returndesc, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=SUBRETURNCODE, ALIAS=subreturncode, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $
FIELDNAME=TYPE, ALIAS=type, USAGE=A255, ACTUAL=A255,
REFERENCE=IBFSRPC, PROPERTY=ATTRIBUTE, $

This message has been edited. Last edited by: WFConsultant,


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
What's the error you are receiving?

Are you running the SignOn and RS_RUN separately?

As the JSESSIONID Cookie needs to be passed from the response of signOn to the request of RS_RUN, that must be run within the same Server agaent.
To do that, they must be run within the same FEX.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Efrem:
What's the error you are receiving?

Are you running the SignOn and RS_RUN separately?


Efrem,
Thank you for your response. I am executing sign on and call to schedule in the same fex. Master files used for both the requests are listed above. Can you suggest if the masters are good? In addition, if you could, please let me know how to pass custom parameters to schedule.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
I still need to know the error you're receiving so I'm able to determine where the problem is.

Efrem
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Efrem:
I still need to know the error you're receiving so I'm able to determine where the problem is.


I did not get any errors. The schedule is executing. However, I am not able to pass parameters to the schedule form the Web Service call.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
It works like any other Parameterized WebFOCUS Report.

You already have the following in your fex:
quote:
IF IBIRS_PATH EQ 'IBFS:/WFC/Repository/RSD/schedules/schedule1.sch'


For example, change it to:
IF IBIRS_PATH EQ '&SCHEDULE_PATH'

And then, when you run the fex and get prompted for &SCHEDULE_PATH, enter the path to the schedule you want.
eg. IBFS:/WFC/Repository/RSD/schedules/schedule1.sch

Efrem
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Platinum Member
posted Hide Post
Thank you for the update. However, the parameters I am trying to pass are consumed in the fex inside the schedule task (schedule1.sch). How do I send ex, &COUNTRY, to the schedule1.sch?


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
Web Services is just another way of calling existing WebFOCUS/ReportCaster functionality.

I checked the ReportCaster frontend and I don't see a way to run a Schedule passing it parameter values.
So, therefore, the run Web Service call would not do it either.

You would need to do the same thing as if you were doing this in the ReportCaster frontend.
That is Modify the existing schedule.

You might want to open a New Feature request in order to have this functionality added to the ReportCaster product.

Then, the Web Service call would be modified accordingly.

Efrem
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Master for RUN Web Service (REST)

Copyright © 1996-2020 Information Builders