导出视图为CSV文件,不受10分钟限制
介绍
也许您正面临CSV文件请求频率限制的问题。
为了解决这个问题,我们使用小javascript (bookmarklet),它通过Zendesk API接收数据并将其保存到CSV文件中。亚博
参观循环应用程序站点获取脚本并为自己设置。它是开源和免费的。享受吧!
它是如何工作的
这个视频展示了它是如何工作的。
这是源代码
以下是脚本代码。请随意修改它,以满足您自己的需要!
Javascript:var win=window.open("",","width=600,height=500,scrollbars=yes");var vn=+window.location.href.replace(/(.*filters/)/,"");var w = win.document;w.write("由RoundRobinApp团队创建 (@RoundRobinApp)
";w.write("");var url="/api/v2/views/"+vn+"/execute.json";var l=1;f(url);function ai(a, s, p){for(var i = 0, len = a.length; i < len; i++){if (a[i][p] === s) return i;} return -1;}; function gv(o, r, a){var v=o.rows[r][a]; if (typeof v == "undefined") {v=o.rows[r][a+"_id"];}; if (v !== null) {if(a=="assignee" || a=="requester"){return o.users[ai(o.users, v, "id")].name}; if (a=="group") {return o.groups[ai(o.groups, v, "id")].name};if (a=="organization"){return o.organizations[ai(o.organizations, v, "id")].name};if (a=="via"){return v.channel}; return v;} else {return ""};};function f(u){var xh=new XMLHttpRequest();xh.onreadystatechange=function() {var obj; if(xh.readyState==4&&xh.status==200){obj=JSON.parse(xh.responseText); w.write(""); var q=String.fromCharCode(34); var q1 =String.fromCharCode(39); var s="id,Description"; if (l == 1) {for (var j = 0; j < obj.columns.length; j++) { s += ","+q+obj.columns[j].title+q; }; l=0; w.write(s+String.fromCharCode(13,10)+"
"); }; for (var i = 0; i < obj.rows.length; i++) {var s=obj.rows[i].ticket.id+","+q+obj.rows[i].ticket.description.replace(/[\r\n]/g," ").replace(/"/g, q1).replace(/\s+/g, " ")+q; for (var j = 0; j < obj.columns.length; j++) {s += ","+q+gv(obj,i,obj.columns[j].id).toString().replace(/[\r\n]/g," ").replace(/"/g, q1).replace(/\s+/g, " ")+q; }; w.write(s+String.fromCharCode(13,10)+"
"); }; if(obj.next_page!==null){f(obj.next_page)}else{w.write("")}; }; };xh.open("GET",u,true);xh.send();};
-
甜蜜的提示,Serge -谢谢你的帖子!
请登录留下评论。
1评论