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!
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.