I am working on integrating USAspending API data into a Power BI dashboard, specifically focusing on detailed awards. I'm using the /api/v2/search/spending_by_award/ endpoint.
My objective is to filter awards by a specific "Program Activity" (e.g., "Water Power," code 702526). However, when attempting to include program_activity in the filters object for this endpoint, the API response indicates that this parameter is not used.
Could you please clarify if there is a supported method or an alternative parameter within /api/v2/search/spending_by_award/ that allows for direct filtering by program_activity? If not, is there another endpoint that provides detailed award data and supports filtering by program_activity?
I am working on integrating USAspending API data into a Power BI dashboard, specifically focusing on detailed awards. I'm using the /api/v2/search/spending_by_award/ endpoint.
My objective is to filter awards by a specific "Program Activity" (e.g., "Water Power," code 702526). However, when attempting to include program_activity in the filters object for this endpoint, the API response indicates that this parameter is not used.
Could you please clarify if there is a supported method or an alternative parameter within /api/v2/search/spending_by_award/ that allows for direct filtering by program_activity? If not, is there another endpoint that provides detailed award data and supports filtering by program_activity?