There are multiple solution do it, using rest api, csom, server side code by including Microsoft.sharepoint dll but all will work only, if the user is authenticated or pass the network credentials or User should be in the network/domain itself. Is it possible to retrieve values from different sharepoint onpermises site [without passing the credentials]Read more