Pulling Previous Data Value Using an API

[John1]

Hello! I have some leads that were updated accidentally and I would like to revert those values to a previous one. I know that it's not something you can do since there isn't an undo function in Marketo but I know that it's possible to pull that information using an API. Does anyone have any resources on how to do it? I am new to using APIs and any help will be useful. A majority of the leads were fixed but there are still some that needs to be updated again. 

Is this something that I should do, definitely don't want to break anything, just want to pull information. I have some coding experience but nothing too crazy

[SanfordWhiteman]

You want the Get Lead Changes endpoint: https://developer.adobe.com/marketo-apis/api/mapi/#operation/getLeadChangesUsingGET

First, get a paging token (https://developer.adobe.com/marketo-apis/api/mapi/#operation/getActivitiesPagingTokenUsingGET) for the time you know the mistakes started and move forward from there.

[SanfordWhiteman]

@John1 please return to your thread and check responses.

[John1]

Thank you! I found this page and was wondering how do I go about running this line of code in Marketo? Do you have another guide that I can refer to?

[SanfordWhiteman · Accepted solution]

Not sure what page you mean, but you can’t run any code “in Marketo” — you call the REST API from outside Marketo, in the language/platform of your choice.

[John1]

Ah I see! Thank you so much! Is there a platform that you would recommend? I managed to solve this manually unfortunately but would love to delve into it in the future, just in case!

[SanfordWhiteman]

Ah I see! Thank you so much! Is there a platform that you would recommend? I managed to solve this manually unfortunately but would love to delve into it in the future, just in case!

---

I primarily use JS in Node.js. Running from either

• my desktop
• a remote VM, for one-off jobs that are resource-intensive
• a Docker container, for always-on apps (lately I’ve been using Replit for small things, Clever Cloud for bigger)

But really it’s whatever you become comfortable with. I’ve got li’l Java apps for some stuff. PHP when features are faster to build there. One-time API exports can even be done via Postman — primitive, but it works — then transform the results in a CSV editor like Ron’s Data Edit.

As you can see, there’s a whole world out there!   

[Legitster]

I'll chime in here! 

For one time API requests (and in general for learning the API), Postman is an amazing desktop application. You cannot actually script anything in it, so if you need large batches you will need a place to run code. 

Microsoft Office and Google Workspaces both offer Javascript environments that run on top of their cloud documents. So you could have a spreadsheet and embed some buttons that do various scripted functions and even interact with the spreadsheet data. The learning curve is pretty steep but you can do some very powerful things with it, and also have it shared with other people in your org.

[SanfordWhiteman]

Well, you can use Postman to automate entire multi-step processes, with a combo of JS and their no-code flows.  

The problem, though, is it’s not a very portable skill. So unless you’re applying for a job at a place that uses Postman for automated QA, you’d be better off learning other environments and just treating Postman like an HTTP client.

[John1]

Thank you for your response! Appreciate it!