openprescribing data Downloader App
Budget: $30 – $250 USD
I need a small Windows desktop utility that automates downloading prescribing data from the OpenPrescribing API. The workflow is straightforward: I will place a plain-text file in a folder; each line of that file contains one BNF code. When I click “Start” in the app, it should loop through every code, call
https://openprescribing.net/api/1.0/spending_by_org/?org_type=sicbl&code={CODE}
download the CSV returned by the API, and save it into an output folder I choose, using the exact code as the filename (e.g., 0602010M0AAAZAZ.csv).
Essential needs
• Windows-only build.
• Simple graphical interface: a field to browse for the text file, another to choose the destination folder, a “Start” button and a progress indicator (percentage or per-code status is fine).
• Robust error handling—if a code is invalid or the request times out, log the issue and move on so the run finishes.
• No browser automation; use a direct HTTP request so the process is fast.
• Clean codebase that I can recompile later if needed (Python with tkinter, C#, or any language that produces a single-click Windows EXE is acceptable).
Deliverables
1. Compiled Windows executable.
2. Read-me or brief video showing how to run it.
3. Full source code with comments so I can maintain or extend it.
I’ll test by feeding four sample codes; if each produces a correctly named CSV in the chosen folder, the job is complete.
https://openprescribing.net/api/1.0/spending_by_org/?org_type=sicbl&code={CODE}
download the CSV returned by the API, and save it into an output folder I choose, using the exact code as the filename (e.g., 0602010M0AAAZAZ.csv).
Essential needs
• Windows-only build.
• Simple graphical interface: a field to browse for the text file, another to choose the destination folder, a “Start” button and a progress indicator (percentage or per-code status is fine).
• Robust error handling—if a code is invalid or the request times out, log the issue and move on so the run finishes.
• No browser automation; use a direct HTTP request so the process is fast.
• Clean codebase that I can recompile later if needed (Python with tkinter, C#, or any language that produces a single-click Windows EXE is acceptable).
Deliverables
1. Compiled Windows executable.
2. Read-me or brief video showing how to run it.
3. Full source code with comments so I can maintain or extend it.
I’ll test by feeding four sample codes; if each produces a correctly named CSV in the chosen folder, the job is complete.