public api add a relationship

[oswaldB]

Hello,

I hope you are doing well.

I am currently trying your api and using your readme app. A simple question how can I add a relationship in my rows?

thank you

[melohagan]

Hello @oswaldB

Here's the docs on relationships: https://docs.budibase.com/docs/relationships

If you want to display the columns of a relationship in the same table, then you can use formulas: https://docs.budibase.com/docs/formula#fields-from-relationships

[melohagan]

Sorry @oswaldB

I initially misread your question, you want to handle relationships with the API.

If you do a GET on a table with a relationship column, you'll see something like this:

You can use the same payload in your PUT to update an existing table to add a link type column if it does not already exist.

To update or add rows with a relationship, you can do a PUT or a POST with the name of your relationship column like so:

In this case you'd replace relationship with the field name: product

https://docs.budibase.com/reference/post_tables-tableid-rows