SQL to get Subscription Rule. Mapping of Subscription Profile with BU

Summary:

Hi team,

We have a requirement to create the Subscription based on API.

Please let us know how can we get the subscription profile name. Is this stored in database?

Of if we put BU in API it will directly map it to correct profile without the need to putting profile value in API.

Content (required):

As above

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):