• Replies 7 replies
  • Subscribers 0 subscribers
  • Views 23 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

Add IDs for Files and Folders in iSheet XML

Mark Salamon
27301

In file and folder link columns, and in file and folder metadata iSheets, in the XML feed, can the IDs of the files and folders be included?  Without the IDs it's very difficult to make any use of those columns (and corresponding iSheets).  It should be relatively simple to get that information and the XML is extensible and should support additional xml nodes or attributes with that information.  For example:  a column with a document currently looks like:

<column position="1" columnid="123"><rawData><document><docName><![CDATA[Agreement]]></docName><docExtension><![CDATA[pdf]]></docExtension><docIndex/></document></rawData><displayData><![CDATA[ Agreement

Just add <id>####</id> inside <rawData> or add an attribute <rawData id="###">

 

 

]]>

  • David Corrin  Interesting. A different view of an iSheet available from inside the browser that also includes the fileid information. Thanks!

  • David Corrin Btw, the technique I discovered works with that URL format too. Just add &metaData.itemId={ITEMID} to the end and it will limit the results to a single record. Conceivably, at the time the user clicks on a file or folder to access it, you could make the single record call out and retrieve the fileid or folderid and then take the user there. It's unlikely that the user will click on any of the files, so this should save some processing.

  • Andy Neill Has the "itemRenderGridXML" been removed in 5.7.x? I'm now getting an unhandled exception when trying to access it?

  • Dan Pryor, looks to have been replaced by the /isheetGrid.action?... call. Looks to have the same query string parameters, and XML response. FYI for others, this is different to the /sheetViewExportXML.action?... which is the official endpoint Collaborate provides - itemRenderGridXML was the internal called used by the iSheet module home page, to render the grid view.

  • We've moved entirely over to API calls now for this reason, good to see it's still an option to do in XML.

  • Thanks Andrew Quinn! It also appears to now require the: injectSheetView parameter