Singer.io tap for extracting data from Amazon Seller Partner API.
Project description
tap-amazon-sp
This is a Singer tap that produces JSON-formatted data following the Singer spec.
This tap:
- Pulls raw data from Amazon SP API
- Extracts the following resources:
- Outputs the schema for each resource
- Incrementally pulls data based on the input state
Install
pip install tap-amazon-sp
Usage
- Follow Singer.io Best Practices for setting up separate
tap
andtarget
virtualenvs to avoid version conflicts. - Create a config file ~/config.json with Amazon Seller Partner API credentials. Multiple accounts across
different marketplaces are supported. Here is a list of marketplace names.
{ "accounts": [ { "selling_partner_id": "NA_SELLING_PARTNER_ID", "marketplaces": ["US", "MX", "CA"], "refresh_token": "env[NA_REFRESH_TOKEN]" }, { "selling_partner_id": "AU_SELLING_PARTNER_ID", "marketplaces": ["AU"], "refresh_token": "env[AU_REFRESH_TOKEN]" } ], "access_key_id": "ACCESS_KEY_ID", "secret_access_key": "env[SECRET_ACCESS_KEY]", "sp_role_arn": "arn:aws:iam::1234567890:role/RoleName", "lwa_client_id": "CLIENT_ID", "lwa_client_secret": "env[LWA_CLIENT_SECRET]", "start_date": "2021-01-01T00:00:00Z", "rate_limit_backoff_seconds": 60 }
- Discover catalog:
tap-amazon-sp -d > catalog.json
- Select
orders
stream in the generatedcatalog.json
.... "stream": "orders", "metadata": [ { "breadcrumb": [], "metadata": { "table-key-properties": [ "AmazonOrderId" ], "forced-replication-method": "INCREMENTAL", "valid-replication-keys": [ "LastUpdateDate" ], "inclusion": "available", "selected": true <-- Somewhere in the huge catalog file, in stream metadata. } }, ... ] ...
- Use following command to sync all orders with order items, buyer info and shipping address (when available).
tap-amazon-sp -c config.json --catalog catalog.json > output.txt
Copyright © 2021 Vibe Inc
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
tap-amazon-sp-0.1.1.tar.gz
(14.6 kB
view hashes)
Built Distribution
Close
Hashes for tap_amazon_sp-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ab18d97760af0f571956f67ad77dae66c527962d3ab9447c1b25c08fcd6732a |
|
MD5 | debac73b583d1ab85d7a0cf3b2c39cfd |
|
BLAKE2b-256 | 2f722420a40c967c465d23ebfaf710c49124aea3c8bbe936bd7a6ffa154e7727 |