Advertisement
Guest User

Untitled

a guest
Jan 15th, 2019
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <script type="javascript" runat="server">
  2.  
  3. Platform.Load("Core","1.1.5");
  4. var TestDE = DataExtension.Init("PushAddressQueryLogs");
  5.  
  6. var midJson = [
  7.   {
  8.     "BusinessUnitId": 7z8x49y,
  9.     "QueryObjectId": "c91f0XXX-501e-YYYY-9469-ZZZZdff510e7"
  10.   },
  11.   {
  12.     "BusinessUnitId": z09v67t8,
  13.     "QueryObjectId": "c0ba1QQQQ-f3e6-4YYYY-8e2f-9bEEE3b06255"
  14.   }
  15. ];
  16.  
  17. for (var i=0; i < midJson.length; i++) {
  18.  
  19. var mid = midJson[i].BusinessUnitId;
  20. var objectid = midJson[i].QueryObjectId;
  21. var taskid = '';
  22. try {
  23.  
  24.      var api = new Script.Util.WSProxy();
  25.  
  26.      api.setClientId({ "ID": mid }); //Impersonates the BU
  27.      var action = "Start";
  28.      var props = {
  29.              ObjectID: objectid
  30.      };
  31.      var opts = {};
  32.  
  33.      var data = api.performItem("QueryDefinition", props, action, opts);
  34.      TestDE.Rows.Add({"log":i+ " : task id : "+data.Results[0]).Task.ID});
  35.      taskid = data.Results[0]).Task.ID
  36. } catch(e) {
  37.      Platform.Response.Write('error: ' + Platform.Function.Stringify(e));
  38. }
  39.  
  40. do {
  41.  
  42.      var prox = new Script.Util.WSProxy();
  43.  
  44.      prox.setClientId({ "ID": mid }); //Impersonates the BU
  45.  
  46.      var cols = ["Status"];
  47.      var filter = {
  48.          Property: "TaskID",
  49.          SimpleOperator: "equals",
  50.          Value: taskid
  51.      };
  52.  
  53.      var desc = prox.retrieve("AsyncActivityStatus", cols, filter);
  54.    
  55.      var queryStatus = desc.Results[0].Status;
  56.      var result = TestDE.Rows.Add({"log":i+ " : query status : "+ desc.Results[0].Status});
  57.  
  58.  
  59.   } while(queryStatus != 'Complete')
  60.  
  61. }
  62. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement