Kintone REST Api Join Operations

Can you run join operations (inner join, left join, etc) between 2 kintone tables using the rest api? Or if you’ve set up related records on a table is there a way to return the related fields in the records.json api response?

Thanks!

Hello Sean,

>Can you run join operations (inner join, left join, etc) between 2 kintone tables using the rest api?

It is not possible to do so since kintone does not have an INNER JOIN, OUTER JOIN, etc. functions.

It is a bit of a process, but please use the GET RECORD API to retrieve the data from both tables, create a table in the target app,

and place the retrieved values in the created table.

 

Get Record:

https://developer.kintone.io/hc/en-us/articles/213148957-Get-Record

 

>Or if you’ve set up related records on a table is there a way to return

>the related fields in the records.json api response?

 

I think the only way to do this is to get the records from the reference source via API.

 

Hopefully, this helps.