fix a bunch of sheet view tests, use render, fix a url tag.
fix api views tests incl transaction stuff