Help

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

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

353 0
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