Category Archives: odata

NAR oauth and odata servers

Let’s take a solution and to it add our 2 working projects – an odata feed and endpoint, and an authorization server (with grant management UI, too).     Now we need a client, that can orchestrate the handshake. Advertisements

Posted in oauth, odata

NAR/CRT OAUTH2 server for webAPI

We managed to get the NAR/CRT OAUTH2 server booted and able to serve some pages. On Windows these were the steps we took: 1) we created a node web application (microsoft model, for easy azure hosting) 2) on the npm … Continue reading

Posted in odata

Excel Power Query talking to NAR odata/atom feed; a first experiment

Now that we can issue basic http requests to the NAR webapi server, a set of node.js packages and setup, we configure excel power query to talk to the same server, modified slightly to allow a proxy to intercept the … Continue reading

Posted in odata

datasystem metadata from NAR webAPI server

  THe NAR webAPI server, a node.js package and bootstrap fileset, can be made to do something using the following first test harness:   1. run the node.js server and mongodb instances, per previous research notes. 2. create a fiddler … Continue reading

Posted in odata

Running NAR’s open source webAPI server

We followed some counsel to augment our Visual Studio 2013 installation with “node.js” tools, with a view to running NAR’s open source webapi server. http://www.hanselman.com/blog/IntroducingNodejsToolsForVisualStudio.aspx   We learned about NAR’s open source material from a member’s only resource:   http://members.reso.org/display/TRANSPORTDF/NAR+Open+Source+RecapContinue reading

Posted in odata

Sharing queries over an odata feed, using Rapattoni netmagic.

In the last memo, netmagic users shared query within the netmagic community. The queries were designed to run over tables in worksheets that the user, both sharing-user and shared-user, already had –-having downloaded the excel file with the “source” snapshot … Continue reading

Posted in odata, RETS

Sharing business intelligence queries on RETS sources using netmagic (and odata)

We loaded our sharepoint-hosted “barstow” table into a fresh excel worksheet, having re-enabled the data source and content (from now untrustworthy sources, for some reason). Our next task to move away from the traditional excel world used so far and … Continue reading

Posted in odata, RETS

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 … Continue reading

Posted in odata, RETS

32 bit excel 2013 with 32-bit odbc driver

On Windows 8.1, Lets install the 32-bit ODBC drvier, intending to use the traditional excel data connection:   http://nationalassociationofrealtors.github.io/ezRETS/   Using the 32-bit ODBC console, we take parameters from our SSO Portal and use them to configure the ODBC driver. … Continue reading

Posted in odata, RETS

basic auth vs marketplace credentials

  We see from a (non-excel) consumer of the marketplace services one can build a client class, quite easily:   http://code.msdn.microsoft.com/Walkthrough-Translator-in-7e0be0f7 we see from the code that it wants us to configure the app key, for the azure marketplace account, … Continue reading

Posted in odata

basic auth and odata feeds–Azure marketplace

Fiddler shows that excel presents basic auth credentials to enumerate datasets at the Azure marketplace “area” associated with the identity. When we look at the management page for those credentials, they are a page – that first requires one logon … Continue reading

Posted in odata

getting a RESO style atom service document from SharePoint Online

In a office 365-hosted sharepoint subsite, called bi, we store an excel file in the documents folder.   The pwdoc resource is simply an excel file, uploaded. The sharepoint infrastructure has a nice feature – that any “table” within an … Continue reading

Posted in odata

steps to have excel talk to Graph API

Here are the steps to talk to the AAD graph API using excel 2013 and power query. The steps are similar to those used when talking to the supported odata feed of the CRM Online service. A workaround is given … Continue reading

Posted in odata

using excel powerquery to talk to CRM odata service (with sso/oauth, etc)

    one sees a sensible Fiddler trace.   one sees the final phases of the oauth2 handshake with an AS augmented with the ability to do websso with an IDP. One sees several calls to the services of the … Continue reading

Posted in odata

accessing CRM online, using AAD tenant discovery

Let’s build the modern/mobile odata application that talks to the CRM online service that we provisioned in the Microsoft Azure cloud, for some Rapattoni netmagic users. Lets see how it works when the client cooperates with the oauth2 endpoints of … Continue reading

Posted in odata

excel consuming Microsoft Graph API, with JWT

We were able to use the power query add in to Excel 2013 to interact with the graph API of AAD:   http://msdn.microsoft.com/en-us/library/azure/jj126255.aspx   https://graph.windows.net/netmagic.onmicrosoft.com/Users?api-version=2013-04-05 We had several issues, however, with the organizational id flow. I’m not quite sure how … Continue reading

Posted in odata

excel visualization of odata source, supported by AAD websso

Using our sharepoint license associated with an office 365 plan, we created a site (bi, for business intelligence) and on that site a list (a business intelligence list of 3 text records):   https://netmagic.sharepoint.com/bi/_layouts/15/start.aspx#/Lists/bilist/AllItems.aspx https://netmagic.sharepoint.com/bi/ https://netmagic.sharepoint.com/bi/_vti_bin/ListData.svc we want to now … Continue reading

Posted in odata

Italian knowhow on wab on a windows phone; using the exchange API. Or nearly, anyways.

This is excellent (and our code is at https://onedrive.live.com/redir?resid=5061D4609325B60!7427&authkey=!AJRzEViikCFZG5c&ithint=file%2c.zip) http://www.cloudidentity.com/blog/2014/04/16/calling-office365-api-from-a-windows-phone-8-1-app/ Now for a few notes follow of how we necessarily deviated from the suggestions: We used the empty project, as shown above, to get started Then we added bits of … Continue reading

Posted in oauth, odata

code for RESO-style odata protected by oauth (using proprietary token for client-credentials and JWT, otherwise).

Our code developed while at the NAR RESO conference, given the discussion, demos of and specs about odata v3 for realty are at https://onedrive.live.com/redir?resid=5061D4609325B60!7154&authkey=!AB89Ln6T5oX7_TE&ithint=file%2c.zip rather than doing the obvious and trivially easy work (just an odata controller to the mobile … Continue reading

Posted in odata

Understanding the client-credentials test project for OAUTH2 in Visual Studio

First off, we see the nature of the command-line clientcredentials grant seeking client – whose sample code we found at Download the sample code — this is a server-loaded app. It is intended to have its own vendorid and password … Continue reading

Posted in odata

Using owin’s interceptor for tokens presented to an odata webapi

The resource server is that which hosts the odata endpoints – nominally containing entity records that are “owned by” the resource owner. For example, if the resource is the users profile, then the user is the resource owner of the … Continue reading

Posted in odata

RESO/NAR conference on odata, odata security

The 1.5 day event was well attended, though a little stage managed. A lot of folk seemed to have nothing to say while old timers performed for the camera. Now under “professional management” this seemed – at least for THIS … Continue reading

Posted in odata

build on working resource/client grant and test http client talking to an odata server–to buildout an odata proxy client

Now  that we have two clients working in command line windows (i.e. CGIs) able to talk to the authorization server to swap their vedor’s UA-usernametoken or the record owner’s User-usernametoken for an Access token, we have to focus next on … Continue reading

Posted in oauth, odata

WebApplication7.zip is the project, ready to compile etc. https://onedrive.live.com/redir?resid=5061D4609325B60!6977&authkey=!AG5Up32lehBgsNI&ithint=file%2c.zip   http://blogs.msdn.com/b/webdev/archive/2014/03/13/getting-started-with-asp-net-web-api-2-2-for-odata-v4-0.aspx now to add the oauth authentication element, based on understanding how the single-page application does it. Once we have the webAPI/odata using an oauth endpoint provided by the very … Continue reading

Link | Posted on by

odata over sb, with ACS tokens

https://onedrive.live.com/redir?resid=5061D4609325B60!5842&authkey=!AJnQpHRxpx-2KN8&ithint=file%2c.zip

Posted in odata

an odata webapi, no security

followed the instructions at http://blogs.msdn.com/b/webdev/archive/2014/03/13/getting-started-with-asp-net-web-api-2-2-for-odata-v4-0.aspx

Posted in odata