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

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?

ASSJS platform function ParseJSON

BTransformJSON() AMPscript Function

CBuildRowSetFromJSON() AMPscript Function

DParseJSON content block with Content Builder

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.'

---

Get Premium MCE-Con-201 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

17 comments · newest first

Denae 1 month ago

Content blocks are great for design too.

Jonelle 1 month ago

True, but I like the flexibility of TransformJSON.

Jesus 1 month ago

But AMPscript is simpler for most users.

Sina 2 months ago

SSJS can handle complex JSON easily.

Denae 2 months ago

I’m leaning towards D. Content Builder is user-friendly.

Jonelle 2 months ago

Option B seems useful for transforming data.

Jesus 2 months ago

I prefer option C. BuildRowSetFromJSON is straightforward.

Sina 2 months ago

I think option A is the best choice. SSJS is powerful.

Linwood 2 months ago

Totally agree with Felton, C is the way to go!

Penney 3 months ago

Wait, are we really using JSON in emails now? That's surprising!

Dorinda 3 months ago

Not sure why anyone would pick D) ParseJSON content block. Seems less efficient.

Devora 3 months ago

A) SSJS platform function ParseJSON seems like a solid choice too!

Felton 3 months ago

I think they should go with C) BuildRowSetFromJSON() AMPscript Function.

Jill 3 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.

Jesusita 4 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.

Abel 4 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.

Nieves 4 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.

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