Importing external API data to Xano database without creating duplicate records

Rand

I’m trying to import an external API to my Xano database and update the database when records are updated in the external API.

I tried using the forEach tutorial (https://youtu.be/rdnuW2Vg8aA), however, when I repeat the Get request to the external API in order to get the most up to date fields, it duplicates the entire dataset in a new set of table IDs rather than overwriting the previously imported ones / updating them.
 
I’d also like it to import any newly created records as well as updating existing ones with updated fields.

Hope this makes sense on what I’m trying to achieve. Any guidance would be very helpful 🙂

Felipe Letelier

Hi Rand,

You have to use the action "Add or Edit Record" and pass the unique reference field to identify if it exists or not in your table (like its unique id or an unique tag/name).[image.png]

Rand

 thank you! I literally just discovered and tested that feature as you were posting this and it worked a charm!