How do you get access to the full Elasticsearch response?

Hello!

I've successfully connected our Elasticsearch instance to Retool, however it seems like the only data that is available via the Resource's data property is the the value of the _source property from the hits.hits array in the response. I can't seem to get access to any other the other data returned. Can anyone direct me to how to get the full response?

This is super frustrating since things like the _id of the document and the results of aggregations are seemingly not accessible in a Retool Elasticsearch Resource.

Hey @Chris_Navta!

If you're looking for a more robust response you might want to try setting up a REST resource to hit your Elasticsearch endpoint:

Could that work?