Apr 18, 2024 02:17 PM - edited Apr 18, 2024 02:34 PM
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
Apr 18, 2024 05:27 PM
I would try taking a look at this site - it will help you build your endpoint URL and make sure it’s structured correctly.
Apr 18, 2024 06:49 PM
The list of fields should be an array, which is usually indicated by square brackets [] and not curly braces {}.
fields: ["Account No", "Case Descriptive"]