1 Reply Latest reply: Oct 17, 2017 8:49 PM by Anil Babu RSS

    SQL Table parameters error

    Mauricio Kushima

      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?

        • Re: SQL Table parameters error
          Anil Babu

          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.