Skip to contents

Provides cumulative receipt totals by entity type, over a two year cycle. Totals are adjusted to avoid double counting. This is the sql that creates these calculations.

Usage

fec_get_totals_by_entity(
  cycle,
  sort_nulls_last,
  per_page,
  sort_null_only,
  sort_hide_null,
  sort,
  page,
  api_key = Sys.getenv("FEC_API_KEY", unset = "DEMO_KEY")
)

Arguments

cycle

Filter records to only those that were applicable to a given two-year period.The cycle begins with an odd year and is named for its ending, even year.

sort_nulls_last

Toggle that sorts null values last

per_page

The number of results returned per page. Defaults to 20.

sort_null_only

Toggle that filters out all rows having sort column that is non-null

sort_hide_null

Hide null values on sorted column(s).

sort

Provide a field to sort by. Use - for descending order.

page

For paginating through results, starting at page 1

api_key

An API key provided by the API provider. This key is not clearly documented in the API description. Check the API documentation for details.

Value

BKTODO: Return descriptions are not yet implemented in beekeeper