Need to Fetch data from external API without storing at database show multiple view

Hhmm curious requirement.

I would say you need to add dummy fields to the views. I would do this with “non-db” fields created directly in the views’ PHP files. But you can also do it with Studio, only this will make you create the dummy fields in the database also.

Then you override the views’ classes so that, when it is about to be displayed, it calls the API and injects the values into the view.

Here is an example of extending the view to calculate a field:

You can do something similar, but instead of deriving a calculation from an existing field, you just call the other system’s API and populate your dummy fields to show the values on screen.