FlexOffers

The Switchboard FlexOffers connector provides automated reporting for sales and commision detail reports.

Prerequisites

To configure access to the FlexOffers Connector you need:

  • An Email Address and Password used to login to your FlexOffers account.

Scheduling

The FlexOffers connector can be scheduled to ingest data once per day at a user-defined hour and timezone. By default, the connector will run once at 6am PT. See Daily Scheduling for more information.

Parameters

Parameter Description Required/Optional?
status Allowed Values:

all
pending
approved
cancelled
bonus
non-commissionable
Required
report_type Allowed Values:

sales
details
Required
dateType Allowed Values:

clickDate
postedDate
eventDate
modifiedDate
Required

Sample Switchboard Script

import flexoffers_sales_raw from {
    type: "flex_offers";
    reportType: "sales";
    key: 'flexoffers_key';
    status: "all";
} using {
    flX_SalesId: integer;
    accountId: integer;
    categoryId: integer;
    categoryName: string;
    clickId: integer;
    currency: string;
    domainId: integer;
    domainName: string;
    legacyId: integer;
    clickDate: datetime;
    eventDate: datetime;
    modifiedDate: datetime;
    lockingDate: datetime;
    postedDate: datetime;
    merchantValue: float;
    commission: float;
    orderNumber: string;
    orderStatus: string;
    productId: integer;
    productName: string;
    programId: integer;
    programName: string;
    report_date: datetime;
    subId1: string;
    subId2: string;
    subId3: string;
    subId4: string;
    subId5: string;
    subTracking: string;
    tracking: string;
};


import flexoffers_details from {
    type: "flex_offers";
    reportType: "details";
    key: 'flexoffers_key';
    status: "all";
} using {
	accountId: integer;
	accountName: string;
	amount: float;
	clickDate: datetime;
	clickId: integer;
	commission: float;
	coupon: string;
	domainId: integer;
	domainName: string;
	eventDate: datetime;
	flX_SalesId: integer;
	legacyId: integer;
	lockingDate: datetime;
	modifiedDate: datetime;
	orderNumber: string;
	orderStatus: string;
	postedDate: datetime;
	programId: integer;
	programName: string;
	report_date: datetime;
	subId1: string;
	subId2: string;
	subId3: string;
	subId4: string;
	subId5: string;
	tracking: integer;
	items: [{
		itemName: string;
		sku: string;
		upCorEAN: string;
		quantity: integer;
		mpn: string;
		soldItemMerchantAmount: float;
		soldItemCommission: float;
	}];
};