Skip to main content
R
RJ_96543591-Visitor
1-Visitor
June 15, 2021
Question

Converting json to excel

  • June 15, 2021
  • 2 replies
  • 1175 views

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.

2 replies

B
BABA-SHYAM15-Moonstone
15-Moonstone
June 16, 2021

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

    R
    RJ_96543591-VisitorAuthor
    1-Visitor
    June 16, 2021

    Hi Shyam,

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

     

     

    S
    slangleyCommunity Manager
    Support
    June 24, 2021

    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

    Terms & ConditionsAccessibility statement