API GET request with fields in query string failing

+4

the url I am using (In Power Automate Desktop) is

https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbljRNXydGMGabTcf?fields:{"Account No","Case Descriptive"}&view=Update Taxes Monthly - Dad&filterByFormula=AND({DNC Case Master} = 0, OR({Taxes Owed Last Updated} = '', {Days Since Taxes Updated} > 60))

This runs without error but returns all fields not just the two I defined

fields: {"Account No", "Case Descriptive"}

I also tried:

fields: {"Account No"}, "{Case Descriptive"}

I am pretty sure I am defining fields incorrectly but not sure what is wrong.

Please advise

TIA

+19

I would try taking a look at this site - it will help you build your endpoint URL and make sure it’s structured correctly.

+29

The list of fields should be an array, which is usually indicated by square brackets [] and not curly braces {}.

fields: ["Account No", "Case Descriptive"]

Sign up