Modifying USASpending

USASpending APIs

Introduction

This page outlines how AM integrates with USASpending.gov and how it allows the solution to reflect the most recent data available.

The base URL endpoint used by the solution is https://api.usaspending.gov/api/. Additional documentation for these APIs can be found here.

USASpending.gov API Endpoints

AM utilizes three APIs to update the award record. The table below lists each USASpending.gov API endpoint and the corresponding Appian object that it's referenced in.

API Endpoint	Appian Object
v2/search/spending_by_award/	AS_AM_SearchSpendingByAward
v2/awards/	AS_AM_GetAwardFromUSASpending
v2/transactions/	AS_AM_GetModificationNumberFromUSASpending

The expression rule AS_AM_CDT_mapDataFromUSASpendToAward is used to call these USASpending APIs and will update the award record. Currently, AM extracts the following API fields in order to update the appropriate award record fields:

USASpending API	Award Field	API Field
v2/search/spending_by_award/	generatedAwardId	generated_internal_id
v2/search/spending_by_award/	agencyName	Awarding Agency
v2/awards/	awardingOffice	awarding_agency.office_agency_name
v2/awards/	fundingOffice	funding_agency.office_agency_name
v2/search/spending_by_award/	awardDescription	Description
v2/search/spending_by_award/	vendor.vendorName	Recipient Name
v2/awards/	vendor.vendorAddress.vendorAddress1	recipient.location.address_line1
v2/awards/	vendor.vendorAddress.vendorAddress2	recipient.location.address_line2
v2/awards/	vendor.vendorAddress.vendorCity	recipient.location.city_name
v2/awards/	vendor.vendorAddress.vendorState	recipient.location.state_name
v2/awards/	vendor.vendorAddress.vendorCountry	recipient.location.country_name
v2/awards/	vendor.vendorAddress.vendorZipCode	recipient.location.zip4
v2/awards/	vendor.vendorAddress.vendorZipCodeExt	recipient.location.zip5
v2/awards/	vendor.vendorAddress.vendorForeignPostalCode	recipient.location.foreign_postal_code
v2/search/spending_by_award/	vendor.dun	Recipient DUNS Number
v2/awards/	fundingInformation.obligatedAmount	total_obligation
v2/awards/	fundingInformation.currentAwardAmount	base_exercised_options
v2/awards/	fundingInformationpotentialAwardAmount	base_and_all_options
v2/awards/	fundingInformation.fundsLeft	total_obligation*
v2/awards/	fundingInformation.fundingAgency	funding_agency.toptier_agency.name
v2/awards/	fundingInformation.awardingAgency	awarding_agency.toptier_agency.name
v2/awards/	keyDates.contractStartDate	period_of_performance.start_date
v2/awards/	keyDates.currentEndDate	period_of_performance.end_date
v2/awards/	keyDates.potentialEndDate	period_of_performance.potential_end_date
v2/transactions/	modificationInformation.awardModificationNumber	modification_number
v2/awards/	naicsCode	latest_transaction_contract_date.naics
v2/awards/	naicsCodeDescription	latest_transaction_contract_date.naics_description
v2/awards/	pscCode	latest_transaction_contract_date.product_or_service_code
v2/awards/	pscCodeDescription	latest_transaction_contract_date.product_or_service_description
awards	awardType	type

USASpending Nightly Sync

AM offers a nightly process to sync with USASpend and update awards changed in USASpending in the last day.

This process model is AS AM Nightly Sync. This process uses the USASpending's API v2/search/spending_by_award/ in the Appian integration AS_AM_SearchSpendingByAwardForNightlySync to retrieve the data that has been updated in USASpending in the last day. We extract all the corresponding awards by querying the AS_AM_AWARD table based on PIID.

Feedback