Is there a way in Thingworx to convert the json output to excel format or a flat structure with line numbers?
Any ideas or inputs are appreciated.
First you need to covert json to infotable using fixed datashape. Once done, use this infotable and pass it to csv parser function to generate a csv file. You can download csv parser extension from market place.
If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.