Get MDO Table list in Catalog service

[senthil_kumar44]

Hi,

We have one issue on catalog service in MII 15.0. By using catalog service, we can get the folder and file list. I have two questions.

1. How to get entire files and folders of all projects? for example, in below URL, we need to give folder name as input. But it will give folders only, then we need to iterate again to get the files by using filesysystembrowser service.

http://<server:port>/XMII/Catalog?mode=ListFolders&Folder=<folder name>&Type=All

how to get all files and folders of entire server?

2. How to get the MDO tables in the folder - MIIOBJ of project. Do we have any separate service for that? in above example, it is giving one row as <project folder>/MIIOBJ and showing chilfilecount values like 5. But if i pass this folder name as input, it is showing error as invalid folder name. And also it is showing childfilecount value as including of KPIs in MIIOBJ. How to get MDO files names alone? What service we need to use?

Thanks,

Senthil

[Private_Member_14935 · Accepted solution]

Hi Senthil,

To get the files and folders you could try this:

http://host:port/XMII/Catalog?Mode=LoadFilesInsideFolderAndSubfolders&Class=Query&Folder=<project_fo...

This will return all the Query template files, if you remove Class from the URL it would return files irrespective of the type.

To get MDO files you could try the below combination of URLs:

http://host:port/XMII/Catalog?Mode=ListFolders&Folder=<project_folder_name>&Type=MDO

This would return the folder path which contains MDO objects, for example : MDO/MIIOBJ. This folder path could be passed to the below URL to get the persistent MDO objects:

http://host:port/XMII/Catalog?Mode=List&Folder=MDO/MIIOBJ&Mask=mdop

Hope this helps!

Thanks and Best Regards,

Ria