Incorporating USDA Organic Database API

Using farmOS
1

How can the FarmOS Organic module be expanded to pull in the USDA database information through its available API?
Within an Organic production system, operations need to verify that all suppliers and ingredients used in their end agricultural product have been properly certified to provide the ingredient in question. Verification steps by the operator should include interrogating the USDA Organic Integrity Database to ensure the supplier is certified AND that the purchased ingredient is properly listed in the suppliers certification. It would be really great to have FarmOS include a Supplier list capability that incorporated the USDA database information. Ideally this includes cross checking the FarmOS Seed Asset information against the USDA database record.

Just a FarmOS user trying to reduce the fat fingering. Tossing this out for consideration.

Organic INTEGRITY Database

1 Like
2

This is a great idea @graffte. I’ve never used that API before… curious what it provides! I found this page that’s aimed at developers with more info:

https://organic.ams.usda.gov/integrity/Developer/APIHelp

3

Hi, I came across this thread and wanted to share if anyone else getting here find this useful - I built a standalone tool that does exactly what you’re describing here. It syncs the full USDA OID export nightly, lets you add specific suppliers, cross-checks their certification status and certified items, and alerts you on any status change. It’s called HandlerWatch (handlerwatch.com). It’s not a FarmOS integration, but it solves the same problem. Happy to answer any questions if it’s useful.

1 Like