Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

JSON SQL query | Download Tool

BobbyGomez
5 - Atom

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. 

4 REPLIES 4
jonnyrask
8 - Asteroid

@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
20 - Arcturus
20 - Arcturus

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Hamza_Abuali
7 - Meteor

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
20 - Arcturus

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

Labels
Top Solution Authors