Marketo V3 Connector

Back Next

Retrieve data from custom objects

You can retrieve data from a custom object in Marketo based on the search criteria you specify in a

synchronization

task or

mapping

task.

To retrieve custom object records from Marketo, configure the following advanced list properties in a

synchronization

task or

mapping

task for the specified custom source object:

The advanced source property field names, such as

Type Filter

Values Filter

Fields Filter

, and

String Values Filter

represent properties that you can configure for custom, opportunity, opportunity role, sales person, and company objects.

Custom Object - Type Filter

. Specify the filter type to retrieve the attributes of a custom object. You can specify one of the following filter types:

idField. The primary key of the custom object in Marketo.

dedupeFields. List of fields that define the unique row of the custom object in Marketo.

Default is dedupeFields.

Custom Object - Values Filter

. Specify the location of the .csv file that contains the filter values to retrieve specific custom object fields.

Custom Object - Fields Filter

. Specify the object fields that you want to retrieve. You can specify more than one value for the custom object fields, separated by a comma. If you do not specify the fields, all the default fields from Marketo are retrieved. The default fields retrieved include marketoGuid, dedupeFields, updatedAt, and createdAt.

Custom Object - String Values Filter

. Specify the filter values to retrieve specific custom object fields. When you specify the filter values, enter the column name of the custom object on which you want to apply the filter, followed by the filter string values on consecutive lines similar to the format in a CSV file. For example, to filter data based on email IDs, specify the filter values in the following format:

email_ID
jim@gmail.com
gerald@gmail.com
harry@gmail.com

If you specify both the

Custom Object - String Values Filter

and the

Custom Object - Values Filter

field, the Secure Agent considers the

Custom Object - Values Filter

field and uses the values in the CSV file to filter data from the custom object.

For example, specify the filter type as dedupeFields and the filter value as E:\Files\FilterValues_DDF_Reservation.csv, which contains the dedupe field values. Specify the custom object fields as createdAt,marketoGUID,updatedAt,pnr,TicketNumber for which you want to retrieve data from a flight reservation custom object.

The following table shows a sample of the retrieved custom object details:

createdAt	marketoGUID	updatedAt	pnr	TicketNumber
12/4/2015 04:48:00	2cc3a035-4274-4b34-abc3-9338cda7a1e4	12/4/2015 04:48:00	BAF57HG1	1001
12/4/2015 04:48:00	c0d1297d-aacc-4d74-8ac7-89490b36d811	12/4/2015 04:48:00	TAU64GS5	1002

Rename Saved Search

Table of Contents

Marketo V3 Connector

Marketo V3 Connector

Retrieve data from custom objects

Retrieve data from custom objects