Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script type="javascript" runat="server">
- Platform.Load("Core","1.1.5");
- var TestDE = DataExtension.Init("PushAddressQueryLogs");
- var midJson = [
- {
- "BusinessUnitId": 7z8x49y,
- "QueryObjectId": "c91f0XXX-501e-YYYY-9469-ZZZZdff510e7"
- },
- {
- "BusinessUnitId": z09v67t8,
- "QueryObjectId": "c0ba1QQQQ-f3e6-4YYYY-8e2f-9bEEE3b06255"
- }
- ];
- for (var i=0; i < midJson.length; i++) {
- var mid = midJson[i].BusinessUnitId;
- var objectid = midJson[i].QueryObjectId;
- var taskid = '';
- try {
- var api = new Script.Util.WSProxy();
- api.setClientId({ "ID": mid }); //Impersonates the BU
- var action = "Start";
- var props = {
- ObjectID: objectid
- };
- var opts = {};
- var data = api.performItem("QueryDefinition", props, action, opts);
- TestDE.Rows.Add({"log":i+ " : task id : "+data.Results[0]).Task.ID});
- taskid = data.Results[0]).Task.ID
- } catch(e) {
- Platform.Response.Write('error: ' + Platform.Function.Stringify(e));
- }
- do {
- var prox = new Script.Util.WSProxy();
- prox.setClientId({ "ID": mid }); //Impersonates the BU
- var cols = ["Status"];
- var filter = {
- Property: "TaskID",
- SimpleOperator: "equals",
- Value: taskid
- };
- var desc = prox.retrieve("AsyncActivityStatus", cols, filter);
- var queryStatus = desc.Results[0].Status;
- var result = TestDE.Rows.Add({"log":i+ " : query status : "+ desc.Results[0].Status});
- } while(queryStatus != 'Complete')
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement