Merge cms data with eternal api data

Hi, so i want to know if how i’m thinking about it would work or if there is a better way to do it.

I got an eternal api, for example about movies, and want to show that on a rg. I also have additional data in the bubble db that should be linked with whatever movie i pull in from the api.

How could i best achieve this? Would it be possible to store the unique movie id from the external api in bubble db along with my own data. And when a call is made to the api check for the unique id in the bubble db and merge that data together in the rg?

Or if there is a better way to achieve this please let me know.