Add API integration tests

[chrisdevereux]

We don't currently have any integration tests covering the API. We need some.

Acceptance Criteria:

• Should run as part of CI test cycle.
• Should not run as part of pre-commit hook.
• Should test all queries and mutations against a real database.