How can I add data to Dataextension for SSJS

Question

I am trying to add data to Data Extension using SSJS Script through Automation Studio.

1.I want to HTTP GET(ThirdParty's recomend) 2.I want to catch response(JSON) and add data to Dataextension

How can I do?

<script runat="server">
Platform.Load("Core","1");
var url = 'https://api.zipaddress.net/?zipcode=';
var response = HTTP.Get(url);
</script>

Answer 1

Here's a working example of an HTTP.Get call, parsing the response and writing it to a Data Extension. You can modify it for your needs and add exception handling.

Data Extension name: "Log"

JSON attribute logged: "explanation"

Script:

<script runat="server">
  Platform.Load("Core","1.1.1");
  try{

var apikey = ""; //pass apikey
var url = "https://api.nasa.gov/planetary/apod?api_key=";
var response = HTTP.Get(url +apikey);
var content = Platform.Function.ParseJSON(response.Content);
var log = DataExtension.Init("Log");
log.Rows.Add({explanation:content.explanation});

      }catch(e){
    Write(Stringify(e));
  }
</script>