Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

API GET request with fields in query string failing

Topic Labels: API
865 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

kuovonne
18 - Pluto
18 - Pluto

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

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