SSRS Rest api Data Driven Subscription

robert gama 1 Reputation point
2021-01-22T22:24:37.547+00:00

I can create non data driven subscriptions via api. I have looked at the documentation as well as looked for examples online but have not had any luck creating a new data driven subscription. My main issues is figuring out how to give the subscription a data source when creating via api. I am testing through Postman right now and have a json body that looks similar to the one in the documentation.

Any help is appreciated.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-01-25T06:39:11.68+00:00

    Hi @robert gama ,
    How do you configure the data source? You can refer to the following link: How to import REST API in SQL Server (call JSON/XML SOAP service)

    What is your data source type? Is it included in the following data types.
    Examples of supported data source types include SQL Server relational data, Oracle, Analysis Services databases, SQL Server Integration Services package data, ODBC data sources, and OLE DB data sources. For more information, please refer to: Data Sources Supported by Reporting Services (SSRS).

    There are many reasons for the failure to create a data subscription, such as not using the SQL server Agent , and data source permission issues. Could you browse the reports for creating subscriptions normally? And does the data source have sufficient permissions? Could you share how you provided the data source when you created the subscription? After the subscription fails to be created, you could view the error message in the error log folder, which will be of reference value for solving the subscription failure. So please provide the error log. The path is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.