Ok, so I’ve tried to get this answered through the chat function, but maybe someone in the forum have been using Radzen to retrieve SharePoint list data.
I am using the Radzen application on my laptop (dev). I have 3 virtual servers VMWare running on this, 1 DC, 1SQL and 1 SharePoint 2016 Server.
No matter what I do i can’t seem to connect to the list. I’ve tried using Odata and REST, but I’m sure it’s because I’m a total newbie to this I can’t get it to work.
If someone has done this before, I would really appreciate a quick walkthrough on the subject. For the record I both have webapplications on 443 and on 80.
For information purposes, I am trying the following: Application Settings Port 80 ,no https, no Server-Side project.
Edit datasource = Odata Name=Test, REST Endpoint = http://demo.xxx.xxx/_vti_bin/listdata.svc/$metadata
If I set Authorization to none (Send user cred is unchecked) I get the following message “Cannot read property ‘then’ of undefined”.
If I chose HTTP Basic checked/unchecked and then username sp_admin@xxx.xxx and domain\sp_admin or just sp_admin and password I get “Login failed”. What am I doing wrong???
@hasse_1976 in chat you mentioned that you are using HTTPS - does the $metadata return OK in your browser? If yes I would like to see a screenshot of your browser’s Network tab (I am interested in the HTTP headers that are exchanged).
Best regards,
Atanas
Sent you a mail yersterday evening Atanas.
I set up a webapplication running on port 80 (plain http), same result there. I think it was from that query I sent you a png.
Looking foreward to your response 
Atanas, by installing the Radzen application on the SharePoint server.
Adding the url xxxx.xxx.xx/_vti_bin/listdata.svc/ I was able to fetch the data. This makes me wonder if it is not possible to use the host(client) to access the Virtual Machine? Strange as I am able to access the webapplcations from my hosts browser.
@hasse_1976 haven't got any email yet. Could you please try sending it again to info@radzen.com?
Adding the url xxxx.xxx.xx/_vti_bin/listdata.svc/ I was able to fetch the data. This makes me wonder if it is not possible to use the host(client) to access the Virtual Machine? Strange as I am able to access the webapplcations from my hosts browser.
This is strange to me as well. I suspect it is some sort of security issue which your browser handles just fine but Radzen fails to. Hopefully the screenshot will tell more.
