Export straight table data with headers in Application Automation

[mayureshpalav1]

I am trying to retrieve data from my sheet using straight table block of application automation,i am using google sheets as my connector ,as i extract data in google sheets from straight table i do not get the table headers along with the rows! Is there any way to retrieve data along the column headers in application automation?

[MarkGeurtsen · Accepted solution]

Hi Mayuresh,

The block Get Straight Table Data provides the headers of the columns as keys for each object. It's possible to use the formula "Get Keys" on the first object of the result and use this as the headers value. See attached JSON.

Let me know if this helps!

Thanks,
Mark