Get JSON Data using SSJS in Salesforce Marketing Cloud 

Cameron Robert from Datarati develops an automation that retrieves Weather Data to show how to get JSON data from an external source and save it into a Data Extension in Salesforce Marketing Cloud.
What you'll learn:
» How to access JSON data from an external source
» What functions to use in Server Side JavaScript to get JSON data into Salesforce Marketing Cloud
» How to make a FOR LOOP in SSJS to iterate over a JSON Object and Upsert Rows into a Data Extension.
» How to create a Script Activity in Automation Studio
Introduction: (0:00)
SSJS Get Request Overview: (0:52)
How to use the HTTP.GET Request: (1:28)
Using SSJS to parse the Response into a JSON Object: (3:11)
Tip - How to navigate a JSON Object in Chrome Developer Tools: (3:52)
How to reference a JSON Object Address: (4:57)
Creating a Simple FOR LOOP in SSJS: (5:48)
Enhancing the FOR LOOP: (6:55)
Upserting JSON Data into a Data Extension: (7:41)
Creating a Script Activity in Automation Studio: (11:40)
Automating a Script Activity: (12:20)
Summary: (13:58)
Example JSON Weather Data Source:
reg.bom.gov.au/products/IDQ609...
Further reading:
• SSJS HTTP.Get: developer.salesforce.com/docs...
• SSJS Write: developer.salesforce.com/docs...
• SSJS ParseJSON: developer.salesforce.com/docs...
• SSJS UpsertDE: developer.salesforce.com/docs...
• Automation Studio - Script Activity: help.salesforce.com/articleVi...
• Chrome DevTools: developers.google.com/web/too...
Want more information?
Contact us: www.datarati.com.au/contact-us/
Email us: hello@datarati.com.au
#salesforce #marketingcloud #tutorial #datarati