API Connections

API Connections

The Division of Finance is currently working on establishing the platform, security and procedures for API connections to FINET. While we hope to be able to open FINET API in the near future, at present we are in the very preliminary stages of this work and API's are not currently available for use.  

    • Related Articles

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • Linking a Commodity Code to a Warehouse

      This is the process to add a commodity to a warehouse. Step by Step Instructions: 1.)  Go to INVN (Inventory Maintenance) Table 2.)  Select the appropriate warehouse 3.)  Select Insert 4.)  Select the commodity code you are looking to tie in

    • ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL

      Problem An error is received when trying to access. ODBC call failed  Specified driver could not be loaded due to system error 126: The specified module could not be found. (Adaptive Server Enterprise, C:\Sybase\DataAccess\ODBC\dll\sybdrvo.dll)(#160) ...

    • QRG - Inventory Freeze and Inventory History

      Description and Purpose To assure accuracy, Inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count. However, ...