Repository files navigation

Provides a REST server to query and retrieve USDAFoodData Central datasets. You can browse foods from different sources, perform simple searches, access nutrient data for individual foods and obtain lists of foods ordered by nutrient content. A rudimentary authentication/authorization framework is also included. A demonstration site for trying the usage examples below is available go.littlebunch.com. The site uses the Branded Food Products dataset. OpenAPI 3.0 documentation is available as HTML athttps://go.littlebunch.com/doc. The specification can also be retrieved as JSON or YAML from the /docs endpoint described below.

/api -- source for the REST web server
/docker -- files used for building docker images of the API server
/ds -- source for the data source interface. Implementations should also go here
/ds/cb -- couchbase implementation of the ds interface
/ds/cdb -- couchdb implementation of the ds interface (work-in-progress)
/model -- go types representing the data models

I've done versions of this API in MySQL, Elasticsearch, CouchDB and Mongo but settled on Couchbase because ofN1QL and the built-infull text search engine. I've heard it scales pretty good as well. :) It's also possible without a great deal of effort to implement a MongoDb, ElasticSearch or relational datastore by implementing the ds/DataSource interface for your preferred platform.

The steps below outline how to go about building and running the applications using Couchbase. Additional endpoint documentation is provided by a swagger.yaml and a compiled apiDoc.html in theapi/dist path. A docker image for the web server is also available and described below.

The build requires go version 12. If you are using Couchbase, then version 6 or greater is preferred. Both the community edition or licensed edition will work. Or, if you don't want to bother with the go stuff, you can launch a server from docker.io (see below underRunning).

Clone this repo into any locationother than your $GOPATH:

git clone git@github.com:littlebunch/fdc-api.git

and cd to the repo root, e.g.:

cd ~/fdc-api

The repo contains go.mod and supporting files so a build will automatically install and version all needed libraries. If you don't want to use go mod then rm go.mod and go.sum and have at it the old-fashioned way. For the webserver:

go build -o $GOBIN/fdcapi api/main.go api/routes.go

You're free to choose different names for -o binary as you like.

You can also use theDocker file to create an image for the web server.

If you want to useCouchbase then use the ingest utility available athttps://github.com/littlebunch/fdc-ingest.

Configuration is minimal and can be in a YAML file or envirnoment variables which override the config file.

couchdb:     url:  localhost     bucket: gnutdata   //default  bucket      fts: fd_food  // default full-text index     user: <your_user>      pwd: <your_password>

Environment

COUCHBASE_URL=localhost   COUCHBASE_BUCKET=gnutdata   COUCHBASE_FTSINDEX=fd_food   COUCHBASE_USER=user_name   COUCHBASE_PWD=user_password

The instructions below assume you are deploying on a local workstation.

$GOBIN/fdcapi -c /path/to/config.yml  where      -d output debugging messages       -c configuration file to use (defaults to ./config.yml )        -p TCP port to run server (defaults to 8000)      -r root deployment context (v1)      -i username:password bootstrap an admin user and password  -l send stdout/stderr to named file (defaults to /tmp/bfpd.out

Or, run from docker.io (you will need docker installed):

docker run --rm -it -p 8000:8000 --env-file=./docker.env littlebunch/fdcapi

You will need to pass in the Couchbase configuration as environment variables described above. The easiest way to do this is in a file of which a sample is provided in the repo's docker path.

A apiDoc.yaml OpenAPI 3.0 document which fully describes the API is included in the dist path. An html version is available to view athttps://go.littlebunch.com/doc.

curl -X GET https://go.littlebunch.com/v1/food/389714

curl -X GET https://go.littlebunch.com/v1/food/042222850325

curl https://go.littlebunch.com/v1/nutrients/food/389714

curl https://go.littlebunch.com/v1/nutrients/food/042222850325?n=208

Returns list of foods identified by an exploded array of up to a maximum 24 id's. The array may contain a mix of GTIN/UPC codes and FDC IDs.

curl 'https://go.littlebunch.com/v1/foods?id=344604&id=042222850325&id=344606'

curl 'https://go.littlebunch.com/v1/nutrients/foods?id=344604&id=042222850325&id=344606'

curl 'https://go.littlebunch.com/v1/nutrients/foods?id=344604&id=042222850325&id=344606?n=208'

curl 'https://go.littlebunch.com/v1/foods/browse?page=1&max=50&sort=foodDescription'curl 'https://go.littlebunch.com/v1/foods/browse?page=1&max=50&sort=company&order=desc'

Perform a simple keyword search of the index. Include quotes to search phrases, e.g. ?q='"bubbies homemade"'. For more complicated and/or precise searches, use the POST method.

curl 'https://go.littlebunch.com/v1/foods/search?q=bread&page=1&max=100'    curl 'https://go.littlebunch.com/v1/foods/search?q=bread&f=foodDescription&page=1&max=100'

Perform a string search for 'raw broccoli' in the foodDescription field:

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{"q":"broccoli raw","searchfield":"foodDescription","max":50,"page":0}'

Perform a string search for 'corn flakes' in the foodDescription field and limit results to the cereal foodgroup:

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{"q":"corn flakes","searchfield":"foodDescription","foodgroup":"cereal","max":50,"page":0}'

Perform a WILDCARD search for company names that match rond:

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{"q":"ro*nd*","searchfield":"company","searchtype":"WILDCARD","max":50,"page":0}'

Perform a PHRASE search for an exact match on "broccoli rabe" in the "ingredients field:

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{"q":"broccoli rabe","searchfield":"ingredients","searchtype":"PHRASE","max":50,"page":0}'

Perform a REGEX (regular expression) search to find all foods that begin with "Olive" in the foodDescription field:

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{"q":"^OLIVE+(.*)","searchfield":"foodDescription","searchtype":"REGEX","max":50,"page":0}'

Peform a REGEX search to find all foods that have UPC's that begin with "01111" and end with "684"

curl -XPOST https://go.littlebunch.com/v1/foods/search -d '{ "q":"^01111\\d{2,4}684","searchtype":"REGEX","searchfield":"upc"}'

Download OpenAPI 3.0 specification rendered as JSON or YAML

curl https://go.littlebunch.com/v1/docs/json

curl https://go.littlebunch.com/v1/docs/yaml

curl https://go.littlebunch.com/v1/dictionary/NUT

curl https://go.littlebunch.com/v1/dictionary/FGGPC

curl 'https://go.littlebunch.com/v1/dictionary/DERV'

Find foods which have a value for nutrient 208 (Energy KCAL) between 100 and 250 per 100 grams

curl -X POST https://go.littlebunch.com/v1/nutrients/report -d '{"nutrientno":207,"valueGTE":10,"valueLTE":50}'