Is there a way to do this with combining basic auth? or does it have to be done via api authentication? as my current web host will not implement oauth.
The question is not very clear. You dont need to have your web host implement oauth. You could do this with the SDK in your own code. And you need to pass the oauth tokens alongside your call to YQL to access the protected apis.