Endpoint

Read Preferred Campaign Data

Name

get_preferred_campaigns

No description available

Parameter	Label	Required
start_date	start_date	NO
end_date	end_date	NO
resolution	resolution	NO
metrics	metrics	NO
page	page	NO
page_size	page_size	NO
timezone	timezone	NO

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

If the column you are looking for is missing, consider customizing Nativo Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Nativo Connector in API Source component to read data or in API Destination component to read/write data:

Nativo

Read Preferred Campaign Data

Nativo

Read Preferred Campaign Data

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_preferred_campaigns

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_preferred_campaigns';

EXEC (@MyQuery) AT [LS_TO_NATIVO_IN_GATEWAY];