...

var query = servoyApi.getQuerySelect(foundset.getDataSource());

getMediaUrl is used to generate a url from a byte array so that the client can get the bytes from that url (available starting with Servoy 2019.09)

var query = servoyApi.getMediaUrl(bytes);

getDatasourcePKs is used to generate a list of primary keys names for the given data source (available starting with Servoy 2021.06)

var query = servoyApi.getDatasourcePKs(datasource);

Logging

Inside the server side scripting file of a component/service you can log messages using " console ", not application,output. The output will appear in developer's console view as well as in the application server log file (depending on configured logging levels). For example:

...