Unable to create a record with a relational object field (many to many)

Answered

Hey folks! Trying to do what I think is a super simple thing in Xano, but having some difficulty. Thanks for your help in advance.

I have a table POSTS related to another table TECHNOLOGIES via the Object field. I chose object because I don't expect a post to have more than two or three technologies related to it.

All I want to do is create a new post and link the technologies appropriately. I'm in the debugger for the /post (POST) endpoint.

Function stack & variables:

The Input Schema auto-offered by Xano in debugger:

The schema filled out:

The response:

New record is created, but the technology does not save. How it looks in the db:

Now clicking into that cell:

It's most certainly to do with the schema I chose in that technologies array, or somehow I'm not linking the object correctly in metadata.

I tried replacing 'technologies_id' with “id” in the Run & Debug technologies array. I tried making the technologies array all full technology objects (i.e. with id, name, etc.). No dice.

What's the standard approach here? Thank you!

1
3 replies