SSJS Update and Perform Query Definition

Question

I am attempting to loop through data extension content to dynamically update and perform a query definition. Essentially, I'd like to update and run the same Query Definition synchronously using SSJS but the following code is not working. Is this even possible using the QD functions?

<script language="javascript" runat="server">

    function queryUpdatePerform(qd, Query, UpdateType) {
        qd = QueryDefinition.Init(qd);
        var update_status = qd.Update({
        QueryText: Query, TargetUpdateType: UpdateType
        });
        var perform_status = qd.Perform();
        var status = "{Update:".concat(update_status).concat(", ").concat("Perform:").concat(perform_status).concat("}"); 
        return status;
    }

    var QD_ExternalKey = "qd-externalkey";
    var DE_ContentDetails_ExternalKey = "de-externalkey";
    var contentDetailsDE = DataExtension.Init(DE_ContentDetails_ExternalKey);
    var contentDetails = contentDetailsDE.Rows.Retrieve();

    for (var i = 0; i < contentDetails.length; i++ ) {
        var QueryLogic = contentDetails[i].QueryLogic;
        var Query = "SELECT * FROM [SourceDE] WHERE EmailAddress IS NOT NULL AND ".concat(QueryLogic);

        var status = "";
        var ut = "";
        if (i === 0) {
            ut = "Overwrite";
            status = queryUpdatePerform(QD_ExternalKey, Query, ut); 
        } else {
            ut = "Update";
            status = queryUpdatePerform(QD_ExternalKey, Query, ut);
        }
    }
</script>

Answer 1

Your code is working perfectly and only have to added SSJS library in top of the code and need to change 'l' variable to 'i'.

<script language="javascript" runat="server">
    Platform.Load("core", "1");
    function queryUpdatePerform(qd, Query, UpdateType) {
        qd = QueryDefinition.Init(qd);
        var update_status = qd.Update({
        QueryText: Query, TargetUpdateType: UpdateType
        });
        var perform_status = qd.Perform();
        var status = "{Update:".concat(update_status).concat(", ").concat("Perform:").concat(perform_status).concat("}"); 
        return status;
    }

    var QD_ExternalKey = "qd-externalkey";
    var DE_ContentDetails_ExternalKey = "de-externalkey";
    var contentDetailsDE = DataExtension.Init(DE_ContentDetails_ExternalKey);
    var contentDetails = contentDetailsDE.Rows.Retrieve();

    for (var i = 0; i < contentDetails.length; i++ ) {
        var QueryLogic = contentDetails[i].QueryLogic;
        var Query = "SELECT * FROM [SourceDE] WHERE EmailAddress IS NOT NULL AND ".concat(QueryLogic);

        var status = "";
        var ut = "";
        if (i === 0) {
            ut = "Overwrite";
            status = queryUpdatePerform(QD_ExternalKey, Query, ut); 
        } else {
            ut = "Update";
            status = queryUpdatePerform(QD_ExternalKey, Query, ut);
        }
    }
</script> 

Answer 2

Using browser inspector when running Query Activities I've seen the following URL:

https://mc.sXX.marketingcloudapps.com/AutomationStudioFuel3/fuelapi/automation/v1/queries/12341234-1234-1234-1234-123412341234/actions/isrunning/?_=1731604738239

• 12341234...1234 is the query object ID
• Last param is a full timestamp

response goes like this:

{"queryDefinitionId":"12341234-1234-1234-1234-123412341234","isRunning":true}