Skip to content

gupy-io/tap-suiteql

Repository files navigation

tap-suiteql

tap-suiteql is a Singer tap for Netsuite SuiteQL API.

Built with the Meltano Tap SDK for Singer Taps.

Installation

  • Developer TODO: Update the below as needed to correctly describe the install procedure. For instance, if you do not have a PyPi repo, or if you want users to directly install from your git repo, you can modify this step as appropriate.
pipx install tap-suiteql

Configuration

Accepted Config Options

  • Developer TODO: Provide a list of config options accepted by the tap.

A full list of supported settings and capabilities for this tap is available by running:

tap-suiteql --about

Configure using environment variables

This Singer tap will automatically import any environment variables within the working directory's .env if the --config=ENV is provided, such that config values will be considered if a matching environment variable is set either in the terminal context or in the .env file.

Source Authentication and Authorization

  • Developer TODO: If your tap requires special access on the source system, or any special authentication requirements, provide those here.

Usage

You can easily run tap-suiteql by itself or in a pipeline using Meltano.

Executing the Tap Directly

tap-suiteql --version
tap-suiteql --help
tap-suiteql --config CONFIG --discover > ./catalog.json

Developer Resources

  • Developer TODO: As a first step, scan the entire project for the text "TODO:" and complete any recommended steps, deleting the "TODO" references once completed.

Initialize your Development Environment

pipx install poetry
poetry install

Create and Run Tests

Create tests within the tap_suiteql/tests subfolder and then run:

poetry run pytest

You can also test the tap-suiteql CLI interface directly using poetry run:

poetry run tap-suiteql --help

Testing with Meltano

Note: This tap will work in any Singer environment and does not require Meltano. Examples here are for convenience and to streamline end-to-end orchestration scenarios.

Your project comes with a custom meltano.yml project file already created. Open the meltano.yml and follow any "TODO" items listed in the file.

Next, install Meltano (if you haven't already) and any needed plugins:

# Install meltano
pipx install meltano
# Initialize meltano within this directory
cd tap-suiteql
meltano install

Now you can test and orchestrate using Meltano:

# Test invocation:
meltano invoke tap-suiteql --version
# OR run a test `elt` pipeline:
meltano elt tap-suiteql target-jsonl

Adding Streams

There are 2 ways in which we can map entities in this tap

the first is discovering there schema by using the meta-data suiteql endpoint (dinamically), and the second is by manually mapping the properties on the stream (static). We extract the following entities with its respective method

  • Subscription -> dynamically
  • Customer -> dinamically
  • Invoice -> dinamically
  • SubscriptionLine -> dinamically
  • SubscriptionPriceInterval -> static
  • SubscriptionPlanStream -> dinamically
  • ChangeOrderLine -> static
  • CustomerPayment -> static
  • CustomlistGpyCompanysize -> dinamically
  • CustomlistGpyReadjustmentindex -> dinamically
  • SubscriptionChangeOrder -> static
  • Item -> static
  • MonthlyRecurringRevenue -> static
  • Charge -> dynamically
  • CustomRecordGpyChangeOrderClassific -> dynamically
  • BillingAccount -> dynamically
  • SubscriptionLineRevision -> static

SDK Dev Guide

See the dev guide for more instructions on how to use the SDK to develop your own taps and targets.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages