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] IBI Support Consuming Web Services

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] IBI Support Consuming Web Services
 Login/Join
 
prodrigu
Platinum Member
posted
We are working of an complex routine for sorting and filtering data within a Java based application. This logic would be difficult to accomplish in SQL, and it would not be desirable to duplicate the logic. We have the ability to expose the resulting data from our application server in either XML or JSON format. We would like to know if the IBI server is capable of making a call directly to our server ( HTTP GET request w/w parameters) to retrieve the data, and format the data as required into a report. Essentially our server, and application would be the source of the data for the report.

Would it be possible to do this with our version and configuration? And are there examples of how to do this available through the vendor?

Thanks,
prodrigu

This message has been edited. Last edited by: <Kathryn Henning>,


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
 
Posts: 121 | Location: California | Registered: June 19, 2008Report This Post
<Kathryn Henning>
posted
Hi prodrigu,

I see that you've got an open case for this question. Please keep us updated on the outcome.

Thanks and regards,

Kathryn
 
Report This Post
Efrem
Platinum Member
posted Hide Post
Prodrigu,
The functionality you're asking about is available with the REST Web Services Adapter.
The REST Adapter has the ability to make GET and POST calls with parameters.
The adapter supports both XML and JSON responses.
My guess is that this would meet your requirments.

But, the REST adapter was released with the 7705 version of the Reporting Server.
So, you would need to be on this version and license the REST adapter.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
prodrigu
Platinum Member
posted Hide Post
Efrem,

Do you have an example using the REST Web Services Adapter with either XML or JSON responses?

Thanks,
prodrigh


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
 
Posts: 121 | Location: California | Registered: June 19, 2008Report This Post
Efrem
Platinum Member
posted Hide Post
Yes.
Here's a call to a public REST Web Service:
http://api.geonames.org/postal...ows=10&username=demo

You might have an issue using username=demo.
You would then need to create your own username by going to http://www.geonames.org/export...tml#postalCodeSearch .

With the REST Adapter in the 7705/800x Reporting Server, you would add a REST adapter connection string with the BaseURL equal to http://api.geonames.org .

You would then run Create Synonym on that REST Connection and fill in the following values:

Service URL Extension: postalCodeSearch

Service URL parameters: postalcode=10121&country=US&maxRows=10&username=demo

Check Validate and Uniques.

Put in a Synonym name and click Create Synonym.

The Master would then be created.

You can then create a report against the response and pass the input values in the form of a WHERE/IF.

Hope this helps.

Efrem
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
prodrigu
Platinum Member
posted Hide Post
Efrem,

How would the code look within the .fex file when calling a REST Web Service?

Thanks,
prodrigu


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
 
Posts: 121 | Location: California | Registered: June 19, 2008Report This Post
Alan B
Virtuoso
posted Hide Post
The focexec is like any focexec, the postal code example is a very simple example:
SET END_OF_TEXT=' '
TABLE FILE jsonname
PRINT
   HEADER COUNTRY POSTALCODE
WHERE (POSTALCODE EQ '10121') AND (COUNTRY EQ 'US') AND (USERNAME EQ 'myusername')
END


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report 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] IBI Support Consuming Web Services

Copyright © 1996-2020 Information Builders