SQL Table parameters error

[Anonymous]

Hi,

I have a problem with this parameters:

Original:

{

          "field":"LOW",

          "length":2,

          "type":"CHAR",

          "values":

           ["04"]

Actual (not working):

{

          "field":"LOW",

          "length":2,

          "type":"CHAR",

          "values":

          ["04","09","11"]

What's wrong with this?

[Anil_Babu_Samineni]

With in the JSON it is very touch to split the values from Parameters while we connect to REST connector.

RC:

SQL SELECT

    A, B, C, D

FROM JSON (wrap on) "root"

WITH CONNECTION (

QUERY "ProductId" "$(vProductId)");

Load A, B, C, D, SubField("root", '@') as "root" Resident RC;

Here "root" is my Query parameters which constantly stored in REST connector section.