Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce MCE-Con-201 Exam - Topic 1 Question 3 Discussion

Northern Trail Outfitters is using a Triggered Send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details.What should they use to format the JSON within the email?
C) BuildRowSetFromJSON() AMPscript Function
A) SSJS platform function ParseJSON
B) TransformJSON() AMPscript Function
D) ParseJSON content block with Content Builder

Salesforce MCE-Con-201 Exam - Topic 1 Question 3 Discussion

Actual exam question for Salesforce's MCE-Con-201 exam
Question #: 3
Topic #: 1
[All MCE-Con-201 Questions]

Northern Trail Outfitters is using a Triggered Send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details.

What should they use to format the JSON within the email?

Show Suggested Answer Hide Answer
Suggested Answer: C

BuildRowSetFromJSON() is an AMPscript function specifically designed to parse JSON payloads into usable row sets inside emails. This allows marketers to iterate through JSON objects easily and display order details dynamically in triggered transactional emails.

---

Exact Extracts from Salesforce Documentation:

Source: Salesforce Help -- AMPscript BuildRowSetFromJSON() Function

'BuildRowSetFromJSON parses a JSON string and creates a rowset suitable for use in AMPscript loops.'

Source: Salesforce Help -- Formatting JSON in Emails

'Use BuildRowSetFromJSON to extract and format dynamic data from JSON payloads in triggered transactional sends.'

---


by Dottie at Jun 01, 2026, 05:06 PM

Limited Time Offer

25%

Off

Get Premium MCE-Con-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Sina
3 days ago
SSJS can handle complex JSON easily.
upvoted 0 times
...
Denae
8 days ago
I’m leaning towards D. Content Builder is user-friendly.
upvoted 0 times
...
Jonelle
13 days ago
Option B seems useful for transforming data.
upvoted 0 times
...
Jesus
18 days ago
I prefer option C. BuildRowSetFromJSON is straightforward.
upvoted 0 times
...
Sina
23 days ago
I think option A is the best choice. SSJS is powerful.
upvoted 0 times
...
Linwood
29 days ago
Totally agree with Felton, C is the way to go!
upvoted 0 times
...
Penney
1 month ago
Wait, are we really using JSON in emails now? That's surprising!
upvoted 0 times
...
Dorinda
1 month ago
Not sure why anyone would pick D) ParseJSON content block. Seems less efficient.
upvoted 0 times
...
Devora
1 month ago
A) SSJS platform function ParseJSON seems like a solid choice too!
upvoted 0 times
...
Felton
2 months ago
I think they should go with C) BuildRowSetFromJSON() AMPscript Function.
upvoted 0 times
...
Jill
2 months ago
I’m leaning towards the ParseJSON content block, but I can't recall if it’s specifically for email formatting or just for parsing data.
upvoted 0 times
...
Jesusita
2 months ago
I practiced a question similar to this, and I feel like BuildRowSetFromJSON() was mentioned as a way to work with JSON data in emails.
upvoted 0 times
...
Abel
2 months ago
I think TransformJSON() might be the right choice since it sounds like it deals with formatting, but I could be mixing it up with another function.
upvoted 0 times
...
Nieves
2 months ago
I remember that AMPscript functions are often used for manipulating data in emails, but I'm not sure which one is best for JSON.
upvoted 0 times
...

Save Cancel