exposing (store) RETS 1. data as odata, with authentication


We added the 32-bit power query addin to our Excel 2013 tool. We also saved to our office 365 sharepoint “bi” subsite (of sharepoint online) our excel workbook, within which we had loaded the results of an RETS 1.0 query issued by the Microsoft Query tool – as feature of traditional Excels “data” centric tools. This uses the “licensing” and websso session held in the office 365 cloud for “netmagic” by the (licensed) excel tool itself. This is actually the user known as admin@netmagic.onmicrosoft.com.

image

Once sees that a basic odata feed emerges straightaway:

image

The data (preloaded, and static) is then available from the “table” based odata feed – but only to those on the access control list set by the owner of the document, in sharepoint, and those who have authenticated (to sharepoint/odata) using the Netmagic websso process:

image

https://netmagic.sharepoint.com/bi/_vti_bin/ExcelRest.aspx/Shared%20Documents/Barstow.xlsx/Odata/Table_Query_from_Barstow

Advertisements

About home_pw@msn.com

Computer Programmer who often does network administration with focus on security servers. Very strong in Microsoft Azure cloud!
This entry was posted in odata, RETS. Bookmark the permalink.