How to create a custom list view to show data from third party API?

Hi Junaid Usman ,

Why don't you want to import external data within a custom module ? By going that way, you will get all core sugar's feature for list view (filtering, sorting etc.).

If you decide to build a custom view for external data, how do you want to handle sort, filter, preview, focus drawer ? override them all ?

Maybe a custom dashet  How to build an External API Dashlet will be more convenient ? 

Fred

Hi Frédéric Rinaldi ,

I appreciate your prompt response. I understand your perspective and would have preferred to store data through the intended means. Unfortunately, due to limitations and technicalities, we can't store data received from third-party APIs. Our goal is to provide users with access to specific data related to multiple companies in a list view format based on the parent company. This way, users can review the data and perform assessments based on it.

Therefore, we cannot store external data in the custom module. However, creating a custom dashlet could be a viable option, provided that each API call made to the third-party system is free. We only want to call the API when the user needs to read data and not every time the user interacts with a record within the module.

My idea is to offer a list view to the user once they click on a button to request the data. I know I can create my own list view hbs and js to show the data. However, I am wondering if there is a way to utilize the existing list view functionality to display the data.

Kind Regards,

Junaid

A couple of thoughts:

Have you tried to extend the GET /module API for your use case? You can have a "module" without an actual table. And then fill in the data in the list view with your remote API call.

Have you tried to use a Dashlet to display the remote data?