I wrote a post a few weeks back covering the datetime fields in Airtable but wanted to go a step further and show you how you can use the fields along with formulas to really bring your table to life and view dates and time in a more meaningful way. Unit Specifier Before diving into…
When you call a Marketo API endpoint it will most likely return a success – meaning return a response code of 200 – to Python, even if the call wasn’t a success with Marketo. This means that if you use a Try/Except block, it won’t pick up an error and run the Except block.This means…
One of my favorite AI tools is Speech Synthesis from ElevenLabs. I think the voice cloning is incredible. You can take a 1 to 2 minute clip of someone talking (I usually use podcasts or audiobooks to get a clean sample), and use the VoiceLab Instant Voice Cloning to upload it. You can adjust the…
I have done a lot of posts and videos about how to use the Marketo API with Postman but now I want to talk about Python to take it to the next level. Jep Castelein does maintain a Marketo repository on GitHub but my examples below are from how I taught myself how to do…
There is a joke that goes something like “why spend 15 minutes doing a task manually when you can spend 3 hours automating it?”. While it might sound ridiculous at first, there are actually several benefits to automating tasks that would take less time to do manually. This task (or its evil twin) will show…
The Google Sheets connector in Workato has several out of the box actions such searching, updating, and adding rows but there is nothing for deleting or clearing rows. This can be accomplished with a custom action. As with anytime you are deleting data, make sure you are careful with the implementation so you don’t discard…
Come on brain, think. It’s frustrating when you want to create something impactful but your brain won’t cooperate. We know that there are a trillion ideas out there and yet we can’t seem to find them. We’re stuck. How do we get unstuck? Below are some of the strategies I use to break out of…
I had been searching for a long time for the perfect personal budget app. I had used Mint but it wasn’t as flexible as I needed it to be, and Excel and Google Sheets lacked user friendliness and advanced features. Luckily, Airtable is a perfect tool to do everything I need. Clone my personal budget…
Last week, I was building a recipe in Workato using an HTTP connector and the JSON response format contained periods in the keys. Apparently, they did this instead of using nested JSON. I had never encountered that before but didn’t think much of it. When I went to use a datapill, I received a warning…
The rollup field in Airtable is an excellent way to summarize data from a linked table in the same base. As the name implies, any time you want to roll data up to a larger “bucket”, the rollup field will be useful. The Budget Example I created this Budget template base that you can use…
Dates are a funny thing in programming because they can have so many different formats and then timezones add an extra degree of complexity. Dates in Airtable are no different. If a record displays a date and time of 4:39 on 11/2/23, some people will think that is 4 o’clock in the morning on February…
I had a project where I had to integrate an event app in Workato and it proved a challenge because each event had their own keys so I couldn’t use datapills. They used long random strings for their key names instead of a standard name each time. For instance, all of our events have a…
Tokens are one of the best things about using Marketo and can make your program and asset builds more efficient but they can also take a while to create or update manually. If your instance is using program templates (I sincerely hope you are) they are most likely tokenized with all of the variables that…
If you have ever updated a landing page templates or edited a form used by a lot of landing pages in Marketo, you know how time consuming it can be to go back and reapprove all of the landing pages. Luckily, this is another area where the Marketo API can save us countless hours of…
Postman is a great tool for testing and using the Marketo API. It becomes even more powerful when you use environments to store information for variables, including the authentication token. Doing this will mean you will no longer have to keep going back to Launchpoint to get your token and can easily refresh the token…