Making a Query in Salesforce Using SSJS

When working with Salesforce Marketing Cloud, you may need to send data to an external service or fetch content dynamically based on request parameters. Server-Side JavaScript (SSJS) gives you the flexibility to perform HTTP requests, handle responses, and manipulate JSON data directly within your cloud pages or emails. In the example below, we use Platform.Load to initialize the core library, retrieve a parameter from the request, and build a payload for a POST request. The script sends data to an external endpoint and checks the response status before proceeding. If the request is successful, it stores the result and parses it as JSON for further use, such as retrieving a specific value like totalCount. This technique is particularly useful when integrating external APIs or dynamic content into your campaigns.

Code

%%[

SET @infoblockId = RequestParameter("offerId")

]%%

<script runat="server">
    Platform.Load("Core", "1")
    var infoblockId = Variable.GetValue("@infoblockId");
    var payload = {infoblockId: infoblockId};

    //create request
    var req = new Script.Util.HttpRequest('https//site.example/?param=some');
    req.emptyContentHandling = 0;
    req.retries = 2;
    req.continueOnError = true;
    req.contentType = 'application/json';
    req.method = "POST";
    req.postData = Stringify(payload);

    var res = req.send();

    var respStatusCode = res.statusCode;

    //if error
    if (respStatusCode != 200) {
        Variable.SetValue("@getRequest",{});
        return;
    }

    //if success
    Variable.SetValue("@getRequest",res.content);

    //convert to JSON for special manipulation
    var resultJSON = Platform.Function.ParseJSON(String(res.content));
    var count = resultJSON.totalCount;
    Variable.SetValue("@getcount",count);

</script>

Using SSJS in this way helps streamline data-driven personalization and real-time interactions in Marketing Cloud workflows.