New Year Sale 2026! 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 Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Exam - Topic 6 Question 102 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) exam
Question #: 102
Topic #: 6
[All Salesforce Certified Marketing Cloud Engagement Consultant (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: D

To format the JSON payload from their commerce platform within the email, Northern Trail Outfitters should use the BuildRowSetFromJSON() AMPscript function. The BuildRowSetFromJSON() AMPscript function is a function that allows marketers to parse a JSON string and return a rowset object that can be used to display data within an email message. The BuildRowSetFromJSON() AMPscript function can handle nested JSON objects and arrays. Reference: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/buildrowsetfromjson.htm


by Shakira at Jan 09, 2025, 02:31 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Annette
3 months ago
Wait, can you really use ParseJSON in a content block? That’s new to me!
upvoted 0 times
...
Jutta
3 months ago
A is a good choice too, SSJS can handle JSON well.
upvoted 0 times
...
Lavelle
3 months ago
I’m not sure about D, using a content block seems a bit overkill.
upvoted 0 times
...
Natalie
4 months ago
Definitely option C, BuildRowSetFromJSON() is the way to go!
upvoted 0 times
...
Myra
4 months ago
I think they should go with option B, TransformJSON() is solid for this.
upvoted 0 times
...
Clay
4 months ago
I vaguely remember something about using a content block for JSON, maybe the ParseJSON content block? That sounds familiar.
upvoted 0 times
...
Cherrie
4 months ago
I feel like the ParseJSON function could be relevant here, but I need to double-check if it’s meant for email content.
upvoted 0 times
...
Garry
4 months ago
I remember practicing with the TransformJSON function, but I can't recall if it was specifically for formatting or just for transforming data.
upvoted 0 times
...
Wenona
5 months ago
I think we might need to use the BuildRowSetFromJSON function, but I'm not entirely sure if that's the best choice for formatting the JSON in the email.
upvoted 0 times
...
Francis
5 months ago
I've got this! The SSJS ParseJSON function is the obvious choice here. It's designed specifically for parsing JSON data, which is exactly what the question is asking about.
upvoted 0 times
...
Renay
5 months ago
Okay, let's see. The question is asking about formatting JSON within an email, so I'm thinking the Content Builder option might be the way to go. I'll double-check the other choices, but that's my initial instinct.
upvoted 0 times
...
Domonique
5 months ago
Hmm, I'm a bit unsure about this one. I know we've covered JSON parsing in class, but I want to make sure I understand the specifics of the platform functions before selecting an answer.
upvoted 0 times
...
Amie
5 months ago
This looks like a straightforward JSON parsing question. I'll review the options and think through the best approach.
upvoted 0 times
...
Pearly
1 year ago
Option C? BuildRowSetFromJSON()? Sounds like something straight out of a Harry Potter spell book. I'll pass on that one, thanks.
upvoted 0 times
...
Marguerita
1 year ago
I'm not sure why anyone would want to use SSJS when AMPscript is right there. Option A seems like overkill. Let's stick with the platform-native solution.
upvoted 0 times
Marylou
1 year ago
C) BuildRowSetFromJSON() AMPscript Function
upvoted 0 times
...
Isidra
1 year ago
B) TransformJSON() AMPscript Function
upvoted 0 times
...
Sueann
1 year ago
A) SSJS platform function ParseJSON
upvoted 0 times
...
...
Joesph
1 year ago
You know, I bet there's a way to get the JSON payload to do the hokey pokey if you really wanted to. But for this question, I think I'll just go with the boring ol' TransformJSON() option.
upvoted 0 times
...
Edgar
1 year ago
I'm not sure, but I think D) ParseJSON content block with Content Builder could also work well for this scenario.
upvoted 0 times
...
Dwight
1 year ago
I agree with Toshia. TransformJSON() would be the best option for formatting the JSON within the email.
upvoted 0 times
...
Cherrie
1 year ago
Wait, we can use Content Builder to parse JSON? That's news to me. I'm going to have to look into that option D. Sounds like it could be a real time-saver.
upvoted 0 times
...
Mireya
1 year ago
I think option B is the way to go. TransformJSON() is specifically designed for this kind of task, and it's part of the AMPscript toolkit that Northern Trail Outfitters is already using.
upvoted 0 times
Iluminada
1 year ago
I think option A SSJS platform function ParseJSON could also be a viable choice for formatting JSON in the email.
upvoted 0 times
...
Augustine
1 year ago
I'm not sure, but I think option D ParseJSON content block with Content Builder might be a good option too.
upvoted 0 times
...
Paris
1 year ago
I think option C BuildRowSetFromJSON() AMPscript Function could also work well for this task.
upvoted 0 times
...
Deandrea
1 year ago
I agree, option B TransformJSON() AMPscript Function is the best choice for formatting JSON in the email.
upvoted 0 times
...
...
Toshia
1 year ago
I think they should use B) TransformJSON() AMPscript Function.
upvoted 0 times
...

Save Cancel