How to POST nested list of objects into seperate table?

Answered

Hi all

I am new to Xano and I am trying to recreate some of my old endpoints in Xano to see what is possible. What I want to accomplish is as followed. A user registeres and selects a few activities they want to partake in. In my old NestJS endpoint I have this data request:

{
  "Name": "John Doe",
  "Email": "[email protected]",
  "Entries": [
    {
      "Activity": 1,
      "Amount": 1,
      "Price": 15
    },
    {
      "Activity": 2,
      "Amount": 2,
      "Price": 30
    }
  ]
}

So I want to recreate this in Xano where Name, Email should be written in table Register, and the list of objects Entries should be written to a table Entry where each object is a new record. Ideally each Entry should have a reference to the Register table (like each Entry record should also have the ID of created Register)

So how should I create my POST endpoint where I write to both tables? Is this possible? Should I create a column with a reference to Entry table in my Register table and is type object and structure list okay for the reference?

3 replies