There’s got to be a way to easily mash data from an API with an external list without too much programming. This video explains an idea for a product called OpenAPIMasher, which allows a user to mash a CSV file with data from an API. It uses a client-side HTML5 database for confidentiality. And to make the application more secure, it deletes that data store when the user confirms the mash is complete.
If you would like to contribute to the project or use the project, please leave a comment.
The drawings referenced in the video are available at: http://L.companydatatrees.com/spec-openapimasher