completed initial view query api