Has anyone downloaded data using a POST API with a SQL query within JSON?
I'm trying to download data from ElasticSearch but can't get the query to work. The query works fine in the ElasticSearch console, but I can't download anything within Alteryx. I'm hoping my formatting is off.
Solved! Go to Solution.
@BobbyGomez wrote:I'm hoping my formatting is off.
without sharing the query with us, how do you expect us to know if anything is wrong with it?
Thank you for your post. I for one have never downloaded data using a POST API with a SQL query within JSON. In fact, that combination of words was so new to me that just the act of typing them made my fingers tingle. I think that the question is valid (without an example.
When I googled this topic (without alteryx), I came up with: https://www.example-code.com/sql/httprequest_application_json.asp
Sometimes I google things that make the problem something that I can use to simplify my task at hand.
Cheers,
Mark
Hello There,
I know I am 2 years Lat , LOL.
But I am now trying to achieve this approach and download data from Elastic using the HTTP action of GET, through the REST API provided by Elasticsearch.
How is the doable ?
Thanks.
@Hamza_Abuali there is nothing special AFAIK with a json query payload vs a standard json payload. Get what you are trying to do working in Postman and then transition it to Alteryx.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |