Skip to main content
ISI Middleware

GCM

ISI Middleware

Script that fetches data from SQL Server using OCR and sends to external API for automated inventory tracking.

Developed a middleware script that fetches data from SQL Server ISI_Stock table using OCR, then sends processed data to an external API via POST requests.

Key features include pyodbc database connectivity, SMTP email alerts, ISIPost and PostData functions, and a 100-minute automated scheduling loop.

PythonSQLOCRAPI