Open repository in Console
Readme
Updated 1 month ago
‧ Indexed 1 month ago
Business Services - Purchases
This dataset has document information for purchases made in the City of Mesa financial system (Advantage-FIN). Warehouse adjustments and Engineering procurement types are excluded. (Code 800 and 810 as those are Warehouse inventory adjustments; Filter out DO’s made from Master Agreements with Procurement type 11, 12, 13 or 16, Engineering Procurement Types.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"citydata-mesaaz-gov/business-services-purchases-u5x3-dvhs\".\"business_services_purchases\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata