Delete Stripe Subscription Details from MySQL on Subscription Cancellation Using Pabbly Connect

Learn how to delete Stripe subscription details from MySQL on cancellation using Pabbly Connect. Follow this detailed tutorial for step-by-step guidance. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Stripe and MySQL Integration

To delete Stripe subscription details from MySQL upon subscription cancellation, first, you need to set up Pabbly Connect. This platform allows seamless integration between Stripe and MySQL, automating the deletion process. Start by signing up for a free account on Pabbly Connect, which takes just a couple of minutes.

Once you are logged into your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. Name your workflow, for example, ‘Stripe to MySQL’, and select the appropriate folder for your workflow. After creating the workflow, you will see two main sections: the trigger window and the action window.

2. Configuring the Stripe Trigger in Pabbly Connect

In this step, we will configure the trigger for Stripe in Pabbly Connect. Begin by selecting Stripe as your app in the trigger window. From the dropdown, choose the trigger event as ‘Cancelled Subscription’. This setup allows Pabbly Connect to listen for subscription cancellations in your Stripe account.

• Select the ‘Add Webhook URL’ option in Stripe.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your Stripe account and navigate to the ‘Developer’ section.
• Under ‘Webhooks’, click on ‘Add Endpoint’ and paste the copied URL.

After pasting the webhook URL, select the event named ‘customer.subscription.deleted’. Click on the ‘Add Event’ button and then on ‘Add Endpoint’. This integration ensures that whenever a subscription is canceled, the information will be sent to Pabbly Connect for further processing.

3. Testing the Stripe Trigger in Pabbly Connect

After setting up the webhook, it’s time to test the trigger in Pabbly Connect. Go back to your Stripe account and cancel a subscription. As soon as you cancel the subscription, Pabbly Connect will receive a webhook response containing the details of the canceled subscription.

In Pabbly Connect, you will see a notification indicating that it is waiting for a webhook response. Once you cancel a subscription, check the Pabbly Connect dashboard to confirm that the details of the canceled subscription have been captured successfully.

This step verifies that the trigger is functioning correctly. The response will include various details such as subscription ID, status, and timestamps, confirming that Pabbly Connect is now receiving the necessary data from Stripe.

4. Configuring the MySQL Action in Pabbly Connect

Next, we will set up the action in Pabbly Connect to delete the subscription details from MySQL. In the action window, search for MySQL and select it. Choose the action event as ‘Delete Row’. This action will allow Pabbly Connect to remove the canceled subscription details from your MySQL database.

To establish a connection, enter your MySQL database credentials, including username, password, host, database name, and port. Once connected, select the table that contains your subscription data, typically named ‘subscriptions’. Next, specify the column that holds the subscription ID to identify which record to delete.

• Map the subscription ID received from Stripe to the corresponding column in MySQL.
• Set the limit for deletion, usually to 1, since each subscription ID is unique.

After mapping the necessary fields, click on ‘Save and Send Test Request’. Pabbly Connect will attempt to delete the specified row, and you will receive a confirmation response indicating success.

5. Verifying Subscription Deletion in MySQL

Finally, to ensure that the integration is working correctly, verify the deletion of the subscription details in your MySQL database. Refresh your database to check if the record corresponding to the canceled subscription has been removed. This step confirms that the automation set up in Pabbly Connect is functioning as intended.

To test this, cancel another subscription in your Stripe account and repeat the verification process. After canceling, check your MySQL database again. You should see that the subscription details have been successfully deleted, confirming the effectiveness of the workflow.

This streamlined process, facilitated by Pabbly Connect, ensures that your subscription data is always up to date, automatically removing any canceled subscriptions from your MySQL database.

Conclusion

In this tutorial, we learned how to use Pabbly Connect to automate the deletion of Stripe subscription details from MySQL upon cancellation. This integration simplifies subscription management and ensures your database is always current.