Import Subscription Plans from Stripe to Oracle NetSuite

Use this recipe to import subscription plans of products from Stripe to Oracle NetSuite.

Note:

Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe fetches subscription-plan records of products from Stripe and creates corresponding service items in Oracle NetSuite as per a schedule specified in Oracle Integration. It uses the standard REST Adapter and the Oracle NetSuite Adapter.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. Subsequently, you can activate and run the integration flow of the package manually or specify an execution schedule for it. When triggered, the integration flow reads the subscription-plan records of products from the Stripe instance and, in turn, creates the corresponding service items in your Oracle NetSuite instance. All Stripe subscription-plan records sorted by their creation date (along with their associated data, such as names, prices, currencies, and pricing intervals) are imported to Oracle NetSuite as service items.

System and Access Requirements

  • Oracle Integration, Version 21.2.1.0.0 or higher.
  • Oracle NetSuite, Version 2019.1.0 or higher.
  • Stripe.
  • An account on Oracle NetSuite with the Administrator role.
  • An account on Stripe with the Administrator role.

Recipe Schema

This section provides an architectural overview of the recipe.

The integration flow of the recipe, when triggered by an execution schedule or a manual submission, queries the Stripe instance for a list of subscription-plan records associated with a product. After successfully retrieving the records, it processes these records individually and creates the corresponding service items in Oracle NetSuite. When it completes processing subscription plans of a product, the integration flow queries for plans associated with another product. It continues this process until all subscription plans in Stripe are imported.

Description of stripe-ns-plan-record.png follows
Description of the illustration stripe-ns-plan-record.png