BuildRowSetFromJSON & HTTPGET Functions in Salesforce Marketing Cloud
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/211...
Salesforce Documentation:
• BuildRowSetFromJSON: https://developer.salesforce.com/docs...
• HTTPGet: https://developer.salesforce.com/docs...
Useful Resources:
• https://jsonpath.com/
• https://www.javatpoint.com/json-example
• https://icanhazdadjoke.com/api
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com