Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
kushimamau
Not applicable

SQL Table parameters error

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?

Tags (1)
1 Reply
loveisfail
Not applicable

Re: SQL Table parameters error

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.

Life is so rich, and we need to respect to the life !!!