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

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

---


Contribute your Thoughts:

0/2000 characters
Felton
4 days ago
I think they should go with C) BuildRowSetFromJSON() AMPscript Function.
upvoted 0 times
...
Jill
9 days 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
14 days 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
19 days 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
24 days 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