Relationship within an object to table

EvanLeSage

I am pulling data from an external API into a table. Within that table I have an object called bookmakers with a key for each bookmaker. Because the API doesn't provide a photo, ive created a second table with the photos. I am trying to join the two based on the name of the bookmaker but cannot figure out how

EvanLeSage

Ok got this far but now i'm stuck again. I assume bookm is limited in scope to the loop but i'm at a loss for how I can update the actual entry.

Michael Udinski

Hi @EvanLeSage this actually sounds like the perfect use-case for an Addon! Addons allow you to decorate your response with related data and are designed for these kind of use-cases.

Take a look at the documentation. And also the intro tutorial below:

https://youtu.be/t9qXwFVUZZ0

EvanLeSage

@Michael Udinski Hi, the only thing I can reference by from addons is id, but I don't want to manually line these up since theyre being updated from the api. So I'm still lost as to how I can create the table references based on the matching text "key".

Michael Udinski

Hi @EvanLeSage actually create Addons based on any field. It doesn't have to be the ID. Check out the Addons page in the Library where you have control over the query and inputs. If you are trying to create Xano table references based on a matching field then you can follow this tutorial as an example -

https://youtu.be/hulHk9v3Phk