As far as I can tell, each of the cloud storage providers uses its own API. In Windows, you install some software that uses the corresponding API to perform the file downloads. So the functionality is not built into Windows, but rather depends on custom software from each provider.
In the case of OneDrive, you can find the API documented here.