1. When a New Order (For Subscription) is placed, I am redirecting User to Thank You Page URL. In this process i get OrderID ,Contact Id (ex. orderId=135715, ContactId=1370925). I store this info on my local database.
2. I have setup RestHook Event to Subscription.edit Event. So whenever a Subscription( started by Step 1) is edited, I receive subscrption Id ,which is actually RecurringOrdersTable Id.
From this Subscription ID , how can I identify the original OrderID (135715)? Which table contains the linkage between OrderID (At Step1.) and SubscriptionID (Received at Step2).
I cant seem to find the table that will help in corelating these two IDs