I was able to do similar things and other vibecoding tools, so I assumed Glide West could do it as well. It did take a bit of prompting, but eventually got it working (the biggest hurdle was that the API is not well documented).
When I recommend perhaps is to create a standalone utility app (Glide) these instruments) whose only purpose is to fetch data from the API and sync the data tables.
Since data is shared across all apps in a singular project, you can dedicate this app to syncing data, and the other apps can just be user interface