In a Project, go to the datasets list, then click the "+ New Dataset" button, then Network > FTP / HTTP / SSH / SFTP. You can then add URLs of files to use as source for your dataset.
See the documentation on HTTP datasets.
For open data platform that require an API to fetch the data, you can write your own Dataiku DSS plugin to achieve that.