importToList
通过此函数,您可以将潜在客户列表导入Marketo中的现有静态列表,类似于Marketo UI中的导入列表函数。
导入格式: ?这些值与列表导入中使用的颁厂痴结构相同。
示例:
电子邮件
第一
最后一个
joe@company.com
Joe
Smith
mary@company.com
玛丽
罗杰斯
wanda@megacorp.com
万达
威廉姆斯
displayName
值应在importFileHeader
中使用,而不是name
值。
动态电子邮件内容: ?或者,您可以按潜在客户传递值,以代替电子邮件中的“我的令牌”。
电子邮件
第一
最后一个
{{my.specialToken}}
{{my.otherToken}}
joe@company.com
Joe
Smith
鱼
蓝色
mary@company.com
玛丽
罗杰斯
鸡肉
棕色
wanda@megacorp.com
万达
威廉姆斯
维吉
黑兹尔
重要信息: ?如果您为潜在客户添加了令牌,则必须指定使用它们的Smart Campaign。 下次运行指定的Smart Campaign时,将使用列表中的值,而不是正常的“我的令牌”值。 运行该单个营销活动后,令牌将被丢弃。
importToList
可能需要一些时间才能完成,尤其是对于大型列表。 如果您计划在其他API调用中使用新导入的列表,您应使用importToListStatus
来检查操作是否完成。
注意: ?导入CSV文件中数值字段的NULL值可能会为这些字段生成“更改数据值”活动,即使该字段已为空。 任何使用“数据值已更改”过滤器或“数据值更改”触发器的智能营销活动,都可能导致潜在客户有资格参与这些营销活动,即使数据实际上没有更改。 对这些过滤器/触发器使用限制,以确保潜在客户在执行导入时不符合错误营销活动的条件。
请求
字段名称
必需/可选
描述
项目名称
必需
包含静态列表的程序的名称
campaignName
可选
如果使用“我的令牌”覆盖,则这是将使用这些令牌的营销活动的名称。 活动必须在指定的项目范围内。
listName
必需
将潜在客户添加到的惭补谤办别迟辞中的静态列表的名称
importfileheader
必需
要导入的潜在客户的列标题,包括潜在客户属性和我的令牌名称。
importFileRows->stringItem
必需
逗号分隔值,每个潜在客户占一行
importListMode
必需
有效选项:
UPSERTLEADS
和LISTONLY
clearList
可选
如果为迟谤耻别,则在导入之前清除静态列表;如果为蹿补濒蝉别,则附加潜在客户。
请求齿惭尝
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.marketo.com/mktows/">
<SOAP-ENV:Header>
<ns1:AuthenticationHeader>
<mktowsUserId>demo17_1_809934544BFABAE58E5D27</mktowsUserId>
<requestSignature>17bf0b9e412e58eec836dc557ca9433f666944b6</requestSignature>
<requestTimestamp>2013-08-05T14:56:58-07:00</requestTimestamp>
</ns1:AuthenticationHeader>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<ns1:paramsImportToList>
<programName>Trav-Demo-Program</programName>
<importFileHeader>Last Name,First Name,Job Title,Company Name,Email Address</importFileHeader>
<importFileRows>
<stringItem>Awesomesauce,Developer,Code Slinger,Marketo,dawesomesauce@marketo.com</stringItem>
<stringItem>Doe,Jane,VP Marketing,Jane Consulting,jdoe@janeconsulting.com</stringItem>
</importFileRows>
<importListMode>UPSERTLEADS</importListMode>
<listName>Trav-Test-List</listName>
<clearList>false</clearList>
<campaignName>Batch Campaign Example</campaignName>
</ns1:paramsImportToList>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
响应齿惭尝
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.marketo.com/mktows/">
<SOAP-ENV:Body>
<ns1:successImportToList>
<result>
<!-- Possible Values: COMPLETE/PROCESSING/FAILED/CANCELED -->
<importStatus>PROCESSING</importStatus>
</result>
</ns1:successImportToList>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
示例代码 — PHP
<?php
$debug = true;
$marketoSoapEndPoint = ""; // CHANGE ME
$marketoUserId = ""; // CHANGE ME
$marketoSecretKey = ""; // CHANGE ME
$marketoNameSpace = "http://www.marketo.com/mktows/";
// Create Signature
$dtzObj = new DateTimeZone("America/Los_Angeles");
$dtObj = new DateTime('now', $dtzObj);
$timeStamp = $dtObj->format(DATE_W3C);
$encryptString = $timeStamp . $marketoUserId;
$signature = hash_hmac('sha1', $encryptString, $marketoSecretKey);
// Create SOAP Header
$attrs = new stdClass();
$attrs->mktowsUserId = $marketoUserId;
$attrs->requestSignature = $signature;
$attrs->requestTimestamp = $timeStamp;
$authHdr = new SoapHeader($marketoNameSpace, 'AuthenticationHeader', $attrs);
$options = array("connection_timeout" => 20, "location" => $marketoSoapEndPoint);
if ($debug) {
$options["trace"] = true;
}
// Create Request
$request = new stdClass();
$request->programName = "Trav-Demo-Program";
$request->campaignName = "Batch Campaign Example";
$request->importFileHeader = "Last Name,First Name,Job Title,Company Name,Email Address";
$request->importFileRows = array("Awesomesauce,Developer,Code Slinger,Marketo,dawesomesauce@marketo.com","Doe,Jane,VP Marketing,Jane Consulting,jdoe@janeconsulting.com");
$request->importListMode = "UPSERTLEADS"; // UPSERTLEADS or LISTONLY
$request->listName = "Trav-Test-List";
$request->clearList = false;
$params = array("paramsImportToList" => $request);
$soapClient = new SoapClient($marketoSoapEndPoint ."?WSDL", $options);
try {
$response = $soapClient->__soapCall('importToList', $params, $options, $authHdr);
}
catch(Exception $ex) {
var_dump($ex);
}
if ($debug) {
print "RAW request:\n" .$soapClient->__getLastRequest() ."\n";
print "RAW response:\n" .$soapClient->__getLastResponse() ."\n";
}
print_r($response);
?>
示例代码 — Java
import com.marketo.mktows.*;
import java.net.URL;
import javax.xml.namespace.QName;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.GregorianCalendar;
import javax.crypto.Mac;
import javax.crypto.spec.SecretKeySpec;
import org.apache.commons.codec.binary.Hex;
import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBElement;
import javax.xml.bind.Marshaller;
import javax.xml.datatype.DatatypeFactory;
import javax.xml.datatype.XMLGregorianCalendar;
public class ImportToList {
public static void main(String[] args) {
System.out.println("Executing Import To List");
try {
URL marketoSoapEndPoint = new URL("CHANGE ME" + "?WSDL");
String marketoUserId = "CHANGE ME";
String marketoSecretKey = "CHANGE ME";
QName serviceName = new QName("http://www.marketo.com/mktows/", "MktMktowsApiService");
MktMktowsApiService service = new MktMktowsApiService(marketoSoapEndPoint, serviceName);
MktowsPort port = service.getMktowsApiSoapPort();
// Create Signature
DateFormat df = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssZ");
String text = df.format(new Date());
String requestTimestamp = text.substring(0, 22) + ":" + text.substring(22);
String encryptString = requestTimestamp + marketoUserId ;
SecretKeySpec secretKey = new SecretKeySpec(marketoSecretKey.getBytes(), "HmacSHA1");
Mac mac = Mac.getInstance("HmacSHA1");
mac.init(secretKey);
byte[] rawHmac = mac.doFinal(encryptString.getBytes());
char[] hexChars = Hex.encodeHex(rawHmac);
String signature = new String(hexChars);
// Set Authentication Header
AuthenticationHeader header = new AuthenticationHeader();
header.setMktowsUserId(marketoUserId);
header.setRequestTimestamp(requestTimestamp);
header.setRequestSignature(signature);
// Create Request
ParamsImportToList request = new ParamsImportToList();
request.setProgramName("Trav-Demo-Program");
request.setCampaignName("Batch Campaign Example");
request.setImportFileHeader("Last Name,First Name,Job Title,Company Name,Email Address");
ArrayOfString rows = new ArrayOfString();
rows.getStringItems().add("Awesomesauce,Developer,Code Slinger,Marketo,dawesomesauce@marketo.com");
rows.getStringItems().add("Doe,Jane,VP Marketing,Jane Consulting,jdoe@janeconsulting.com");
request.setImportFileRows(rows);
request.setImportListMode(ImportToListModeEnum.UPSERTLEADS);
request.setListName("Trav-Test-List");
request.setClearList(false);
SuccessImportToList result = port.importToList(request, header);
JAXBContext context = JAXBContext.newInstance(SuccessImportToList.class);
Marshaller m = context.createMarshaller();
m.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
m.marshal(result, System.out);
}
catch(Exception e) {
e.printStackTrace();
}
}
}
示例代码 — Ruby
require 'savon' # Use version 2.0 Savon gem
require 'date'
mktowsUserId = "" # CHANGE ME
marketoSecretKey = "" # CHANGE ME
marketoSoapEndPoint = "" # CHANGE ME
marketoNameSpace = "http://www.marketo.com/mktows/"
#Create Signature
Timestamp = DateTime.now
requestTimestamp = Timestamp.to_s
encryptString = requestTimestamp + mktowsUserId
digest = OpenSSL::Digest.new('sha1')
hashedsignature = OpenSSL::HMAC.hexdigest(digest, marketoSecretKey, encryptString)
requestSignature = hashedsignature.to_s
#Create SOAP Header
headers = {
'ns1:AuthenticationHeader' => { "mktowsUserId" => mktowsUserId, "requestSignature" => requestSignature,
"requestTimestamp" => requestTimestamp
}
}
client = Savon.client(wsdl: 'http://app.marketo.com/soap/mktows/2_3?WSDL', soap_header: headers, endpoint: marketoSoapEndPoint, open_timeout: 90, read_timeout: 90, namespace_identifier: :ns1, env_namespace: 'SOAP-ENV')
#Create Request
request = {
:program_name => "Trav-Demo-Program",
:import_file_header => "Last Name,First Name,Job Title,Company Name,Email Address",
:import_file_rows => {
:string_item => ["Awesomesauce,Developer,Code Slinger,Marketo,dawesomesauce@marketo.com", "Doe,Jane,VP Marketing,Jane Consulting,jdoe@janeconsulting.com"] },
:import_list_mode => "UPSERTLEADS",
:list_name => "Trav-Test-List",
:clear_list => "false",
:campaign_name => "Batch Campaign Example"
}
response = client.call(:import_to_list, message: request)
puts response
recommendation-more-help
bb269a6d-047a-4bf7-9acd-23ad9a63dc59