Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

Need event music? 🎸

Live and recorded jazz, pop, and meditative music for your virtual conference / Zoom wedding / yoga class / private party with quality sound and a smooth technical experience

Bienvenue! Welcome!

My goal is to help you work faster.

I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"

(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)

So check out the tutorials. Play with code. Tell me about your triumphs.

Salesforce Apex Performance: new ID map vs. for loop

08 Jul 2019 🔖 salesforce tips triggers 💬 EN

Salesforce developers: Have you ever hand-built a Map of SObjects by ID with a for loop? Are you sure you should?

Don’t forget about the magic of Apex’s keyword “new.”

It runs faster and can help reduce your CPU limit consumption.

Continue Reading

Tutoriel : types de données définis par Apex pour admins Salesforce

12 Jun 2019 🔖 salesforce flow integration architecture 💬 FR ( EN )

Depuis l’édition été 2019, Salesforce facilite la collaboration entre administrateurs et développeurs Salesforce pour augmenter des flux (Flow Builder) avec le code Apex à travers les «types de données définis par Apex».

Lire plus

Intro to HTTP

03 Jun 2019 🔖 tutorials api integration architecture 💬 EN

HTTP is easy to learn in five minutes, and familiarity is essential if you’d like to use “APIs” to integrate data between systems over the internet.

This post will give you a beginner-level foundation in HTTP.

Continue Reading

Tutorial: Flow Apex-Defined Data Types for Salesforce Admins

29 May 2019 🔖 tutorials api salesforce flow integration architecture 💬 EN ( FR )

This post is for Salesforce admins and developers, showing you how you can more easily work together to combine Flows and Apex with a new Summer ‘19 release called “Apex-Defined Data Types.”

Continue Reading

XML for Salesforce Administrators: DemandTools Configuration

08 May 2019 🔖 xml tutorials salesforce python demandtools 💬 EN

As we saw with flows, copying and pasting configuration settings within typically point-and-click “business logic tools” is a great reason to be able to read and write XML.

Let’s look at another handy “copy-paste” task for Salesforce admins: ensuring that DemandTools scenarios which should have identical components actually do.

Continue Reading

Intro to XML and JSON #7: Recap & Real World Use

26 Apr 2019 🔖 xml json tutorials csv excel salesforce api python integration architecture 💬 EN

That’s a wrap! Let’s recap the battle of “XML vs. JSON,” discuss how they’re used in the real world, and take a final glance at the big picture.

Continue Reading

Intro to XML and JSON #6: JSON

26 Apr 2019 🔖 xml json tutorials csv excel 💬 EN

We’ve seen JSON from a “30,000-foot view.”

We understand what kind of data JSON can help us with.

Let’s learn how to write JSON!

Continue Reading

Setting up VSCode to edit Salesforce metadata

10 Apr 2019 🔖 salesforce tutorials xml flow vscode 💬 EN

A colleague wanted to edit the XML behind Salesforce flows so she could quickly copy/paste entire flows, copy/paste variables within a flow, etc.

That part is easy, but I needed to walk her through setting up her computer to talk to Salesforce about an org’s configuration “metadata.”

Here’re the instructions I sent her for Windows.

Continue Reading

Logging into Salesforce's Pardot API (w/ Python)

04 Apr 2019 🔖 python pardot salesforce tutorials api 💬 EN

Logging into Pardot’s API is a lot easier than logging into MarketingCloud’s API was.

I used Python, but most of the steps have nothing to do with code.
Any language that can do HTTPS POST requests will do.

Continue Reading

Intro to XML and JSON #5: XML/CSV Conversions

03 Apr 2019 🔖 xml json tutorials csv excel 💬 EN

Now that you can read XML and write it by hand, let’s talk about converting between XML and CSV.

Continue Reading