Skip to contents

Retrieves filer information from the FFIEC Central Data Repository API for the ID RSSDs and submission date and time of the reporters who have filed after the provided `last_update_date_time“ and whose new filings are available for public distribution.

Usage

get_filers_submission_datetime(
  user_id = Sys.getenv("FFIEC_USER_ID"),
  bearer_token = Sys.getenv("FFIEC_BEARER_TOKEN"),
  reporting_period_end_date,
  last_update_date_time,
  as_data_frame = TRUE
)

Arguments

user_id

(String) The UserID for authenticating against the FFIEC API.

bearer_token

(String) The Bearer Token for authenticating against the FFIEC API.

reporting_period_end_date

(String) The reporting period end date, formatted as "MM/DD/YYYY".

last_update_date_time

(String) Filter for records updated since this date/time. See `Details` for formatting options.

as_data_frame

(Logical) Should the result be returned as a tibble? Default is `FALSE`.

Value

A list containing the parsed JSON response from the API, where each element in the list represents an RSSD ID value. If `as_data_frame = TRUE`, then the list is converted to a tibble (and returned as such).

Details

Set the `last_update_date_time` value to the last time you ran the method to retrieve only those institutions that have filed a newer report. Possible formatting options include:

- "04/15/2025" - "04/15/2025 9:00 PM"

References

https://cdr.ffiec.gov/public/Files/SIS611_-_Retrieve_Public_Data_via_Web_Service.pdf

Examples

if (FALSE) { # \dontrun{
# Assume you have set the following environment variables:
# - FFIEC_USER_ID
# - FFIEC_BEARER_TOKEN

# Retrieve filers since 2025-03-31, as of 2025-04-15 and return as a tibble
get_filers_submission_datetime(
  reporting_period_end_date = "03/31/2025",
  last_update_date_time = "04/15/2025"
)

# Retrieve filers since 2025-03-31, as of 2025-04-15 21:00:00.000 and return
# as a list
get_filers_submission_datetime(
  reporting_period_end_date = "03/31/2025",
  last_update_date_time = "04/15/2025 21:00:00.000",
  as_data_frame = FALSE
)

} # }