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

Question

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

mywebmasteruk · Answer

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

Oleg Isonen · Answer

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

Oleg Isonen · Answer

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

Oleg Isonen · Answer

filterByFormula={domain}="${system.origin}This looks wrong too, parameters are always key=value&key=value&key=value

Oleg Isonen · Answer

maybe ask AI when you are building things like this

mywebmasteruk · Answer

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

mywebmasteruk · Answer

backticks create invalid URL

mywebmasteruk · Answer

I tried Binding like this too

mywebmasteruk · Answer

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

Join the Webstudio community

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