Exposed Data on the community

[jacebenson]

What is the post about? Exposed Data on the community

What things would help with writing the post

var companies = {};
var endpoint = document.location.origin + "/api/now/table/sn_communities_profile?";
// endpoint += "sysparm_query=nameLIKE@^state=MN&";
// endpoint += "sysparm_fields=name,company&";
// endpoint += "sysparm_limit=100"
var client=new XMLHttpRequest();
client.open("get", endpoint);
client.setRequestHeader('Accept','application/json');
client.setRequestHeader('Content-Type','application/json');
client.setRequestHeader('X-UserToken', g_ck);
client.onreadystatechange = function() {
    if(this.readyState == this.DONE) {
        var responseObj = JSON.parse(this.response);
        responseObj.result.map(function(user){
          if(companies[user.company]){
            companies[user.company].push(user);
          } else {
            companies[user.company] = [user];
          }
        });
        console.log(companies);
    }
};
client.send("");

[jacebenson]

Getting all the unanswered questions in console;

var questions = {};
var endpoint = document.location.origin + "/api/now/table/kb_social_qa_question?";
endpoint += "sysparm_query=answer_count=0^ORDERBYDESCsys_created_on";
//endpoint += "&sysparm_limit=100"
var client=new XMLHttpRequest();
client.open("get", endpoint);
client.setRequestHeader('Accept','application/json');
client.setRequestHeader('Content-Type','application/json');
client.setRequestHeader('X-UserToken', g_ck);
client.onreadystatechange = function() {
    if(this.readyState == this.DONE) {
        var responseObj = JSON.parse(this.response);
        responseObj.result.map(function(question){
          var date = question.sys_created_on.split(' ')[0];
          if(question.question !=""){
          if(questions[date]){
            questions[date].push({
                 "question":question.question,
                 "link": document.location.origin + "?id=community_question&sys_id=" + question.sys_id
            });
          } else {
            questions[date] = [{
                 "question":question.question,
                 "link": document.location.origin + "?id=community_question&sys_id=" + question.sys_id
            }];
          }
          }
        });
console.log(questions);
    }
};
client.send("");