Create Report Subscription script

Question

Hello, 
 I need to create the report subscriptions from script/process. 
 I have a number of reports that are bundled as a standard package. All of them should be assigned to users automatically. User can opt out from those subscriptions at any time. 
 Is there any way to do this from script/process? 
 I've tried inserting records using object browser manually, the insert action is prevented (permission missing). 
 If there is no out-of-the-box method, what records (in which tables) I should insert to create subscription manually? 
 
 Thanks, Piotr Markiewicz

Markus Weiss-Ehlers · Answer

Just as a clarification. 
 The table PersonHasRPSReport does not store the report subscription itself. It stores the access of a person to a subscribable report. So if a person has an entry for such a subscribable report here, the person is allowed to create a subscription to this report in the web portal. 
 So, if everybody should be able to create his own subscriptions you just have to assign the subscribable reports to either an application role or business role that everybody is a member of. 
 The subscriptions itself are stored in the tables RPSSubscription and RPSSubscriptionCC . But you have to keep in mind that a subscription consists of the subscribable report and of the defined, calculated or selected parameters for the report. These are stored in different tables as well. 
 If everybody should be able to get a report with the same parameter set, the best practice would be to create a subscribable report ( RPSReport ) that defines all parameters as desired and having the parameter type set to fix or calculated. 
 HtH

piotr.markiewicz · Answer

Hi Markus, 
 
thank you for your reply. The reports will have only fixed and calculated parameters. 
 
I've managed to create successful subscription, by: 
* Creating manually in SQL entry in RPSSubscription (bypassing Object Layer permission check) 
* Calling method "Create default parameter set" on newly created report subscription (in Object browser) 
 
This way I was able to receive the report and manage it in the UI (change parameters/unsubscribe) without any errors.

Thank you guys for all the help.