We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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