I hope this message finds you well. I've been exploring the possibilities of integrating OpenRefine into a web application for a project I'm working on. I find OpenRefine's data cleaning capabilities incredibly useful and would love to offer this functionality directly within our application.
I've done some initial research, but I wanted to reach out to the community to see if anyone has experience or insights into embedding OpenRefine in a web environment. Are there any existing APIs or libraries that facilitate this integration? Any best practices or resources you could recommend would be greatly appreciated.
Thank you in advance for your help, and I'm looking forward to hearing from you!
Have you checked the documentation on the OpenRefine API: https://openrefine.org/docs/technical-reference/openrefine-api? You can create a project with POST and push data to OpenRefine. After your edits you can export the data with another POST request to csv and other formats - for example to add altered data to the original project. I tried it once with a python script and it worked fine although I never used it in a productive workflow up to now.
You could also use the ReconciliationAPI (Reconciliation API | OpenRefine) with your web environment as a service for an OpenRefine project if it fits to your use case. To get an idea of this way try for example Reconcile-csv - join dirty data - Open Knowledge Foundation Labs