Focal Point
[SOLVED] Master for RUN Web Service (REST)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9447051886

October 26, 2017, 03:42 PM
WFConsultant
[SOLVED] Master for RUN Web Service (REST)
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
October 30, 2017, 11:35 AM
FP Mod Chuck
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
October 30, 2017, 04:06 PM
WFConsultant
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
October 31, 2017, 01:13 PM
Efrem
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.
November 01, 2017, 05:24 PM
WFConsultant
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
November 01, 2017, 06:07 PM
Efrem
I still need to know the error you're receiving so I'm able to determine where the problem is.

Efrem
November 02, 2017, 09:59 AM
WFConsultant
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
November 02, 2017, 11:53 AM
Efrem
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
November 02, 2017, 12:56 PM
WFConsultant
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
November 02, 2017, 01:36 PM
Efrem
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