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_parasoftbenken_parasoft Posts: 649 ✭✭✭
    edited February 28

    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.

  • praharshithsoapraharshithsoa Posts: 2

    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.

Sign In or Register to comment.