xceled

xceled · ‎09-24-2021

Hoping that product managers/employees are roaming here. Need to talk about the Marketo REST API documentation and/or APIs. I'm doing what I imagine is fairly common development against the REST APIs. I'm using the formal Swagger file and documentation (https://developers.marketo.com/rest-api/endpoint-reference). I have now run into multiple examples where the definition of APIs do not match what Marketo REST services actually return. Most of them look less like documentation issues and more like bugs in the response type. Meaning, what the documentation says it should return is correct but what I actually get back in the API response is not correct. A few examples: Asset > Get Folders > ResponseOfFolderResponse > result > folderId > FolderId object returns "Value" property instead of "Id" for the folder id. Other APIs appear to properly return the documented version of the "Folder" object Asset >Send Sample EMail > ResponseOfIdResponse > Result > {"service":"sendTestEmail","result":true} instead of documented IdResponse object As a customer, this is frustrating and so far my interactions with support have been very poor. In most cases, support either seems to shrug off the issue and say to use the model I get back or tell me to send emails to some developer email address, to which no developers reply. The only way I got anyone to look into it is through escalating my support cases. But I keep finding more issues like this. So Marketo Product Manager over the REST API, if you're out there, there are some serious quality/support issues with your APIs that as a customer, I believe desperately need to be addressed.

xceled · ‎09-22-2021

Okay, so that's interesting. So as far as you know, the MSI "Add to Marketo Campaign" functionality will essentially only do a "RequestCampaign" API call to that campaign with that lead? If so, assuming the following: The campaign had a recurring schedule Had qualification rules to allow a person to go through the flow more than once Would it be correct then to say that any leads who only triggered the campaign due to MSI "Add to Marketo Campaign", that they would not go through the flows again? Essentially, does a one-time trigger via RequestCampaign, allow them to be qualified in future runs of the campaign?

xceled · ‎09-22-2021

When you say Microsoft Campaign, do you mean a record in Dynamics or some entity in Marketo? I have two campaigns available currently in the "Add to Marketing Campaign' MSI dialog but they are not also records in the native Dynamics "Campaign" entity. In fact their names match up to <Program>.<Campaign> records in Marketo.

xceled · ‎09-22-2021

Okay, so it sounds like I may have a misunderstanding of how the "Add To Campaign" function works in MSI. The name add to campaign specifically did not seem to be related to programs in Marketo but perhaps it is. So when I use that function in say Dynamics, it actually adds the Lead to a program that the campaign is a part of?

xceled · ‎09-22-2021

I'll test again, I ran the campaign manually once with a given lead in the qualified people tab and I didn't see the Lead become a member. Will retry to see if I missed something. Maybe its not instant. My question isn't related to Programs. Let me know if you have any thoughts about the other questions posed in my above question. Thanks!

xceled · ‎09-22-2021

Hello, I'm trying to replicate the closest thing to the "Add to Campaign" MSI feature in Dynamics CRM via the REST API. We don't plan to use the MSI feature from Marketo. It looks like one way to accomplish this is to have a Smart Campaign set with a SmartList containing a "Member of List" filter with a list created specifically for that campaign. Then in response to someone requesting we add a lead to a campaign, I would then add them to that list. So on next run of the campaign, that lead would be in "Qualified People" for that campaign and run the flows from the campaign on that lead. I was unable to find any way via the API to add a Lead directly to a Smart Campaign. Is is a correct understanding that doing this directly via the API is not an option? In the campaign configuration page, there is also a "View Campaign Members" button. Which shows Campaign Members tab and Qualified People tab. I can't figure out what results in leads being populated in the "Campaign Members" tab, but my above REST approach does seem to result in them showing up in the "Qualified People" tab. What is the "Campaign Members" tab for and what determines when leads show up there? Please let me know if you have any other insight related to implementing this type of functionality.

xceled · ‎09-14-2021

Currently, Marketo offers some "Bulk Export" functionality for situations where latency can be higher and many records need to be exported. This is marketed as an alternative to real time calls. However, transitioning from real-time calls to the bulk export feature is not straight forward because the data offered by the real-time call exceeds what is offered in the bulk export call. This specifically affects the data in the "Attributes" property that is offered by both API calls. The real-time call returns more data in that field than the bulk export call. For consistency and to avoid additional API calls when transitioning from real-time to the bulk export API, it should offer the exact same data points in the "Attributes" property as the real-time call.

xceled · ‎09-14-2021

Thank you @SanfordWhiteman for the information, I wish they would use swagger to document the response model field limits. I'm not just storing lead data, also other types, so my need is generic across any API that returns a response payload. E.g. Email subject length, folder name length, email description length.

xceled · ‎09-14-2021

Hello, We'd like to send emails using the "Request Campaign" REST API on demand, but it looks like we would have to create a new campaign for each email we want to allow sending via the API. This is is undesirable for a variety of reasons, the main being is we now have to have a 1:1 mapping of email to API enabled campaign which then has to be accessible to our programmatic logic. Is there a way to just pass in the email asset id and have the campaign pick/send that email from a single campaign? We still want the email sends to be tracked under the original email, so I don't think a single email with 'Dynamic Content" works for us. It seems like Marketo wants to make sending emails from the API the hardest operation for people to perform.

xceled · ‎09-13-2021

Hello, I'm consuming the REST API for various integrations in in some cases have to store data locally. I'd like to have my DB schema match the max lengths of Marketo data but am having issues finding how to determine the max field length of various data fields returned via the API. Can anyone suggest and approach or resource to assist here?

xceled · ‎08-03-2021

Hello, Is it possible to sync the Marketo Lead Id of Contact/Lead records from Marketo to Dynamics? If so can you please share details on where to configure this?

xceled · ‎07-23-2021

You say its not feasible, but it is, they make it work fast in other places. Their own MSI solution, does not suffer from this issue. It can retrieve these same 2 activities for this lead in a fraction of the time. It does not use the REST API. Their own web UI, does not use the REST API, it uses https://instance.marketo.com/leadDatabase/queryDetailLogData. Which again, does not suffer from this issue and returns all of this leads activities in under a second. So why, is the REST API, designed to not leverage the same performance design that their other solutions use? The accepted solution here seems like it should not be "work around it" but rather should be that Marketo fix their API.

xceled · ‎07-23-2021

Why is that an acceptable solution? That is an awful solution for the API consumers and introduces significant burden on API consumers to store and maintain entire databases and sync processes for ALL activity records to cover the situation where we might need to get the activity details on demand for a single lead. You mention " The behavior of the nextPageToken is well-known: it's a cursor through the entire log, not through a filtered subset of the log by only a single activity.", its not well known to me, I read the API docs and this behavior was not mentioned or warned as a concern to be aware of. I had to find out by doing direct testing with the API. Your comment says exactly what is the problem, if they know our filter criteria from our API call, why are they querying the database in such a way that they are not using it in the query itself and applying the filter AFTER getting database results, giving this poor API experience. That's a benefit of databases, is to let them do the heavy lifting with your predicates, not apply them after the fact. So this answer only seems to reinforce my concern with the design issues of the API. Why even offer an API if its so inflexible that the answer is to copy all the data locally and avoid using the API?

xceled · ‎07-23-2021

The main issue I am running into is with the "Get Lead Activities" API: https://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#!/Activities/getLeadActivitiesUsingGET For example, if I request all of the interesting moments from the past 90 days for a single lead, it takes 14 calls to the API passing new "nextPageToken" until there are no longer "moreResult" = true responses from Marketo. This is extremely slow, in our testing, takes about 28 seconds. In my first request, I pass a nextPageToken that is set at 90 days ago, and for my test Lead with id 835054, they have 2 interesting moments in that time period. So the result set is much less than 300, which is the total max batch size returned in a single response. So a single response should be able to return all Interesting Moment activities for this lead in the last 90 days. However it appears the Marketo implementation is not paginating by the batchSize parameter, but instead by some arbitrary period of time represented by each "nextPageToken". This design approach causes the performance issue by requiring us to execute 14 API calls in what could be returned in 1. 12 of these API calls return no data, that's 12 wasted calls against our API quota in addition to the processing time this adds. Need help to understand if there is anything we can do on our side, using the Marketo REST API, to improve this performance or if there needs to be a design change/enhancement to this API so that it paginates by returned row count, rather than arbitrary time periods. Marketo seems to have a less limited/better implementation they use on their own UI as they can return this Leads activities in a single call. So not sure why customers are only given the option to this extremely limited API.

xceled · ‎07-07-2021

When passing token data using the RequestCampaign API call, are there any field length limits on the values for the token types 'Rich Text' or 'Text'? Or any other restrictions on the API call that may restrict the amount of data passed via the tokens? Tokens are in the request body at the path: TriggerCampaignRequest>TriggerCampaignData>tokens https://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#!/Campaigns/triggerCampaignUsingPOST

Online Status	Offline
Date Last Visited	‎03-11-2022 11:04 AM

Date Registered	‎07-07-2021 10:19 AM
Date Last Visited	‎03-11-2022 11:04 AM
Total Messages Posted	16

Top Badges Earned

REST API Documentation - Product Quality Issue, do...

Re: Add to Campaign & couple questions - REST API ...

Re: Add to Campaign & couple questions - REST API ...

Re: Add to Campaign & couple questions - REST API ...

Re: Add to Campaign & couple questions - REST API ...

Add to Campaign & couple questions - REST API spec...

Bulk Export for Activities - "Attributes" property...

Re: API Documentation - How to find out max field ...

Request Campaign REST API - Generic approach with ...

API Documentation - How to find out max field leng...

Marketo -> Dynamics - Sync Lead Id

Re: Get Lead Activities - Design issue, performanc...

Re: Get Lead Activities - Design issue, performanc...

Get Lead Activities - Design issue, performance un...

API Question, RequestCampaign - Token Character Li...