CreateCatalogItem method

Question

CreateCatalogItem method

Paul 61

In ReportingService2010 web service, I created the C# Console App to upload files such as Excel, HTML, files to a folder in SSRS2019. Using the "CreateCatalogItem" method, I managed to upload the RDL files using "Report" in the "ItemType" with "null" on the "Property", however, when using the "Resource" in the "ItemType" for other types of files, it failed on the "Property". I am not sure on how to specify the "Property" such as "MimeType" for other type of files such as Excel and HTML files. Thanks.

FileStream stream = ReportFile.OpenRead();
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();
CreateCatalogitem("Resource", ReportFile.Name, @"/SSRS_Upload", true, definition, null, out Warnings) ;

0 comments

1 answer

Your answer

Answer 1

Anonymous

Hi @Paul
I think you can use the GetProperties method to return a list of properties. Here is the link I could find related to your question: https://social.msdn.microsoft.com/Forums/en-US/535a2bd7-bae9-485e-ae68-66f6775d3661/c-reportingservice2010createcatalogitem-properties?forum=sqlreportingservices.
This is also an example of uploading a data source: https://csharp.hotexamples.com/examples/SSRSMigrate.ReportServer2010/ReportingService2010/CreateDataSource/php-reportingservice2010-createdatasource-method-examples.html.
Regards,
Aniya

Paul 61 Reputation points

2022-08-09T14:12:18.173+00:00

Hi
Thank you for posting the suggested answer. I tried the new "Property" to the code just before calling the "CreateCatalogItem" and it failed with the error "The value for property 'MimeType' is not specified. The property is either missing or its value is null." What is the "value" for the property for the HTML and Excel file type? Thanks
Anonymous

2022-08-11T01:02:03.47+00:00

Hi @Paul
I am not very familiar with C# code, maybe you can ask here:https://learn.microsoft.com/en-us/answers/topics/164785/dotnet-csharp.html.
Regards,
Aniya
Paul 61 Reputation points

2022-08-11T02:28:38.557+00:00

Thank you for the reply. I did check out the mentioned links before. As for the HTML and Excel file types, I added the"Property" such as the "ItemType" to "Resource" and "Property.Name" = "MimeType" and the "Property.Value" = "application/html" or "application/xlsx" just before the "CreateCatalogItem" method. It worked. Thanks.
Richard Uchytil 16 Reputation points

2022-09-06T14:15:15.783+00:00

Hi @Paul !

I'm trying to upload Excel files to our server (this is our version: Microsoft SQL Server Reporting Services Version 15.0.1102.932) using Powershell. It works fine except Excel files get uploaded into the "RESOURCES" group instead of the "EXCEL WORKBOOKS" group. I can change the data in the Catalog table to fix this, but I'd like to fix it on the upload. For my MimeType I'm using application/vnd.openxmlformats-officedocument.spreadsheetml.sheet. I tried application/html & application/xlsx, both worked the same as what I'm currently doing. When you upload do your Excel documents go into the "EXCEL WORKBOOKS" group?

Curiously, I tried my same Powershell on an older server (Microsoft SQL Server Reporting Services Version 13.0.6404.1) and they DID get put into the "EXCEL WORKBOOKS" group. It appears Microsoft changed something with the newer version.

Thanks very much!

Share via

CreateCatalogItem method

1 answer

Your answer