3 Replies Latest reply on Aug 4, 2015 8:24 AM by prashanthi1

    how to make a update call to a view table by odata URL

    prashanthi1
    prashanthi1 Jul 27, 2015 4:11 AM

      Hello,

       

      I am trying to update one column of a view table.

      I have below queries in my Select and Update tabs of my transformer editor.

       

      Select Tab-

       

      SELECT

        column1, column2

        FROM

        OracleConn.TableName

       

      Update Tab-

       

        FOR EACH ROW

      BEGIN ATOMIC

        IF(CHANGING.column2)

        BEGIN

        UPDATE OracleConn.TableName SET column2 = "NEW".column2 WHERE column1 = "NEW".column1;

        END

      END

       

      I am trying to give json input to the odata URL - http://localhost:8080/odata/<vdbName>/<tableName>?$format=json

      Method - PUT

       

      Payload-

      {

          "column1 ":"15232",

          "column2 ":"3"

      }

       

      I am getting "NotFoundException".

      If the change the method to PATCH, I get "No resource method found for PATCH, return 405 with Allow header" error.

      How do I make a successful update call? Let me know if I am missing anything here.

       

      Thanks in advance,

      Prashanthi.