is their any way to subscribe a table and get information via webhook

[arnav21]

is their any way to subscribe a table and get information via webhook like when recipient open the mail or message get delivered

[Craig_Thonis]

Hi Arnav, can you elaborate on your use case? There really isn't any concept of subscribing a table in Campaign.

[arnav21]

does adobe has a push based mechanism so that whenever recipient open or click on mail i got it's notification via webhook instead of i have to pull everytime from delivery logs

[Ganesh5067 · Accepted solution]

It is not possible to subscribe to a table in Adobe Campaign and receive notifications when a recipient opens an email or a message is delivered. These types of events are specific to email and messaging interactions and are not directly related to changes in a database table.

However, Adobe Campaign does provide a mechanism for tracking email and message interactions using tracking logs. The tracking logs capture data about each email or message that is sent from Adobe Campaign, including information about opens, clicks, and deliveries.

To use this feature, you can enable tracking for the delivery activity that sends the email or message, and then use a query to retrieve data from the tracking logs. The query can be scheduled to run at regular intervals and send the results to an external system using a webhook.

Here are the basic steps to set up tracking and retrieve data using a webhook:

1. In Adobe Campaign, create a delivery activity and enable tracking for the activity.
2. Create a query to retrieve data from the tracking logs, filtering on the events you are interested in (e.g. opens, clicks, deliveries).
3. In the query configuration, select the "Export" option and specify the URL for your webhook endpoint.
4. Save the query configuration and make sure that it is enabled.

When the query runs, Adobe Campaign will send the results to your webhook endpoint, providing information about the email or message interactions. You can then process this information in your external system as needed.

Note that to use this feature, you need to have access to the Adobe Campaign Administration console and have the necessary permissions to create deliveries and queries. Additionally, you will need to have a system set up to receive and process the webhook notifications.

[arnav21]

Hi @Ganesh5067 i am able to create a query from  Tools > Generic query editor

but not able to see "Export" option can you please tell if i am doing anything wrong.

Thanks!

[akshaaga]

@arnav21 ,

In Adobe Campaign, you can export the query results from the Generic Query Editor by following the below steps:

1. After creating the query, click on the "Execute" button to run the query.
2. Once the query results are displayed, click on the "Export" button, which is usually located on the top right or bottom right of the results table.
3. From the export options, select the format in which you want to export the query results.

If you do not see the "Export" option, it's possible that your user account does not have the necessary permissions to perform this action.

Alternatively, you can try using the Adobe Campaign API to export the query results programmatically. You can find more information about the Campaign API in the Adobe Campaign documentation.