community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

OData Connector or Input Tool (RESTful API)

It would be wonderful for Alteryx to be able to connect to and query OData feeds natively, rather than using a 3rd-party driver or custom macro.   

 

OData querying is supported by quite a few familiar products, including Excel and PowerBISSIS/SSRS, FME SafeTableau, and many others. And the protocol is used to publish feeds from Microsoft Dynamics and Sharepoint, as well as many of the 10,000 publically available government datasets with API's (esp. those hosted by Socrata)   

 

I didn't see it as in the Idea section, but questions and workarounds have been discussed in the community a few times (11/15, 3/18, 4/18), and suggestions seem to be just to buy the $400-600 ODBC driver from CDATA (or ZappySys), or I could use a VBA script in Excel trigger a refresh, or create my own Alteryx connector macro (great series btw, though most was beyond my understanding!) 

   

While not opposed paying, kludging, or learning to program, they're just one more thing to build/buy, install, maintain, and break at the most inconvenient time 🙂

 

Thanks,
Chadd

 

OData Overview:

OData (Open Data Protocol) is an ISO/IEC approvedOASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.  OData RESTful APIs are easy to consume. The OData metadata, a machine-readable description of the data model of the APIs, enables the creation of powerful generic client proxies and tools.

More info at at http://odata.org

9 Comments
Nebula
Nebula

@TashaA and I were discussing the potential for splitting out RestAPI connector from the download tool.

This idea from you @ChaddB would fit in well with a refreshed RestAPI connector since this would be just another kind of RestAPI connection.

Atom

Thanks @SeanAdams (still looking for user ID tag or upvote on the WYSIWYG!) 

Comet

@SeanAdams and @TashaA It was nice to meet and talk briefly at Inspire 2018!

 

I have added my 'star' to this idea as well. It would be very helpful to have a separate RESTful API tool, as this class of connections seems to be growing.

Alteryx
Alteryx

One more Star for a ootb OData connector

Alteryx
Alteryx

One more Star for a ootb OData connector as well

Asteroid

Ding....another star

Meteoroid
I added another star

Add another star to provide OData connector in Alteryx

OData Feed is necessary to import data from MS Project Online. This would be very useful for every PMO using Project Online!

Labels