Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Trying to Do GET request from Power Automate Desktop. Having URL Encoding problem

389 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

I have tried to URL encode my URL. In Power Automate Desktop The URL value is presently evaluated as:

https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={Root}=Can't Process: Missing Acct #

where Root is the name of a field.

In Power Automate Desktop, I am am getting an invalid filter by formula error.

Am I missing quotation marks?

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think the formula might need to look like this: 

 

%7BRoot%7D%3DCan't+Process%3A+Missing+Acct+%23

 

And so the full URL would be:

https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula=%7BRoot%7D%3DCan't+Process%3A+Missing+Acct+%23

Try using Airtable's API encoder to help: https://codepen.io/airtable/full/MeXqOg