Can you give an example of file to database and API to database?
As long as the file is a CSV, there are tons of tools already to import them into a DB, isn't it? Are you talking about unstructured files here?
There was no generic solution although I've ended up reusing a lot of code.
One of the first gigs I got was to process about 7,000 pages from a static website, scrape out the relevant data, and plonk it in a database so they could run queries on it. :)
You could probably latch onto a common use case and build a solution for that e.g. Blogger to Wordpress transfer - something I've had to do in the past by building some custom tools. (That was years ago though - I've not looked at current state of play with regards tool availability). Not suggesting that would be your use case though - just an example.
Once I have a list of all the issues, I need to make one request per issue to get further details that aren't included in the original list.
Then I need to extract data from all the downloaded JSON files and combine it into a table.
It's conceptually not a hard problem, but it takes a lot of trial and error to do that if you aren't very familiar with Python.
I wish there was a nice GUI where I could just click a few buttons to do that. Designing that GUI is probably not easy...
Any more examples you can share?