Operative

The Operative connector provides automated access to your Operative data via SFTP.

Prerequisites
Scheduling
Parameters
Sample Switchboard Script

Prerequisites

The Operative connector requires you create a SFTP Key in the Key Manager.

The SFTP Key requires the following values:

SFTP Hostname
SFTP Port
An SFTP Account Username
Either an account password, or a SSH Private Key

Scheduling

The Operative connector can be scheduled to run multiple times a day at user-defined hour and timezone.

To configure this schedule, use the delay_hours parameter.
By default, the connector will run once at 6am PT.

Parameters

datafeed string: required; this is the SFTP path to the Operatve data files. The value will typically be datafeed/COMPANY_NAME
table string: required; the Operative data source requested

download operative_sales_order_line_items from {
    type: "operative_ng";
    datafeed: "datafeed/COMPANY_NAME";
    table: "Sales_Order_Line_Items";
    key: "operative_ftp_key";
} using {
    sales_order_line_item_id: integer;
    sales_order_line_item_name: string;
    product_id: integer;
    product_name: string;
    package_id: integer;
    package_name: string;
    media_plan_id: integer;
    media_plan_name: string;
    is_default_media_plan: boolean("1", "0", false);
    sales_order_line_item_start_date: date; // Operative Pull ingestion requires that this value stay in YYYY-MM-DD format 
    sales_order_line_item_end_date: date; // Operative Pull ingestion requires that this value stay in YYYY-MM-DD format 
    sales_order_line_item_version: integer;
    sales_order_id: integer;
    parent_line_item_id: integer;
    line_item_status: string;
    net_unit_cost: float;
    cost_type: string;
    quantity: integer;
    unit_type: string;
    production_quantity: integer;
    net_cost: float;
    is_makegood: boolean("1", "0", false);
    makegood_note: string;
    can_output: boolean("1", "0", false);
    can_produce: boolean("1", "0", false);
    can_invoice: boolean("1", "0", false);
    booking_type: string;
    has_performance_data: boolean("1", "0", false);
    can_delete: boolean("1", "0", false);
    can_discount: boolean("1", "0", false);
    can_commission: boolean("1", "0", false);
    rate_card_id: integer;
    goal_price: float;
    floor_price: float;
    rate_card_price: float;
    agency_commission_rate: float;
    gross_unit_cost: float;
    gross_cost: float;
    forecast_category: string;
    organization_id: integer;
    is_reserved: boolean("1", "0", false);
    reservation_expiration_date: datetime;
    billable_third_party: string;
    other_third_party: string;
    rich_media_vendor: string;
    tax_profile_id: integer;
    tax_profile_name: string;
    created_by: string;
    created_by_id: integer;
    created_on: datetime;
    last_modified_by: string;
    last_modified_by_id: integer;
    last_modified_on: datetime;
    total_discounts: float;
    discount_profile_id: integer;
    discount_profile_name: string;
    preset_schedule_id: integer;
    preset_schedule_name: string;
    issue_id: integer;
    issue_name: string;
    unit_cost_before_discounts: float;
    premium_for_ucbd: float;
    ucbd_with_premium: float;
    section_id: integer;
    section_name: string;
    primary_mdsp_id: integer;
    primary_mdsp_name: string;
    thirdparty_mdsp_id: integer;
    thirdparty_mdsp_name: string;
    start_time: string;
    end_time: string;
    section_Type: string;
    is_added_value: boolean("1", "0", false);
    added_value_amount: float;
    share_of_voice: float;
    p2_plus_impressions: float;
    p2_plus_CPM: float;
    connect_partner_lineitem_id: integer;
    connect_partner_order_ID: integer;
};