Is there a way to setup a data source that pulls data directly from an api, if possible what are the required dependencies?
You would have to build your own connector to talk to whichever API you are trying to connect to. We have example connectors and their source code available at the Dremio Hub.