BuildRowSetFromJSON & HTTPGET Functions in Salesforce Marketing Cloud [Video]

Cameron Robert shows how to use the BuildRowSetFromJSON function to process a JSON response from a HTTPGet function in Salesforce Marketing Cloud.

2 different HTTP endpoints are shows in this video, including the Salesforce Marketing Cloud Token endpoint, allowing you to test and play with this code.

0:00 – Introduction
1:02 – First HTTPGet Setup, icanhazdadjoke.com
1:55 – Testing the HTTPGet function with icanhazdadjoke.com
3:03 – Set Headers in HTTPGet
3:42 – Testing the response
5:11 – Resolving JSONPath arguments
7:43 – Output the values of the HTTPGet JSON Response
8:48 – Setting fields name in BuildRowSetFromJSON
9:40 – Call the Marketing Cloud Token API
11:04 – Handle the response using BuildRowSetFromJSON
15:18 – Updating Gist with new Code Snippet
16:20 – Summary

Code Solutions:
• Get SFMC Token & POST SFMC RestAPI: https://gist.github.com/camrobert/21131135eaa1a1a495ea6c4a07750248

Salesforce Documentation:
• BuildRowSetFromJSON: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/buildrowsetfromjson.html
• HTTPGet: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/httpget.html

Useful Resources:
• https://jsonpath.com/
• https://www.javatpoint.com/json-example
• https://icanhazdadjoke.com/api

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

Music: https://www.bensound.com