Join the Webstudio community

Updated 2 months ago

Filter a list of records from an Airtable resource using the value from system.origin

At a glance

A community member is seeking help to filter a list of records from an Airtable resource using the system.origin value. The community members discuss various approaches, including using the filterByFormula parameter in the Airtable API, but encounter issues with the syntax and formatting. Eventually, a community member suggests a working solution using {domain}="${system.origin}" in the API request, but there is no explicitly marked answer.

Useful resources

mmywebmasteruk

Hey guys, anyone know how I can filter a list records (from Airtable resource) with the value from system.origin. Help is much appreciated.

9 comments

mmywebmasteruk

I used this in the Resource URL https://api.airtable.com/v0/appHWOyP1u7WIu8Yo/test?filterByFormula={domain}="${system.origin}" but no luck

OOleg Isonen

not sure but sounds like you didn't put the string into backticks and you don't need double quotes

OOleg Isonen

Plain Text

`http....${system.origin}`

OOleg Isonen

filterByFormula={domain}="${system.origin}

This looks wrong too, parameters are always key=value&key=value&key=value

OOleg Isonen

maybe ask AI when you are building things like this

mmywebmasteruk

thanks @Oleg Isonen this actually is correct https://api.airtable.com/v0/appHWOyP1u7WIu8Yo/test?filterByFormula={domain}='https://xxx-ws.wstd.io'

but I need to access the dynamic system.origin value

mmywebmasteruk

backticks create invalid URL

Attachment

mmywebmasteruk

I tried Binding like this too

Attachment

mmywebmasteruk

Looks like this worked: https://api.airtable.com/v0/appHWOyP1u7WIu8Yo/test?filterByFormula={domain}="${system.origin}"

Add a reply