AMPscript BuildRowSetFromJSON Function in Salesforce Marketing Cloud

Cameron Robert introduces the new AMPscript BuildRowSetFromJSON function in Salesforce Marketing Cloud, demonstrating how it can be used to read JSON data for personalisation, and showcasing ways to practice using BuildRowSetFromJSON.

Note: BuildRowSetFromJSON is part of the Summer '23 Release being rolled out between June 3, 2023 - June 23, 2023. Check your account's rollout status by visiting https://status.salesforce.com/products/Marketing_Cloud and clicking the "Maintenances" tab.
0:00 - Introduction
0:18 - BuildRowSetFromJSON AMPscript Documentation
2:09 - Rapid Development CloudPage & Content Block
4:01 - Testing the BuildRowSetFromJSON Sample Usage code
14:58 - Test BuildRowSetFromJSON with a simple JSON Sample
16:27 - Resolving JSONPath arguments
18:48 - Test BuildRowSetFromJSON with a complex JSON Sample
21:32 - Summary
Salesforce Documentation:
• BuildRowSetFromJSON: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/buildrowsetfromjson.html

Code Solutions:
• Documentation Sample Solution: https://gist.github.com/camrobert/3f02f01ca48296855fe5523b343d9683
• Complex JSON Solution: https://gist.github.com/camrobert/d73c07d5f5f0af6bd4d2f845b4297fb1

Useful Resources:
• https://jsonpath.com/
• https://www.javatpoint.com/json-example
• https://www.ietf.org/archive/id/draft-goessner-dispatch-jsonpath-00.html

Contact:
https://www.linkedin.com/in/camrobert/
https://www.cameronrobert.com.au/
https://twitter.com/AusCamRobert

Music: https://www.bensound.com

Видео AMPscript BuildRowSetFromJSON Function in Salesforce Marketing Cloud канала Cameron Robert