How to insert metadata into a "dctm related-table" via REST-API

Carlo Di Loreto · 2023-04-14T13:09:08+00:00

There was an error rendering this rich post.

I have to create records in a dm_registered table using dctm-rest-api.
Using a POST method to create new resources, the request is rejected.

Is there a rest method for creating a record in a registered table?

REQUEST:

curl --location 'https://myRepo.corproot.net:9443/dctm-rest/repositories/eCustomer/folders/0b10c8e0813b8486/documents' \--header 'Accept: application/vnd.emc.documentum+json' \--header 'Content-Type: application/vnd.emc.documentum+json;charset=UTF-8' \--header 'Authorization: Basic c2NfZW1haWxfc21hcnRib3VuY2VfbG9hZGVyOnB5T05zQzVyM1MwbFk2bkVYbVRD' \--data '{"properties": { "r_object_type":"dm_dbo.sc_emailbody", "sc_body_text0":"0123456789", "sc_body_text1":"some information" }}'

EXCEPTION:
  "status": 400,
"code": "E_CREATE_OBJECT_WITH_WRONG_TYPE",
"message": "Only dm_document is allowed to be created in this collection.",
"id": "b0be917c-388b-45f9-ab8e-cb3fa6c7f2ba"

Thank you in advance.
Carlo

Find more posts tagged with

Comments

Hicham Bahi

No there is not as far as I know. Usually you would insert records in a registered table via DQL but the dql resource only allows select queries. I'm afraid you will need to extend Documentum REST with your own custom resource to do that.

Carlo Di Loreto

hi Bahi

Yes, via iDQL I can create new records in the registred table. With the GET methods of REST I can only send SELECTs on the tables. With this REST method, you cannot do INSERTs either.

INSERT INTO dm_dbo.sc_emailbody ("sc_object_id","sc_body_text0") VALUES ('090f4a11800e2ff2','+123456789','äöüàéèÄÖÜÀÉÈ$£')

I do not understand the strategy of the chief developers of Documentum, who should at least be able to offer a GET-Method to make INSERTs even in tables that are sub-tables of the dm_document or dm_sysobject.

All that remains is to implement hybrid solutions using DFC classes and REST methods.

Thank you for your contribution.
Carlo

Hicham Bahi

Not sure I understand what you mean when you write that you cannot make insert in subtables of dm_document or dm_sysobject. If you mean create/update objects which are subtypes of above mentioned types, then of course you can do it with Documentum REST. If you talk about registered tables, I guess not many customers had this requirement so far (typically, registered tables are used to populates lists and do not get updated frequently), but I agree that it would be useful. Like I wrote, you can extend Documentum REST with a custom resource that would allow you to update registered tables. This is documented in the Documentum REST manuals.

Carlo Di Loreto

Hi Bahi

My comment above (INSERT INTO) was about the REST Services "DQL Query Resource" method, which offers the possibility of successfully executing DQLs (readOnly) even on dm_registered tables. Sorry if I caused any misunderstandings.

For the project we will see about developing um rest method as you recommended above.

Thank you for your advice.
Carlo

AlvaroDeAndresGomez

I'll just leave this here for future reference ;-)

https://blog.aldago.es/2021/11/22/registered-tables-custom-resource-extension-for-dctm-rest-services/

https://blog.aldago.es/2016/09/14/customizingextending-rest-services-ii/