API - Invoices & Custom Fields

Daniel Maxwell

Is there a way to get custom fields for all invoices without having to make individual calls to the API for each invoice. I specifically need one of our custom fields at the moment for each invoice that might or might not have it and for 493,084 invoices I do not want to even attempt that may API calls.

GL > Projects (Search) includes custom fields in the results and that was the endpoint I used to get our complete project list out of FE. Something similar for AP > Invoice (List) would be ideal.

Alex Wong

@Daniel Maxwell
You can “kind of” achieve this using Query API.

method one, iterate through all invoice custom fields category using adhoc querying: criteria on each invoice custom field category's import id being not bank, and output the custom field's value (description), comment, date, etc.

method two, create ONE query (no need to loop for each custom field), where you criteria on each custom field category's import id being not blank using OR:
Inv CF Cat1 import id not blank
OR Inv CF Cat2 import id not blank
OR Inv CF Cat3 import id not blank

then output ALL the invoice custome fields' value (description), comment, date:
invoice system record id
Inv CF Cat1 description
Inv CF Cat1 comment
Inv CF Cat1 date
Inv CF Cat2 description
Inv CF Cat2 comment
Inv CF Cat2 date
Inv CF Cat3 description
Inv CF Cat3 comment
Inv CF Cat3 date

in your api calling app (power automate flow or other high code app), you will filter the data result from the query to “un-pivot”

Daniel Maxwell

@Alex Wong Wonderful! I'm just starting to try to tap into the Query API and have found it very powerful, but still hitting walls.