Updating Categories via API / Better solution?
Our team has a website runnning on Runway. It is for a national US restaurant chain with 400+ locations.
Currently, visitors have the ability to select their closest location and a default is automatically selected based on IP address. This location data is stored in the same database as the perch but just in a table called locations. We have a perch addon that fetches JSON data from an API and dumps these locations in a table called locations. Each location has a unique ID that never changes.
Ideally, we'd like to be able to update the perch app to be a bit better integrated into Perch so that when it dumps the locations into the table, it also creates/updates categories that can be used as fields on any type of content.
Is this feasible? Is there a better solution?