Integrate Amazon Selling Partner using Fiber

Sync your customers' dataFiber pulls data from your customers' Amazon Selling Partner accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

amazon_sp_financial_events

amazon_sp_inventory_summaries

amazon_sp_ledger_items

Your customers' Amazon accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Amazon Selling Partner API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the ListingItems belonging to the Amazon 
-- Selling Partner seller of a particular user. 

SELECT *
FROM fiber.amazon_sp_listing_item
WHERE seller_id = '{user.seller_id}'

-- Fetch all the ListingItems belonging to the Amazon 
-- Selling Partner seller of a particular user. 

SELECT *
FROM fiber.amazon_sp_listing_item
WHERE seller_id = '{user.seller_id}'

Code

CREATE TABLE fiber.amazon_sp_listing_item (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  seller_id TEXT,
  sku TEXT,
  summaries JSONB,
  issues JSONB,
  offers JSONB,
  fulfillment_availability JSONB,
  procurement JSONB,
  attributes JSONB
)

CREATE TABLE fiber.amazon_sp_listing_item (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  seller_id TEXT,
  sku TEXT,
  summaries JSONB,
  issues JSONB,
  offers JSONB,
  fulfillment_availability JSONB,
  procurement JSONB,
  attributes JSONB
)