Get a friendly url (uuid or slug) for a dynamic page, when using Baserow API

Ask us anything How do I?
1

I would like to have friendly urls (through slug) or confidentials urls (through uuid).
In this thread & tutorial from @Joyce , it shows how to do it with Supabase, via filters on a GET request call for the list of items.

But I’m using the REST API of Baserow, for which I’ve never seen any editable filters after the GET request call. Just the message saying “Collection must be an array”

Capture d’écran 2024-09-20 à 18.45.06
Capture d’écran 2024-09-20 à 18.45.06722×1270 50.7 KB

So how could I get my dynamic pages to

  • use, as url path params, the record slug or uuid (or name or any field who is not the id field)
  • while, in Baserow, the API GET request call for a single record expects the row_id
  • and there’s no way to filter a GET request in the API call ?
2

Found it. :upside_down_face:

In case anyone struggles with it in Baserow, based on the tutorial:

1 - in the dynamic page url path, add a variable : params (slug) and the default value (gecamines)

Capture d’écran 2024-09-20 à 20.08.40
Capture d’écran 2024-09-20 à 20.08.402080×1292 207 KB

2 - at the end of the GET request call (for listing the records), add : the id of the field, contains, and the params : https://api.baserow.io/api/database/rows/table/43297/?user_field_names=true&filter__field_YOUR_FIELD_ID__contains=123456789 (see syntax details here in Baserow community)

Capture d’écran 2024-09-20 à 20.04.56
Capture d’écran 2024-09-20 à 20.04.562002×1308 374 KB

Hope it helps.

4

Happy it could help you, @abuislam !