Pulling in oData using a Download Tool

[dbarwic]

I am trying to pull oData into Alteryx so that I can then push it into SQL. I'm trying to do so with a Text Input tool and a Download tool.

I've tried entering the full URL in the Text Input tool and just using the Download tool for my credentials. I've also tried just entering the ending of the URL in the Text Input tool and setting up a connection to the base URL in the Download tool. Both methods are returning errors.

Has anyone ever done this before? Or perhaps know a better way to pull oData into Alteryx?

For more context, this data is coming from the E01 SAP environment. Here is the URL:

http://sapapp92.ipaper.com:8002/sap/opu/odata/sap/ZCO_I10646_LIFO_REPORT_SRV/MaterialSet?$filter=Wer...

I've attached my crude attempts below (without my credentials).

[pgrooten]

Dear @dbarwic,

Please find attached a sample workflow for reading a ODATA  source (in this case reading from Statistics Netherlands (aka CBS) open data source). I hope this is also helpful for you for reading data from SAP.

Hope this helps. 

Kind regards,

Paul