Hi guys
I am trying to figure out how to set this up and i cant get my head around it. Hope you can help. Here is what i try to do:
I have a bubble app where i have generated some names for items in another system (External System). These names are stored in a table called “generatedNames” where i also have alot of metadata for each name. Now I need to import the names back into my app from the external system. These will now be stored ina. new table, together with metadata from the External System
I have tried importing as a CSV, but from the External System I get a CSV with all the generatedNames from my app, but also some that are generated in the ExternalSystem. When i try importing the CSV, it fails validating because it contains records called generatedName wich does not match a “generatedNAme” from my bubble app.
I need my app to import all matching records and skip all that are noe “generatedNames” that exist in my app.
How can i achieve this?
So basically this flow:
Import CSV to table externalData
Skip all rows from the CSV where “generatedName” is not found in my apps table “generatedName” (which is linked to the table “externalData”
Import all that matches.
Is this even possible?
Caspar