API connection to Power BI, filtering

[MarcelkoL]

First, I am not much experienced with API. I do have my API key and I am able to connect to a table, e.g. general table. It appears the API has a 20K limit, which from another post here I undertand can be addressed with pagination. However, this may not be even needed, if I could filter the data to start with. My question: is filtering via the url a possibility? I am trying to get the data to Power BI or Excel and I my out put would be less then 20K records once filtering is applied. Thank you! Marcel

[jadudm]

Hi MarcelkoL,

I hope you found our API documentation; it seems like you have: https://www.fac.gov/api/

The FAC API is powered by the open source tool PostgREST: https://postgrest.org/en/v12/

So, it should be the case that almost anything the PostgREST documentation says you can do... you can do.

The API does have a 20K limit, and paging through is the approach. If you take 20K records at a time, you will eventually run a query that returns an empty JSON list (or [ ]). At that point, you should stop, because you will not get any more results. The limit and offset values (either passed as a header or URL parameter) are your friend here for pagination.

You can filter on every field, in many different ways!

https://postgrest.org/en/v12/references/api/tables_views.html#operators

For example, you can search the general table for a date range of accepted audits. Here are the audits submitted from Monday of this week (inclusive) to Thursday:

https://api.fac.gov/general??fac_accepted_date=gte.2025-04-14&fac_accepted_date=lt.2025-04-18

returns 474 results when I run it.

There is a very rich set of operators, and you can use every field in every endpoint to search.

We sometimes miss discussion questions here; we also recommend using our helpdesk: https://support.fac.gov/hc/en-us.

[MarcelkoL]

Thank you Matt, very much appreciated!