search

fecgov / openFEC

The first RESTful API for the Federal Election Commission. We're aiming to make campaign finance more accessible for journalists, academics, developers, and other transparency seekers.
https://api.open.fec.gov/developers
Other
479 stars 106 forks source link

Add disbursement_date in schedule E #5960

Closed hcaofec closed 1 month ago

hcaofec commented 1 month ago

Summary (required)

Add disbursement date in database mv and schedule E endpoint

Required reviewers

1 developer

Screenshots

Screenshot 2024-08-28 at 12 19 16 PM

How to test

  1. Download feature branch
  2. Run flyway migrate to test migration file
  3. Run pytest
  4. In models/itemized.py, switch table ofec_sched_e_mv to ofec_sched_e_mv_tmp_hc, run api on local to check the disursement_dt field in output

http://127.0.0.1:5000/v1/schedules/schedule_e/?cycle=2002&committee_id=C00000422&per_page=20&sort=-expenditure_date&sort_hide_null=false&sort_null_only=false&sort_nulls_last=false