XSOdata - POST on table with no key column

May 19, 2017 at 06:50 PM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Krishna Tangudu 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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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