Exporting list of programs in workspaces

2 replies
1512 views
Translate All

Anyone knows how to export the list of programs in workspaces?

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Josh_Hill13

Level 10

Do you mean share it to another WS or just get a list?

Translate

Jep_Castelein2

Level 10

There is no export in the user interface, but you can use the getMObject API call in the SOAP API. You need to be a little tech savvy, but no need to be a developer. There is a free tool called SOAP UI and the you can generate the security header here. This is the documentation of the API call: http://developers.marketo.com/documentation/soap/getmobjects/

Here is the code to list all the programs for the Workspace "Europe" (you can only query one workspace at a time):

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:mkt="http://www.marketo.com/mktows/">
<soapenv:Header>
<mkt:AuthenticationHeader>
<mktowsUserId>?</mktowsUserId>
<requestSignature>?</requestSignature>
<requestTimestamp>2014-11-20T17:46:41-07:00</requestTimestamp>
</mkt:AuthenticationHeader>
</soapenv:Header>
<soapenv:Body>
<mkt:paramsGetMObjects>
<type>Program</type>
<mObjCriteriaList>

<mObjCriteria>
<attrName>Workspace Name</attrName>
<comparison>EQ</comparison>
<attrValue>Europe</attrValue>
</mObjCriteria>
</mObjCriteriaList>
</mkt:paramsGetMObjects>
</soapenv:Body>
</soapenv:Envelope>

This is the response (from my test instance):

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.marketo.com/mktows/">
<SOAP-ENV:Body>
<ns1:successGetMObjects>
<result>
<returnCount>6</returnCount>
<hasMore>false</hasMore>
<newStreamPosition>*</newStreamPosition>
<mObjectList>
<mObject>
<type>Program</type>
<id>1056</id>
<attribList>
<attrib>
<name>Name</name>
<value>Dynamic Content Test EU</value>
</attrib>
<attrib>
<name>Type</name>
<value>Marketing Program</value>
</attrib>
<attrib>
<name>Workspace Id</name>
<value>4</value>
</attrib>
<attrib>
<name>Workspace Name</name>
<value>Europe</value>
</attrib>
<attrib>
<name>Tree Path</name>
<value>/Marketing Activities/Europe/Folder/Program to Move/Dynamic Content Test EU</value>
</attrib>
<attrib>
<name>Is Archived</name>
<value>false</value>
</attrib>
</attribList>
<typeAttribList>
<typeAttrib>
<attrType>Tag</attrType>
<attrList>
<attrib>
<name>Type</name>
<value>Channel</value>
</attrib>
<attrib>
<name>Value</name>
<value>Email Blast</value>
</attrib>
</attrList>
</typeAttrib>
</typeAttribList>
</mObject>

... deleted 5 out of 6 objects because post was too large

</mObjectList>
</result>
</ns1:successGetMObjects>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Translate

Sign up

Login with SSO

Login to the community

Login with SSO