Blog

Retrieve Dynamic Web Data

Retrieve bank exchange rate in certain time daily, choose the currency needed and capture the latest rate, send the rate via email. Whole process using Microsoft Azure – Function App with python.

DBS Exchange Rate
Email Notification

Crawl Data From Website

Crawl 4D and Toto history result from website using Python, Microsoft Azure, PHP and MySQL. Hosting on Microsoft Azure Serverless – Function Apps, estimate $5 per month.

Python to crawl information from website, Microsoft Azure to host Python script as serverless platform, setup LogicApps as scheduler, and setup PHP portal to display result.

 

Results Portal
Python
Azure
FunctionApps

Simple API with Azure Logic App

Develop an easy API solution to retrieve or write data in on-prem Microsoft SQL Server. The data can be from EDI or from HTTP, both able to configure in Microsoft Azure Logic App. Using HTTP POST to write data, and using HTTP GET to retrieve data from SQL Server. Those using EDI, can be “massaged” to the format needed and pump in to SQL Server.

Whole project needs 1 week. Easy to manage, low cost and error free…

Azure Logic App

Retrieve Orders from Multiple eCommerce Platform

Retrieve Orders from Multiple eCommerce Platform

I have developed a platform to retrieve orders from several eCommerce platform, such as Shopee, Presto Mall, Lazada, Shopify, etc. System will be able to retrieve the orders from each platform and consolidate all in a single file.

Depend how many platform you have, $250 per platform. There is a monthly running cost on cloud act as always-on server to retrieve data from all platforms. The cost is depend the usage, estimate $25 USD per month.

 

PDF to Excel File

Upload PDF to FTP Server and Convert to Excel.

I have setup a FTP server for a customer to capture the DO in PDF format from customer, and convert the PDF to excel, then consolidate to a single excel sheet.

Whole Development only about 3 days, cost is S$ 300.

 

Deliver Order in PDF Format
Convert PDF to Excel File
Consolidate all excel to a single excel sheet