topic Content URL of Document in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292639#M245769 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I work with SELECT statements to query document informations like: </SPAN><BR /><BR /><SPAN>SELECT * FROM cmis:document c where c.cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId = '372f68cb-d72d-4694-bb4f-abcdefef09a5'</SPAN><BR /><BR /><SPAN>and it works fine.</SPAN><BR /><BR /><SPAN>Now I also need the property "content URL" of the document (like </SPAN><A href="https://Host_Port/alfresco/api/-default-/public/cmis/versions/1.1/atom/content/file.xml?id=3abcdefb-d72d-4694-bb4f-0f722011aaa5%3B1.0" rel="nofollow noopener noreferrer">https://Host_Port/alfresco/api/-default-/public/cmis/versions/1.1/atom/content/file.xml?id=3abcdefb-d72d-4694-bb4f-0f722011aaa5%3B1.0</A><SPAN>)</SPAN><BR /><BR /><SPAN>My question now would be which tables to join in order to get the content URL of the document.</SPAN><BR /><SPAN>Thanks a lot!</SPAN><BR /><SPAN>Generic1</SPAN></BODY></HTML> Mon, 09 Feb 2015 15:19:19 GMT generic1 2015-02-09T15:19:19Z Content URL of Document https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292639#M245769 Hi,I work with SELECT statements to query document informations like: SELECT * FROM cmis:document c where c.cmis<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId = '372f68cb-d72d-4694-bb4f-abcdefef09a5'and it works fine.Now I also need the property "content URL" of the document (like https://Host_Port/alfresco/api/-default-/public/cmis/ve Mon, 09 Feb 2015 15:19:19 GMT https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292639#M245769 generic1 2015-02-09T15:19:19Z Re: Content URL of Document https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292640#M245770 <HTML><HEAD></HEAD><BODY><SPAN>What you do is construct the appropriate URL to call a webscript.&nbsp;&nbsp;&nbsp; No faffing with "tables" is allowed or required.</SPAN></BODY></HTML> Mon, 09 Feb 2015 15:52:10 GMT https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292640#M245770 mrogers 2015-02-09T15:52:10Z Re: Content URL of Document https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292641#M245771 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the response,</SPAN><BR /><SPAN>So as I understood I shoud not construct a SELECT statement in order to get the content url.</SPAN><BR /><SPAN>My problem is that I only should have one request because I make the request from an ESB.</SPAN><BR /><BR /><SPAN>If any suggestion is possible I would be thankeful for an advice. </SPAN><BR /><SPAN>Thanks a lot!</SPAN><BR /><SPAN>Generic1</SPAN></BODY></HTML> Mon, 09 Feb 2015 17:59:04 GMT https://connect.hyland.com/t5/alfresco-archive/content-url-of-document/m-p/292641#M245771 generic1 2015-02-09T17:59:04Z