XSOdata - POST on table with no key column

I have a table that does not require a key column to be specified. When defining an odata service, I used the 'Keys generate as local("ID")' to specify a key.

Problem is when I use a POST method to create records, I get 'Status - 501 not implemented', both when I use an ID column or if I drop it. Is there a way around this or should I define a dummy key column in my table?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 23, 2017 at 05:56 PM

    This should work benedict. Can you share your code which you are trying to use.
    I didn't double check in my system but as per this post this should work


    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

    • I use a simple definition,


      table.schemaName = "<schema>"; table.tableType = COLUMNSTORE; // ROWSTORE is an alternative value table.columns = [ {name = "MY_COL1"; sqlType = VARCHAR; length = 200; }, {name = "MY_COL2"; sqlType = INTEGER; defaultValue = "1";}, {name = "MY_COL3"; sqlType = NVARCHAR; length = 200; } ]; //table.primaryKey.pkcolumns = ["MY_COL1", "MY_COL2"];


      service { "VENMANBV"."sce_tdm.test.venmanbv_D75.catalogObjects::ODATA_SAMPLE" as "MyView"

      keys generate local "ID";


Skip to Content