Discussions

Hi Support Team,

We are trying to retrieve a list of all email templates stored in iMIS under the following folder and its subfolders:

PATH : $/Common/Communications/Queries/CICC

Our goal is to extract the following information for each template:

1. Template name
2. Date it was last modified
3. user who last modified it
4. actual HTML content of the email template

We explored multiple approaches to automate this process using the iMIS REST API and IQA, but encountered several challenges.

What we tried :-

1. Tried using the REST API to list IQAs
   We attempted the following endpoint:

GET /api/IQA/Queries?$filter=startswith(Path,'Common/Communications/Queries/CICC')

But this returned a 501 Not Implemented error with authorization denied. This prevented us from retrieving the list of templates dynamically via API.

2. Created a meta-IQA using the Document business object
   As a workaround, we created a query named:

CICC/Staff/IT/List_CICC_IQAs

This IQA used the Document source with a filter on DocumentTypeCode = IQD to list all saved queries (IQAs) in the folder. The intent was to use these query names to call the API:

/api/IQA?queryName=Common/Communications/Queries/CICC/{Document Name}

We attempted to extract metadata such as TemplateName, ModifiedDate, ModifiedBy, and HtmlContent or Body.

3. Discovered limitations with Communication document types
   While processing the results, we found that many of the entries in this folder are stored with DocumentTypeCode = Communication, not IQD. These appear to be actual email templates and not queries.

When we attempted to export these items manually through the RiSE Document System, we encountered the following messages:

Could not export: Documents of type Communication cannot be exported

Error while exporting: Root element is missing

This blocked both manual export and automated API-based extraction.

We would like to know :-

1. Is there a supported way to extract a list of all email templates under the specified folder, including the HTML content and last modified metadata?
2. Is it possible to access Communication-type documents and their content via REST API or Business Objects?
3. Can these templates be exported or accessed in bulk through any other supported feature in RiSE?
4. Is there an alternative data source or reporting method we can use to extract this information?

We are looking for a reliable way to access this content for auditing and reporting. Let us know if this is achievable through API, through any export method, or with a different approach.