# Excel to ElasticSearch and writing a get request against ES cluster

**URL:** <https://discuss.elastic.co/t/excel-to-elasticsearch-and-writing-a-get-request-against-es-cluster/76352>\
**Category:** Elasticsearch\
**Created:** [February 24, 2017, 5:58am UTC](https://discuss.elastic.co/t/excel-to-elasticsearch-and-writing-a-get-request-against-es-cluster/76352 "2017-02-24T05:58:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sam99](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@sam99](https://discuss.elastic.co/u/sam99)\
**Post date:** [February 24, 2017, 5:58am UTC](https://discuss.elastic.co/t/excel-to-elasticsearch-and-writing-a-get-request-against-es-cluster/76352/1 "2017-02-24T05:58:25Z")

</div>

Also posted to stackoverflow but posting here as there may be experts here.

I searched the internet and could not find good examples. I am new to ES and programming as well.

I am trying to connect from Excel to ElasticSearch cluster.. I am trying to write the API request in its entirety. I have tried a few things.. need some more help here. Here is what, I was able to do.

Sub MyFirstRESTAPICALL()  
Dim oRequest As Object  
Set oRequest = CreateObject("WinHttp.WinHttpRequest.5.1")  
oRequest.Open "GET", "[http://my-es-node1:9200](http://my-es-node1:9200)"  
MsgBox oRequest.ResponseText  
End Sub  
I get a simple response in my excel.. but I need to do more

How do I construct GET request that can be used from Excel to ElasticSearch? The query I am using in kibana is below. I need to translate it and update the GET request above in excel.

GET DJ\_cust\_latest/cust/\_search?size=100 { "\_source": ["cust-\_info-\_version", "cust-config-num", "num\_tables"], "query": { "bool": { "must": [ { "terms": { "cust\_uuid": [ "00845916-3245-dcbf-0000-87650000d98c","00634297-1718-f280-0000-  
00000897e522"] } }  
] } } }

Thanks, Sam.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 24, 2017, 5:58am UTC](https://discuss.elastic.co/t/excel-to-elasticsearch-and-writing-a-get-request-against-es-cluster/76352/2 "2017-03-24T05:58:39Z")

</div>

Closed on March 24, 2017, 5:58am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.