Updating a table in Google Cloud SQL using a third party API

Question

This feels like a noobish question to which I should be able to find the answer on the web, but after hours of searching, I still came up empty handed. The problem probably lays in the fact that I don't know exactly what I'm looking for. What I'm trying to achieve seems simple enough: update a specific table in database that I successfully migrated to a 2nd Gen CloudSQL Instance using a suppliers API. This table contains product information from products from this particular supplier. Constructing the correct URL (with username, password and language) returns me the data in XML format (in my browser) So, basically my question is which path I should follow to get this data in the Google hosted database ? Do I have to programmatically parse the XML file (i.e. using python) in the Cloud Console, updating the database table this way ? I've also been looking in google-cloud-firestore direction... I assume there is a more direct way doing this ? I suppose all I need is a useful link that will get me on my way. Thanks ! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

GCP console doesn't have a way to manage your data inside of your database instance. But, you can do that using any database tools like DBVisualizer + Cloud SQL Proxy.