Elasticsearch data

hello?
I brought data using Elasticsearch, but I want to make the columns in _source appear in the table. What should I do?

Hi @junsu! Since tables accept arrays of objects or objects of arrays and it looks like you're passing in data nested further than that.

To confirm, you only want the source data in a table?

I can definitely help get you the right syntax to grab specific data! Could you share a screenshot of your left panel's State tab expanded out to show the query.data as much as possible?

Thank you @victoria
I will attach a captured photo.

Thank you so much, @jungsu!

In that case, your table component can use this data:

{{ formatDataAsObject(tlog_all.data.hits.hits)._source }}

Let me know how this works for you :crossed_fingers:

https://docs.retool.com/reference/javascript-api-methods-array-object#formatdataasobject