Budibase API integration with node-red

Hi all!

I'm currently self-hosting both Budibase and Node-red locally. I just wanna ask if it is possible to use Budibase API as a data source for Node-red? If it is possible, how do I do it? I've tried using the https request node but it doesn't return the result that I wanted. Instead of returning a row, it returns this "Redirecting to /." It keeps on redirecting for some reason. Appreciate the help!

Are you setting the right headers etc?

Docs for Budibase API are here: Public API

Yeah, I've already set the headers correctly, I suppose.

msg.headers = {};
msg.headers['Accept'] = 'application/json';
msg.headers['Content-Type'] = 'application/json';
msg.headers['x-budibase-api-key'] = 'xxx';
msg.headers['x-budibase-app-id'] = 'xxx';
return msg;

Me and my colleagues are still figuring out why it returned that.