Salesforce Exam Marketing Cloud Consultant Topic 6 Question 102 Discussion

Actual exam question for Salesforce's Marketing Cloud Consultant exam

Question #: 102
Topic #: 6

[All Marketing Cloud Consultant 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?

ASSJS platform function ParseJSON

BTransformJSON() AMPscript Function

CBuildRowSetFromJSON() AMPscript Function

DParseJSON content block with Content Builder

Show Suggested 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 Marketing Cloud Consultant Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Pearly

2 months 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

2 months 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 months ago

C) BuildRowSetFromJSON() AMPscript Function

upvoted 0 times

...

Isidra

2 months ago

B) TransformJSON() AMPscript Function

upvoted 0 times

...

Sueann

2 months ago

A) SSJS platform function ParseJSON

upvoted 0 times

...

Joesph

2 months 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

3 months 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

3 months ago

I agree with Toshia. TransformJSON() would be the best option for formatting the JSON within the email.

upvoted 0 times

...

Cherrie

3 months 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

3 months 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