non db apis partial functionality