Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. function MyTest(CID) {
  2. CID = CID || "327387498";
  3.  
  4. ScriptyApp.setHeader({ customerId: Number(CID) });
  5.  
  6. try{
  7. var rows = ScriptyApp.get("SELECT FeedId FROM CampaignFeedService");
  8. while (rows.hasNext())
  9. {
  10. var row = rows.next();
  11. // Logger.log(Object.keys(row));
  12. Logger.log("Feed ID: "+row.feedId.id+", Feed Name: "+ GetFeedName(CID, row.feedId.id) +", From Campaign: "+ row.campaignId.id);
  13. }
  14. }
  15. catch(e){ Logger.log("err: " + e); }
  16. }
  17.  
  18. function GetFeedName(CID, feedId) {
  19. ScriptyApp.setHeader({ customerId: Number(CID) });
  20.  
  21. var rows = ScriptyApp.get("SELECT Id,Name,CampaignId FROM FeedService");
  22.  
  23. while( rows.hasNext() ) {
  24. var row = rows.next();
  25. return row.name;
  26. }
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement