usaspending-api

usaspending-api copied to clipboard

Instruction on launching the api with fully-restored USASPENDING database?

3

Hi, I'm trying to use this API and I have restored the USA SPENDING database on my local postgres database. What kind of configuration should I make to let the...

ReichYang

Looking for an API to get all Sub-Awards and its Details for a given Award_ID_FAIN, instead of AwardID

baleraosreedhar

Maintaining a current copy of the Postgres DB?

1

I maintain a local copy of the full database on a Postgres server, on Ubuntu Linux. For our production processes, it is becoming increasingly important to have the full, _current_...

chorgan182

Bulk download only Award data and not the transactions data

1

Hello, When I use this endpoint: [https://api.usaspending.gov/api/v2/bulk_download/awards/](url) And pass request data as: `{ "filters": { "agency": "all", "prime_award_types": ["A", "B", "C", "D"], "sub_award_types": ["grant","procurement"], "date_range": { "start_date": "2017-01-01", "end_date": "2017-12-31"...

sutharmonil

Where can I find filter parameters for an API call?

4

I would like to be able to use certain parameters for an API call to get the exact information that I want from USA Spending. For example, I would like...

dhope-lab

Endpoint [/api/v2/bulk_download/awards/] prime_award_types parameter not optional?

3

Hi, I am sending a POST request to the [/api/v2/bulk_download/awards/] endpoint with the following body: body = '{ "filters": { **"prime_award_types": ["IDV_A", "IDV_B", "IDV_B_A", "IDV_B_B", "IDV_B_C", "IDV_C", "IDV_D", "IDV_E", "02",...

nicolassander

503 Server Capacity Error

4

# Description of problem When calling the `api/v2/bulk_download/awards/` endpoint in batches overnight, I intermittently receive a 503 response stating `Service Unavailable: Back-end server is at capacity`. # Steps to recreate...

csmcallister

Spending by Award : Recipient ID filter causes 500 Error Code

2

When sending requests to the `/api/v2/search/spending_by_award/` end point I receive an Internal Server Error. If I don't form the request properly (ex. `"recipient_id" : 4`) I receive a `400 Bad...

JordanMurrayFedSav

Ability to retrieve associated offices for each sub-agency

2

This is a new feature suggestion. The ability to retrieve the offices by sub-agency. Essentially, adding another sub-tier to the autocomplete for agencies and the /bulk_download/list_agencies/ end point.

nhinze

Award Type Codes is a required field for endpoint /search/spending_by_award despite documentation

1

Not sure if this has been addressed yet but the spending_by_award endpoint states that award_type_codes is optional however you receive the following when you do not include any type code...

JordanMurrayFedSav