I’m new to Baserow so to help myself learn it, I built one of my more complex workflows in it: dynamic field watchlists (e.g. allow users to “subscribe” to updates to a particular subset of fields across any table/database in the workspace).
This was pleasantly easy to do with Baserow and n8n, with one caveat: querying data with a collaborator field returns an array of objects like so:
- user id
- user name
when I really needed:
- user id
- user name
- user email
To send out emails to people based on their watchlists, I had to separately query every user in the workspace using the https://api.baserow.io/api/workspaces/users/workspace/{workspace_id}/
endpoint, then merge that data with the columnar data returned through the regular REST api just to get the email associated with the tagged user(s).
For reference, here’s what the extra query looks like in the n8n flow. It’s a workflow that I plan on making a separate post as some may find it useful, but it could be a bit simpler if the REST api returned user emails too!