cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Converting json to excel

RJ_9654359
5-Regular Member

Converting json to excel

Hi,

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.

 

Thanks.

3 REPLIES 3
BABA-SHYAM
14-Alexandrite
(To:RJ_9654359)

Hi,

 

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.

 

Regards

Shyam

RJ_9654359
5-Regular Member
(To:BABA-SHYAM)

Hi Shyam,

Thanks for your inputs, I will give it a try.

 

 

slangley
23-Emerald II
(To:RJ_9654359)

Hi @RJ_9654359.

 

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.

 

Regards.

 

--Sharon

Top Tags