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/product... 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...

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

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

Contact:
  / camrobert  
https://www.cameronrobert.com.au/
  / auscamrobert  

Music: https://www.bensound.com