Integrate OneDrive using Fiber

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

→

Fiber

→

postgres-prod

onedrive_files

Your customers' OneDrive accounts

Your production database

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

-- Fetch all the Files belonging to the OneDrive 
-- account of a particular user. 

SELECT *
FROM fiber.onedrive_file
WHERE account_id = '{user.onedrive_id}'

-- Fetch all the Files belonging to the OneDrive 
-- account of a particular user. 

SELECT *
FROM fiber.onedrive_file
WHERE account_id = '{user.onedrive_id}'

Code

CREATE TABLE fiber.onedrive_file (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  contents TEXT,
  byte_size DOUBLE PRECISION,
  encoding TEXT,
  mime_type TEXT
)

CREATE TABLE fiber.onedrive_file (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  contents TEXT,
  byte_size DOUBLE PRECISION,
  encoding TEXT,
  mime_type TEXT
)