API tweaks

Initial work on API and looking at indexes for query patterns.
i'll recreate with a migration reset - thanks