Where to load data from user input

I have a table that gets it’s model data from a rails backend. The table includes some other data from a different database. Where should this data be loaded from?

The table is contained in a component and the table columns are defined there. Should this be done in the route? I don’t want to wait for the data to load before displaying the table either.

The next part is how to load a different column depending on user input? It doesn’t make sense for this to be based around the url.