Help

API GET request with fields in query string failing

Topic Labels: API
733 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

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

https://codepen.io/airtable/full/MeXqOg

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

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