JSON SQL query | Download Tool

[BobbyGomez]

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. 

[jonnyrask · Accepted 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?

[MarqueeCrew]

@BobbyGomez ,

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

[Hamza_Abuali]

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.

[apathetichell]

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