Traverse references in API requests

Developers
1

Really enjoyed the webinar on 2-way references. I had some questions and was directed to ask here :slight_smile:

Is there a way in the REST API to:

  • traverse references (return referenced records with records)
  • filter based on referenced table values

(The usecase currently in mind is headless CMS)

2

If you know SQL you can pull out anything using JOINs with the /sql endpoint:

The regular endpoints don’t give a way to traverse references. You could add extra columns with formulas that prepare the data you want, and then read from those (or filter by them). The RECORD function can be useful, since it has an expand_refs level:

1 Like
3

Thanks for the quick response!

re: SQL I’ll give it a play, sounds very powerful

re: Formula columns, also very interesting, for canned rollups sounds very useful.