One Click Retail

This document provides step-by-step instructions for importing data from One Click Retail. The following will be covered:

• One Click Retail Data Integration
• Advanced Options
• Data Schema

One Click Retail Data Integration

To integrate One Click Retail data into your Panoply warehouse using default settings, complete the following steps.

1. Click Data Sources in the navigation menu.
2. Click the Add Data Source button.
3. In the Data Sources - Choose Source Type window, select One Click Retail. One Click Retail is listed under APIs.
4. In the Data Sources – One Click Retail screen, enter your login credentials and click Login.
5. In the Data Sources – One Click Retail, screen, select which data to import.
6. (Optional) To Customize the ingestion from your data source, review the advanced options.
7. Click Collect.

The Data Sources – One Click Retail window will go gray while the data integration is pending. A small green progress bar will appear below One Click Retail once the integration has begun. A prompt will appear asking if you would like to set up the integration of another data source. Multiple data integrations can be set up without impacting the ingestion of the already scheduled or pending data integrations.

From the Data Sources main menu you can monitor the data ingestion status of the scheduled and pending data integrations. After the data ingestion is complete, you can clean or transform your data in the tables menu.

Advanced Options

Clicking Show next to Advanced will expand the Data Sources - One Click Retail window to include Destination, Primary Key, Exclude, Parse String and Truncate table.

Destination - Default is ocr_{__tablename}, where __tablename is the table name from the schema for this data source. See Data Schema for more detail about each table. Primary Key - Default is id. The primary key here determines which field(s) to use as the deduplication key when ingesting data.

Data schema

The One Click Retail data elements ingested by Panoply are listed below. One Click Retail data is collected from the ` https://api.oneclickretail.com/v3/clients/563a2d9c7371f/reports/csv` API endpoint.

OCR_reports - A collection of data describing products bought/sold, the type of basket they appeared in, and the geographical locations of shoppers.

Internal fields - In addition to the data schema details noted below, Panoply creates __updatetime and __senttime internal fields on all tables.

OCR_reports

As noted above, this data is collected from the https://api.oneclickretail.com/v3/clients/563a2d9c7371f/reports/csv API endpoint. In Panoply, the default One Click Retail data table is ocr_reports_csv and includes the following fields: