It's all about the answers!

Ask a question

XLSArtifactID attribute for RQMExcelWordImporter

Andrew Trobec (49712141139) | asked Jun 01 '10, 2:25 a.m.

I know that the attribute XLSArtifactID can be used to assign a sort of keyword to records so that the can be identified and updated with the RQMExcelWordImporter utility.

My question is:

How can I manually assign the XLSArtifactID attribute to existing records or new records that weren't created via the RQMExcelWordImporter utility so that they can be updated?

Thank you and best regards,


Christophe Lucas commented Jun 27 '17, 3:31 a.m.

Have you received an answer to this question ? 

I have the exact same question (CLM 604), i.e. how to find(/assign) the XLSArtifactID attribute of(/to) existing Test Cases that were created in RQM (i.e. NOT via the RQMExcelWordImporter utility)

2 answers

permanent link
Mehul Patel (9695) | answered Jun 28 '17, 1:00 a.m.

XLSArtifactID specifies the external ID of the artifact, If artifact with that external ID exist in the repository then it updates the artifact otherwise it creates the artifact with provided ID.

You can refer 'Scripts that create testcases' file from sample folder where they have used column B to specify artifact ID. If you need to update the existing artifact then you need to retrieve the artifact ID from RQM repository and specify in that particular column. I've found some article describing how to access RQM artifact using REST API, please refer it. Detailed RQM REST API is documented at RQM API Wiki.

To retrieve testcases from repository you can refer below format to build your URL

https://<jazz server>:<port>/<application context i.e. qm>/service/<project>/testcase

It will list available testcase URLs and you can extract testcase ID from those URLs.


Christophe Lucas commented Jun 28 '17, 1:05 a.m.

Thanks Mehul !

permanent link
Paul Slauenwhite (8.4k12) | answered May 27 '15, 7:28 a.m.
Note: This post is 4+ years old.

Please upgrade to the latest version of RQM (see and review the product documentation (see and resources (see  If your issue persists, please ask a new question (, open a defect (see, or open a PMR (see

Your answer

Register or to post your answer.