we are using Pega 25.X and Is there any way to use REST APIs to get the data along with report definition rule , Is there any way and limitations ? Also, does the chart option works only when data is being fetched from the database? thanks
Have you thought of using aggregate source Data Page? Call both data sources, RD as well as API via DPage and merge them using a Response Data Transform. In the Data Transform, loop through the results and use the Append and Map to action to add the REST API data to your Report Definition records.
Alternative Options:
Data Flow: Use the Merge component in a Data Flow if you need to do complex data transformations or join thousands of records based on a unique ID
Activity: Use an activity to run pxRetrieveReportData to fetch the Report Definition, call the REST API, and use the Page-Merge-Into method.
My question was how to use all the graphs and charts and pxretreivereportdata will have to be customized it seems for the rest call but how pagination , graphs, charts etc would work ? any idea? thanks
The best bet is to use data_view DX APIs to pull the data from tables, however it’s not possible through return the charts/graphs. I don’t think APIs can pull in the charts/graphs unless you’re converting to an attachment.
Thank you, yes that was the doubt before deciding the design !!