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;
}];
};