This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
Hi there,
I'd like to query and write to an OData source directly, rather than either dump to file / import etc or use an ODBC driver as a front end. Has anyone attempted this? Anyone have suggestions on how that might be done? I'm not asking how to use OData, I'm asking about the Alteryx specific bits for where to start with that integration.
Thanks,
Christian
Hi,
I think you should look into the download tool. I have build quite a few API integrations also to REST API's. Please let me know, if I can do more to help out.
Have a nice weekend,
Daniel
Thanks Daniel, will give that a try and report back.
Perfect.
Looking forward to hear about the outcome.
All the best,
Daniel
Just now getting back to this. Can you point me to an example of a RESTful query implemented with the Download tool?
So, a little more explanation on the way you interact with Azure Table Storage is that you submit a GET request to retrieve Entities from this NoSQL storage.
https://msdn.microsoft.com/en-us/library/azure/dd179421.aspx
When you Query Entities with this API, you receive 1000 entities in the response. And you receive a continuation token. You then use this continuation token to retrieve the next 1000 entities. Here's an example of what that looks like.
https://msdn.microsoft.com/en-us/library/azure/dd135718.aspx
How would you do this with the download tool which seems to be a simple query and done engine but not a "query, read, take something from the data you got and evaluate whether to use it to ask for more data, repeat until done".
When you have a million rows in the table, you literally have to do send a query in a 1000 times (each with the continuation token of the prior query) until you're done.
I'm stuck at the moment. :(
@jdunkerley79 did you have any success with this?
Here's the solution https://www.cdata.com/kb/tech/odata-odbc-alteryx.rst