View and Save Multiple Image Binary files from Web API as PNG

Job ID: 33988175

Budget: $250 – $750 USD

We need a tool which can access a local SQL Server database, query a list of unique id values based on a parameter (town name), loop through this list while sending GET requests to the web API in order to retrieve the binary string of each image. We need to access and separately save each image file locally, named by the unique id values retrieved from the database. The API returns a binary string if a PNG.

This tool needs to easily change source databases and repeat the process. It would be beneficial if the source databases could be a parameter table or CSV and the tool could be run via scheduling a batch file to run unattended. Two additional nice to haves would be to resize these images to predetermined dimensions (in parameter table) due to a legacy application unable to dynamically resize these photos. Second nice to have would be a separate code block using JavaScript which could allow a web page to ask for and display the same images one at a time.

Attached is the specifications for this web API. It is currently open to the public, so proceed accordingly.

Thanks!!
Related categories: Python .NET SQL HTML5 Microsoft SQL Server