Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Writing json response to an excel

I have a json response which i am storing in json databank. I want the same to be updated in an excel . I had gone through the following link https://forums.parasoft.com/discussion/2698/how-to-create-csv-files-editable-in-microsoft-excel-from-data-extracted-from-tests
But my case is for an json response, not an xml

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,228 ✭✭✭
    edited February 2019

    The principal is the same except you use JSON data bank instead of XML data bank. In both cases, you need to decide how you want to map your hierarchical message into a flat CSV format. The XPaths used in extractions you setup are always going to vary.

  • praharshithsoa
    praharshithsoa Posts: 8

    I can get the full response to be captured in an text file . But i am unable to capture only the required fields which i am storing in databank into an file.