
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