API GET request with fields in query string failing

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

the url I am using (In Power Automate Desktop) is{"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


2 Replies 2
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.

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

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