Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Consistent 502s hitting /schedule_a #4404

Closed
helgridly opened this issue Jun 7, 2020 · 2 comments
Closed

Consistent 502s hitting /schedule_a #4404

helgridly opened this issue Jun 7, 2020 · 2 comments

Comments

@helgridly
Copy link

The following request is consistently 502ing for me:

https://api.open.fec.gov/v1/schedules/schedule_a/?sort=-contributor_aggregate_ytd&two_year_transaction_period=2016&api_key=MYAPIKEY

If this is as simple as adding an index to fec_fitem_sched_a.contb_aggregate_ytd I can probably open a PR, but if it'll be anything like adding an index for contb_receipt_amt I may take that offer back in a hurry :)

@jason-upchurch
Copy link
Contributor

jason-upchurch commented Jun 8, 2020

@helgridly We will look at investigating the index approach and get back to you! cc @PaulClark2

@PaulClark2
Copy link
Contributor

Hussein - we are in the process of deprecating sort by contributor_aggregate_ytd, #4423. You probably received an email about this.

Sort options that may work for you to pull the data include:

Ascending

contribution_receipt_date
contribution_receipt_amount

Descending

-contribution_receipt_date
-contribution_receipt_amount

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

6 participants