fixed api tests (except spreadsheet-for-report)