OData Connector or Input Tool (RESTful API)

[ChaddB]

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 PowerBI, SSIS/SSRS, FME Safe, Tableau, 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 approved, OASIS 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

[SeanAdams]

@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.

[ChaddB]

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

[cam_w]

@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.

[PeterA]

One more Star for a ootb OData connector

[ShawnM]

One more Star for a ootb OData connector as well

[sean_bolte_dup_544]

Ding....another star

[marod1971]

I added another star

[pdoppalapudi]

Add another star to provide OData connector in Alteryx

[dustinswanson]

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

[KylieF]

Thank you for your post! This idea is being updated to the Revisit status as we like this idea and it's something we'd like to keep in mind for future updates, but cannot put on the roadmap at this time. We'll update the status however once we have a better idea on if and when it could be included in the roadmap.

[KylieF]

Thank you for your post! This idea is being updated to the Revisit status as we like this idea and it's something we'd like to keep in mind for future updates, but cannot put on the roadmap at this time. We'll update the status however once we have a better idea on if and when it could be included in the roadmap.