Focal Point
[CLOSED] WebFOCUS REST Adapter: Reporting against paginated results

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

September 03, 2020, 10:20 AM
amyakeith
[CLOSED] WebFOCUS REST Adapter: Reporting against paginated results
We're exploring using the REST adapter to report against data from a third-party application. This application paginates its results, so we would need to make a separate HTTP request for each page to get the data. Metadata in each response will tell us the total number of pages. Ideally, we want a report to show us all of the data at once. My impression is that the REST adapter is used to report against the data returned from a single response. Would it be possible to use the adapter to report against a variable number of consecutive responses and display all of the data from those responses?

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


WebFOCUS 8206, Windows, All Outputs
September 03, 2020, 01:34 PM
FP Mod Chuck
amyakeith

Which 3rd party application are you accessing? When you create a REST adapter connection you give it the base URL of the application and then create a WebFOCUS master file to access it. The results coming back depend on the response part of the master file so it is hard to predict how WebFOCUS will behave without trying it. You may want to open a case with techsupport and discuss this with them. If you don't currently license the REST adapter you can talk to your account rep about a trial.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
September 03, 2020, 02:03 PM
amyakeith
Hi Chuck,

Thanks for the info. I didn't know that it might be possible to do a trial. We want to report against data from a curriculum management software called Curriculog, which is developed by DIGARC. We're looking at the adapter as an option.


WebFOCUS 8206, Windows, All Outputs
September 03, 2020, 03:07 PM
FP Mod Chuck
amyakeith

I searched for Curriculog and got no hits of anyone trying that before. Talk to your account rep I am sure they will allow you to give the REST adapter a try.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
September 06, 2020, 02:22 AM
Efrem
Automatic Pagination is currently not available with the REST Adapter.
It is something that's on the Development list.
It is currently possible to simulate the Pagination within a WebFOCUS Report using Dialogue Manager.

I agree with Chuck.
You should open a case with Techsupport giving information on how the response of the Initial REST request shows the pagination in the Response and what is expected on the Pagination request.