Avatar

Kintone REST Api Join Operations

Sean R. Harris

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!

Follow 2 followers
0

1 comment

Avatar
Sean Tachibana 0 votes

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:
 
>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.
0
Comment actions Permalink