How to Configure the Return Format for Data Sources

The return of a query must be in JSON format and deserializable for the List<Dictionary<string, string>> (in .NET). In other words, the return of each query must be in a tabular JSON string, not a complex one, as in the following example:

{

      "Name": "John",

      "Age": "32",

      "City": "Boston"

},

{

      "Name": "Paul",

      "Age": "12",

      "City": "New York City"

}

]

 

Below is an example of an invalid return string (although it is a valid JSON):

{

      "People":[

{

      "Name": "John",

      "Age": 32,

      "Address":{

      "City": "Boston"

                }

}

                ]

}