Answered

Having problem With URL Ecoding ( all of a sudden)

(0) Share

Report

Posted on by Steve48

431

This problem seems to have started after a recent PAD update. I am doing an Invoke Web Response action, a GET to the Airtable API.

My URL is %TargetURLForCaseStatus%?filterByFormula={Root}="%CaseStatus%"

Root is the name of a field in an Airtable table. I believe this was recently working but I am now getting an invalid filter error.

The value of CaseStatus is:

Can't Process: Missing Acct #

As a test, I hard-coded the value of CaseStatus to just the letter A, making the error disappear. So it seems as if URL encoding is suddenly needed. How do I fix this?

My flow does not have PowerFx enabled

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Steve48 431 on at

Like (0)

Report
Copy link

Link copied!

I am the OP. The following works in Postman. How do I replicate in PAD?

Was this reply helpful? Yes No
eetuRobo 4,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you show your flow and your variables?
When making the CaseStatus -variable remember to have the text inside %''% so PAD knows it to be text and does not try to interpret % -signs as opening and closing variable symbols.

So like this: %'%22Can%27t%20Process%3A%20Missing%20Acct%20%23%22'%

I obviously cant access the api without authentication but something like this maybe:

Was this reply helpful? Yes No
Steve48 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @eetuRobo
In Postman the GET works with this URL
https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={Root}=%22Can%27t%20Process%3A%20Missing%20Acct%20%23%22
My FullURL presently evaluates to:
https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={"Root"}="Can't Process: Missing Acct #"
and Get Invalid filter by formula Error
Note that CaseStatus can have about different values so don't want to hard code each possibility.
Screenshot of flow
This is what one of the replacements look like

Was this reply helpful? Yes No
Verified answer

Steve48 431 on at

Like (0)

Report
Copy link

Link copied!

I am the OP. I finally got it to work with the help of Claude AI from Anthropic. I could be wrong but I think my flow was working without the need for this change. Did Microsoft do anything in a recent update that would affect URL encoding?

Was this reply helpful? Yes No