Overview
Configuration is provided for establishing connections with the Marketo service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Manage remote files and directories
Use File Transfer Task to manage remote files and directories.
Configuration
Base URL address: https://[instance].mktorest.com/rest.
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- client_id:
- client_secret:
The following request parameters will be automatically processed during the authentication process:
-
access_token:
{{=token.Access}}
Based on resource template BatchBase.
- [Read] action
-
Endpoint URL address:
/v1/leads.json.The following request parameters will be automatically processed:
-
fields:
{{=_.without(parameters.fields, 'activityDate', 'leadId').join()}} -
filterType:
{{=parameters.get('filterType')}} -
filterValues:
{{=parameters.get('filterValues')}}
Documentation: http://developers.marketo.com/documentation/rest/get-multiple-leads-by-filter-type.
-
fields:
- [Read programid] action
-
Endpoint URL address:
/v1/leads/programs/{{=parameters.programid}}.json.The action has the following user-defined parameters:
- programid: Required. Specify program identifier.
The following request parameters will be automatically processed:
-
fields:
{{=_.without(parameters.fields, 'activityDate', 'leadId').join()}}
Documentation: http://developers.marketo.com/documentation/rest/get-multiple-leads-by-program-id/.
- [Read deleted] action
-
Endpoint URL address:
/v1/activities/deletedleads.json.
The result is paginated.The action has the following user-defined parameters:
- deleted: Required. Specify deleted since.
The following request parameters will be automatically processed:
-
fields:
{{=_.without(parameters.fields, 'activityDate', 'leadId').join()}}
Documentation: http://developers.marketo.com/documentation/rest/get-deleted-leads/.
- [Read listId] action
-
Endpoint URL address:
/v1/list/{{=Marketo.getListId(parameters.listId)}}/leads.json.The action has the following user-defined parameters:
- listId: Required. Specify list identifier.
The following request parameters will be automatically processed:
-
fields:
{{=_.without(parameters.fields, 'activityDate', 'leadId').join()}}
Documentation: http://developers.marketo.com/documentation/rest/get-multiple-leads-by-list-id/.
- [Create] action
-
Endpoint URL address:
/v1/leads.json.Documentation: http://developers.marketo.com/documentation/rest/createupdate-leads/.
- [Update] action
-
Endpoint URL address:
/v1/leads.json.Documentation: http://developers.marketo.com/documentation/rest/createupdate-leads/.
- [Upsert] action
-
Endpoint URL address:
/v1/leads.json.Documentation: http://developers.marketo.com/documentation/rest/createupdate-leads/.
- [Delete] action
-
Endpoint URL address:
/v1/leads.json.The following request parameters will be automatically processed:
-
_method:
DELETE -
deleteBy:
Documentation: http://developers.marketo.com/documentation/rest/delete-lead/.
-
_method:
- activityDate
-
Template: DateTime. A read-only field.
Documentation: Returned when deleted parameters is used..
- leadId
-
Template: Id. A read-only field.
Documentation: Returned when deleted parameters is used..
- [External]
-
The external fields URL address:
/v1/leads/describe.json. The external fields list is extracted from:{{=response.result}}.-
Documentation: http://developers.marketo.com/documentation/rest/describe/.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/lists.json.Documentation: http://developers.marketo.com/documentation/rest/get-multiple-lists/.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: ShortText.
- programName
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/campaigns.json.Documentation: http://developers.marketo.com/documentation/rest/get-multiple-campaigns/.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: ShortText.
- programName
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- active
Data type: DT_BOOL
- programId
Template: Id.
- type
Template: ShortText.
- workspaceName
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/activities/leadchanges.json.
The result is paginated.The action has the following user-defined parameters:
- sinceDatetime: http://developers.marketo.com/documentation/rest/get-paging-token/
The following request parameters will be automatically processed:
-
fields:
{{=_.filter( parameters.fields, function(item) { return item != 'leadId' && item != 'activityDate' && item != 'activityTypeId' && !_.startsWith(item, 'Old ') && !_.startsWith(item, 'New '); }).join() }}
Documentation: http://developers.marketo.com/documentation/rest/get-lead-changes/.
- id
A key field. Template: Id.
- leadId
Template: Id.
- activityDate
Template: DateTime.
- activityTypeId
Template: Id.
- [External]
-
The external fields URL address:
/v1/leads/describe.json. The external fields list is extracted from:{{=response.result}}.- {{=Marketo.getFieldName(external)}}
- [External]
-
The external fields URL address:
/v1/leads/describe.json. The external fields list is extracted from:{{=response.result}}.- {{=Marketo.getFieldName(external)}}
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/emailTemplates.json.Documentation: http://developers.marketo.com/documentation/asset-api/get-email-templates.
- [Create] action
-
Endpoint URL address:
/asset/v1/emailTemplates.json.Documentation: http://developers.marketo.com/documentation/asset-api/create-email-template/.
- [Update] action
-
Endpoint URL address:
/asset/v1/emailTemplate/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/asset-api/update-email-template/.
- [Delete] action
-
Endpoint URL address:
/asset/v1/emailTemplate/{{=item.id}}/delete.json.Documentation: http://developers.marketo.com/documentation/asset-api/delete-email-template-by-id/.
- programName
Template: ShortText.
- folder
Template: Folder.
- status
Template: ShortText.
- workspace
Template: ShortText. A read-only field.
- content
Template: LongText. The value is gathered from
/asset/v1/emailTemplate/{{=item.id}}/content.jsonaddress. The gathered value is processed with{{=response['result'][0].content}}expression. The value is sent to/asset/v1/emailTemplate/{{=item.id}}/content.jsonaddress.
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/emails.json.Documentation: http://developers.marketo.com/documentation/asset-api/get-emails/.
- [Create] action
-
Endpoint URL address:
/asset/v1/emails.json.Documentation: http://developers.marketo.com/documentation/asset-api/create-email.
- [Update] action
-
Endpoint URL address:
/asset/v1/email/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/asset-api/update-email/.
- [Delete] action
-
Endpoint URL address:
/asset/v1/email/{{=item.id}}/delete.json.Documentation: http://developers.marketo.com/documentation/asset-api/delete-email-by-id/.
- programName
Template: ShortText.
- folder
Template: Folder.
- status
Template: ShortText.
- workspace
Template: ShortText. A read-only field.
- subject
-
Template: ShortText. The value is sent to
/asset/v1/email/{{=item.id}}/content.jsonaddress. Field components:-
Uses template:
ShortText. - Contains the following components: type, value.
Documentation: http://developers.marketo.com/documentation/asset-api/update-email-content-by-id.
-
Uses template:
- fromName
-
Template: ShortText. The value is sent to
/asset/v1/email/{{=item.id}}/content.jsonaddress. Field components:-
Uses template:
ShortText. - Contains the following components: type, value.
Documentation: http://developers.marketo.com/documentation/asset-api/update-email-content-by-id.
-
Uses template:
- fromEmail
-
Template: ShortText. The value is sent to
/asset/v1/email/{{=item.id}}/content.jsonaddress. Field components:-
Uses template:
ShortText. - Contains the following components: type, value.
Documentation: http://developers.marketo.com/documentation/asset-api/update-email-content-by-id.
-
Uses template:
- replyTo
-
Template: ShortText. The value is sent to
/asset/v1/email/{{=item.id}}/content.jsonaddress. Field components:-
Uses template:
ShortText. - Contains the following components: type, value.
Documentation: http://developers.marketo.com/documentation/asset-api/update-email-content-by-id.
-
Uses template:
- operational
Data type: DT_BOOL
- textOnly
Data type: DT_BOOL A read-only field.
- publishToMSI
Data type: DT_BOOL A read-only field.
- webView
Data type: DT_BOOL A read-only field.
- template
Template: Id.
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/snippets.json.Documentation: http://developers.marketo.com/documentation/asset-api/get-snippets/.
- [Create] action
-
Endpoint URL address:
/asset/v1/snippets.json.Documentation: http://developers.marketo.com/documentation/asset-api/create-snippet/.
- [Update] action
-
Endpoint URL address:
/asset/v1/snippet/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/asset-api/update-snippet/.
- [Delete] action
-
Endpoint URL address:
/asset/v1/snippet/{{=item.id}}/delete.json.Documentation: http://developers.marketo.com/documentation/asset-api/delete-snippet-by-id/.
- programName
Template: ShortText.
- folder
Template: Folder.
- status
Template: ShortText.
- workspace
Template: ShortText. A read-only field.
- url
Template: ShortText. A read-only field.
- content
Template: LongText. The value is gathered from
/asset/v1/snippet/{{=item.id}}/content.jsonaddress. The gathered value is processed with{{=(response.find(function(item) {return item.type == 'HTML';}) || {}).content}}expression. The value is sent to/asset/v1/snippet/{{=item.id}}/content.jsonaddress.
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/folders.json.The following request parameters will be automatically processed:
-
root:
{{=Marketo.getFolderId(parameters.get('root'))}}
Documentation: http://developers.marketo.com/documentation/asset-api/browse-folders/.
-
root:
- [Create] action
-
Endpoint URL address:
/asset/v1/folders.json.Documentation: http://developers.marketo.com/documentation/asset-api/create-folder.
- [Update] action
-
Endpoint URL address:
/asset/v1/folder/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/asset-api/update-folder/.
- [Delete] action
-
Endpoint URL address:
/asset/v1/folder/{{=item.id}}/delete.json.The following request parameters will be automatically processed:
-
type:
{{=parameters.type}}
Documentation: http://developers.marketo.com/documentation/asset-api/delete-folder-by-id/.
-
type:
- programName
Template: ShortText.
- parent
Template: ShortText. Before setting, the value is processed with
{{=Marketo.getFolderId(item.parent)}}expression.- workspace
Template: ShortText. A read-only field.
- type
Template: ShortText. The gathered value is processed with
{{=item.folderId.type}}expression. The value is sent to/asset/v1/folder/{{=item.id}}.jsonaddress.- url
Template: ShortText. A read-only field.
- path
Template: ShortText. A read-only field.
- isArchive
Data type: DT_BOOL The value is sent to
/asset/v1/folder/{{=item.id}}.jsonaddress.- isSystem
Data type: DT_BOOL A read-only field.
- accessZoneId
Template: Id. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/asset/v1/folder/{{=parameters.id}}/tokens.json.
The result is extracted from:{{=response.result[0].tokens}}.
The result is paginated.The following request parameters will be automatically processed:
-
nextPageToken:
-
batchSize:
-
offset:
{{=parameters.iterator}} -
maxReturn:
{{=parameters.batchSize}} -
folderType:
{{=parameters.folderType}}
Documentation: http://developers.marketo.com/documentation/asset-api/get-tokens-by-folder-id/.
-
nextPageToken:
- [Create] action
-
Endpoint URL address:
/asset/v1/folder/{{=item.folder.id}}/tokens.json.The following request parameters will be automatically processed:
-
folderType:
{{=item.folder.type}}
Documentation: http://developers.marketo.com/documentation/asset-api/create-token-by-folder-id/.
-
folderType:
- folder
Template: Folder. Before setting, the value is processed with
{{=Marketo.getFolderId(item.folder)}}expression.- type
Template: ShortText.
- name
Template: ShortText.
- value
Template: ShortText.
- computedUrl
Template: ShortText. A read-only field.
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/files.json.Documentation: http://developers.marketo.com/documentation/asset-api/list-files.
- [Create] action
-
Endpoint URL address:
/asset/v1/files.json.The following request parameters will be automatically processed:
-
file:
{{=item.content}}
Documentation: http://developers.marketo.com/documentation/asset-api/create-a-file.
-
file:
- programName
Template: ShortText.
- size
Data type: DT_I4
- mimeType
Template: ShortText.
- url
Template: ShortText.
- folder
Template: Folder.
- folder.id
Template: ShortText.
- folder.name
Template: ShortText.
- content
Data type: DT_IMAGE The value is gathered from
{{=item.url}}address.- insertOnly
Data type: DT_BOOL
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/landingPageTemplates.json.Documentation: http://developers.marketo.com/documentation/asset-api/get-multiple-landing-page-templates/.
- [Create] action
-
Endpoint URL address:
/asset/v1/landingPageTemplates.json.Documentation: http://developers.marketo.com/documentation/asset-api/create-landing-page-template/.
- [Update] action
-
Endpoint URL address:
/asset/v1/landingPageTemplate/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/asset-api/update-landing-page-template/.
- programName
Template: ShortText.
- folder
Template: Folder.
- status
Template: ShortText.
- workspace
Template: ShortText. A read-only field.
- url
Template: ShortText. A read-only field.
- content
Template: LongText. The value is gathered from
/asset/v1/landingPageTemplate/{{=item.id}}/content.jsonaddress. The gathered value is processed with{{=response['result'][0].content}}expression. The value is sent to/asset/v1/landingPageTemplate/{{=item.id}}/content.jsonaddress.
Based on resource template Asset.
- [Read] action
-
Endpoint URL address:
/asset/v1/programs.json.Documentation: http://developers.marketo.com/documentation/programs/browse-programs/.
- [Create] action
-
Endpoint URL address:
/asset/v1/programs.json.Documentation: http://developers.marketo.com/documentation/programs/create-a-program/.
- [Update] action
-
Endpoint URL address:
/asset/v1/program/{{=item.id}}.json.Documentation: http://developers.marketo.com/documentation/programs/update-program/.
- [Delete] action
-
Endpoint URL address:
/asset/program/{{=item.id}}/delete.json.Documentation: http://developers.marketo.com/documentation/programs/delete-program-by-id/.
- folder
Template: Folder.
- type
Template: ShortText.
- channel
Template: ShortText.
- tags
Template: ShortText.
- costs
Template: ShortText.
- status
Template: ShortText.
- workspace
Template: ShortText. A read-only field.
- url
Template: ShortText. A read-only field.
- content
Template: LongText. The value is gathered from
/asset/v1/emailTemplate/{{=item.id}}/content.jsonaddress. The gathered value is processed with{{=response['result'][0].content}}expression. The value is sent to/asset/v1/emailTemplate/{{=item.id}}/content.jsonaddress.
Based on resource template BatchBase.
- [Read] action
-
Endpoint URL address:
/v1/opportunities.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/get-opportunities/.
- [Create] action
-
Endpoint URL address:
/v1/opportunities.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities/.
- [Update] action
-
Endpoint URL address:
/v1/opportunities.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities/.
- [Upsert] action
-
Endpoint URL address:
/v1/opportunities.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities/.
- [Delete] action
-
Endpoint URL address:
/v1/opportunities/delete.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/delete-opportunities/.
- [External]
-
The external fields URL address:
/v1/opportunities/describe.json. The external fields list is extracted from:{{= function() { resource.keyField = response.result[0].idField; return response.result[0].fields; }() }}.
Based on resource template BatchBase.
- [Read] action
-
Endpoint URL address:
/v1/opportunities/roles.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/get-opportunity-roles/.
- [Create] action
-
Endpoint URL address:
/v1/opportunities/roles.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities-roles/.
- [Update] action
-
Endpoint URL address:
/v1/opportunities/roles.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities-roles/.
- [Upsert] action
-
Endpoint URL address:
/v1/opportunities/roles.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/createupdateupsert-opportunities-roles/.
- [Delete] action
-
Endpoint URL address:
/v1/opportunities/roles/delete.json.Documentation: http://developers.marketo.com/documentation/opportunity-api/delete-opportunity-roles/.
- [External]
-
The external fields URL address:
/v1/opportunities/roles/describe.json. The external fields list is extracted from:{{= function() { resource.keyField = response.result[0].idField; return response.result[0].fields; }() }}.
Based on resource template BatchBase.
- [Read] action
-
Endpoint URL address:
/v1/companies.json.Documentation: http://developers.marketo.com/documentation/company-api/get-companies/.
- [Create] action
-
Endpoint URL address:
/v1/companies.json.Documentation: http://developers.marketo.com/documentation/company-api/createupdateupsert-companies/.
- [Update] action
-
Endpoint URL address:
/v1/companies.json.Documentation: http://developers.marketo.com/documentation/company-api/createupdateupsert-companies/.
- [Upsert] action
-
Endpoint URL address:
/v1/companies.json.Documentation: http://developers.marketo.com/documentation/company-api/createupdateupsert-companies/.
- [Delete] action
-
Endpoint URL address:
/v1/companies/delete.json.Documentation: http://developers.marketo.com/documentation/company-api/delete-companies/.
- [External]
-
The external fields URL address:
/v1/companies/describe.json. The external fields list is extracted from:{{= function() { resource.keyField = response.result[0].idField; return response.result[0].fields; }() }}.
Based on resource template BatchBase.
- [Read] action
-
Endpoint URL address:
/v1/salespersons.json.Documentation: http://developers.marketo.com/documentation/sales-persons/get-sales-persons/.
- [Create] action
-
Endpoint URL address:
/v1/salespersons.json.Documentation: http://developers.marketo.com/documentation/sales-persons/createupdateupsert-sales-persons/.
- [Update] action
-
Endpoint URL address:
/v1/salespersons.json.Documentation: http://developers.marketo.com/documentation/sales-persons/createupdateupsert-sales-persons/.
- [Upsert] action
-
Endpoint URL address:
/v1/salespersons.json.Documentation: http://developers.marketo.com/documentation/sales-persons/createupdateupsert-sales-persons/.
- [Delete] action
-
Endpoint URL address:
/v1/salespersons/delete.json.Documentation: http://developers.marketo.com/documentation/sales-persons/delete-sales-persons/.
- [External]
-
The external fields URL address:
/v1/salespersons/describe.json. The external fields list is extracted from:{{= function() { resource.keyField = response.result[0].idField; return response.result[0].fields; }() }}.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/asset/v1/smartCampaigns.json.
The result is paginated.The following request parameters will be automatically processed:
-
nextPageToken:
-
batchSize:
-
offset:
{{=parameters.iterator}} -
maxReturn:
{{=parameters.batchSize}}
Documentation: https://developers.marketo.com/rest-api/endpoint-reference/asset-endpoint-reference/#/Smart_Campaigns/getAllSmartCampaignsGET.
-
nextPageToken:
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: ShortText.
- type
- isSystem
Data type: DT_BOOL
- isActive
Data type: DT_BOOL
- isRequestable
Data type: DT_BOOL
- recurrence
Field components:
-
Uses template:
DateTime. - Contains the following components: startAt, endAt, intervalType, interval, weekdayOnly, weekdayMask, dayOfMonth, dayOfWeek, weekOfMonth.
-
Uses template:
- qualificationRuleType
Template: ShortText.
- qualificationRuleInterval
Data type: DT_I4
- qualificationRuleUnit
Template: ShortText.
- maxMembers
Data type: DT_I4
- isCommunicationLimitEnabled
Data type: DT_BOOL
- smartListId
Template: Id.
- flowId
Template: Id.
- folder
Template: Folder.
- workspace
Template: ShortText.
- status
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/v1/customobjects/{{=resource.external.name}}.json.Documentation: http://developers.marketo.com/documentation/custom-api/get-custom-objects/.
- [Create] action
-
Endpoint URL address:
/v1/customobjects/{{=resource.external.name}}.json.Documentation: http://developers.marketo.com/documentation/custom-api/createupdateupsert-custom-objects/.
- [Update] action
-
Endpoint URL address:
/v1/customobjects/{{=resource.external.name}}.json.Documentation: http://developers.marketo.com/documentation/custom-api/createupdateupsert-custom-objects/.
- [Upsert] action
-
Endpoint URL address:
/v1/customobjects/{{=resource.external.name}}.json.Documentation: http://developers.marketo.com/documentation/custom-api/createupdateupsert-custom-objects/.
- [Delete] action
-
Endpoint URL address:
/v1/customobjects/{{=resource.external.name}}/delete.json.Documentation: http://developers.marketo.com/documentation/custom-api/delete-custom-objects/.
- [External]
-
The external fields URL address:
/v1/customobjects/{{=resource.external.name}}/describe.json. The external fields list is extracted from:{{= function() { resource.keyField = response.result[0].idField; return response.result[0].fields; }() }}. - [Read] action
-
Endpoint URL address:
/v1/activities.json.
The result is paginated.The action has the following user-defined parameters:
- sinceDatetime: http://developers.marketo.com/documentation/rest/get-paging-token/
The following request parameters will be automatically processed:
-
activityTypeIds:
{{=resource.external.id}}
Documentation: http://developers.marketo.com/documentation/rest/get-lead-activities/.
- id
A key field. Template: Id.
- leadId
Template: Id.
- activityDate
Template: DateTime.
- activityTypeId
Template: Id.
- primaryAttributeValueId
Template: Id.
- primaryAttributeValue
Template: ShortText.
- [External]
-
The external fields list is extracted from:
{{=resource.external.attributes}}.- {{=external.name}}
The external resource list URL address: /v1/customobjects.json.
The external resource list is extracted from: {{=response.result}}.
Based on resource template BatchBase.
The external resource list URL address: /v1/activities/types.json.
The external resource list is extracted from: {{=response.result}}.
Based on resource template Base.
- [Read] action
-
The result is extracted from:{{=response.result}}.
The result is paginated.The following request parameters will be automatically processed:
-
nextPageToken:
{{=parameters.iterator}} -
batchSize:
{{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
-
nextPageToken:
- [Create] action
-
The result is extracted from:{{=response.result[0]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}} -
_includeUserParameters:
{{=parameters}}
-
application/json:
- [Update] action
-
The result is extracted from:{{=response.result[0]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}} -
_includeUserParameters:
{{=parameters}}
-
application/json:
- [Upsert] action
-
The result is extracted from:{{=response.result[0]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}} -
_includeUserParameters:
{{=parameters}}
-
application/json:
- [Delete] action
-
The result is extracted from:{{=response.result[0]}}.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
- [External]
-
- {{=Marketo.getFieldName(external)}}
Template: {{=(Marketo.getDataType(external.dataType) == 'DT_DBTIMESTAMP') ? 'DateTime' : ''}}. Data type: {{=Marketo.getDataType(external.dataType)}} ( length {{=external.length || 255}} )
Based on resource template Base.
- [Read] action
-
The following request parameters will be automatically processed:
-
fields:
{{=parameters.fields.join()}}
-
fields:
- [Create] action
-
The result is extracted from:{{=response.result}}.The following request parameters will be automatically processed:
-
application/json:
{{={'input':batch} }} -
action:
createOnly
-
application/json:
- [Update] action
-
The result is extracted from:{{=response.result}}.The following request parameters will be automatically processed:
-
application/json:
{{={'input':batch} }} -
action:
updateOnly
-
application/json:
- [Upsert] action
-
The result is extracted from:{{=response.result}}.The following request parameters will be automatically processed:
-
application/json:
{{={'input':batch} }} -
action:
createOrUpdate
-
application/json:
- [Delete] action
-
The result is extracted from:{{=response.result}}.The following request parameters will be automatically processed:
-
application/json:
{{={'input':batch} }} -
deleteBy:
{{=parameters.deleteBy}}
-
application/json:
Based on resource template Base.
- [Read] action
-
The result is paginated.The following request parameters will be automatically processed:
-
nextPageToken:
-
batchSize:
-
offset:
{{=parameters.iterator}} -
maxReturn:
{{=parameters.batchSize}} -
folder:
{{=Marketo.getFolderId(parameters.get('folder'))}}
-
nextPageToken:
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- DateTime
-
Data type: DT_DBTIMESTAMP The gathered value is processed with
{{=(value && value.replace('Z+0000', 'Z')) || undefined}}expression.Documentation: Patch for bizarre datetime value returned by Marketo..
- Id
Data type: DT_I4
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 4000 )
- Folder
Data type: DT_WSTR ( length 255 ) Before setting, the value is processed with
{{=Marketo.getFolderId(item.folder)}}expression. Field components:- Contains the following components: type, value, folderName.
What's New
- New: Support for 'Smart Campaign' resource.
- Fixed: REST Source component failed with error (Thank you, Paul):
"Template: {{=external.rest.name=='id'}}
Field: undefined
Value: undefined
Error: TypeError: undefined cannot be converted to an object"
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.