Construction of JSON string from excel data

Learning Hub Academy Feedback
1

Hi. Is there any easy way to construct a json with an excel sheet column name as key and corresponding rows as their values. I have done it using excel scope activity and extracted column name and data separately and now using loop to construct string. Is there any activity or function to simplify this process.

Thanks.

2

As far as I’m aware, the way you’re doing it is the most efficient. I’m assuming you’re using a string variable and concatenating the array pieces with the values as you’re looping through?

3

Yup. Same.