I'm currently working withe the Stimulsoft Designer (version 2018.2.2 from 27 April 2018, JS).
I have an application which has a Rest API with the following endpoints:
- https://localhost/api/categories - returns a list of categories
- https://localhost/api/categories/{category-id} - returns a single category
- https://localhost/api/categories/{category-id}/pets - returns a list of pets of that category
I want to get the list of categories and display the category name as a title, followed by the pet names of that category (table).
Then on the next page, again the category name of the second category, followed by the pet names of that category.
So now I have two JSON data sources (one for the categories list, one pets list).
I also know that I can have variables and use them in the path to the JSON data source. But I think this does not solve my problem.
Basically what I want is that the pets endpoint is called multiple times (1 call by category) when generating the report with the category ID.
Since the categories list returned of the first data source is unknown, I can't just add all category pets data sources by hand. This has to happen automatically when generating the report.
My question right now is:
Is there a way to achieve what I want?
(without coding, only configuration)
Thank you in advance.