FDM cannot process json file

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When trying to open JSON file, FDM is getting stuck

Cause

Check the json file, the format is not valid, as below,

[

  {

    "a": "value a",

    "b": "value b",

    ...

  }

  ...

]

Resolution

The [ ] is for array, it should be a value of a json node, change the json file to following format fixes the issue,

{
"data": 
  [

    {

      "a": "value a",

      "b": "value b",

      ...

    }

    ...

  ]
}