Knowledge Bank and API node best practice

hi dataiku users,

wondering what is the best practice if i have a knowledge bank that will be used as one of the source of data in one of my API endpoint service?
currently the knowledge bank is still in the designer node and the api is in the api node which sits in different server

i notice sometime the api response return different number of data from the knowledge bank eventhough using the same query and sometime error.

Should the knowledge bank publish in the automation node?

or this issue most likely related with the connection issue?

thanks looking forward to your expertise