Microsoft Bot Framework - node Js integration with Salesforce

Question

Hi Im trying to connect Salesforce with microsoft bot framework for creating a skype Bot. I use Express node js and node-salesforce for connecting Salesforce.

I have written Salesforce functions in separate file(Salesforce js) and Bot Functions in a separate file(myBot js) which is the server file. The query function in Salesforce js getting called successfully but its not returning the result back to the calling function.Here is the code, please someone help

Mybot Js function

var intents = new builder.IntentDialog();
intents.matches(/^QueryAcc/i, [
   function (session) {
      Salesforce.QueryAcc();
   },
   function (session, results) {
      console.log('the response--'+results.response);
   }
]);

Salesforce Js Function

function QueryAcc(){
var records = [];
conn.query("SELECT Id, Name FROM Account limit 1", function(err, result) {
  if (err) { 
    return console.error(err); 
  }else{
    console.log("fetched : " + result.records);
   for (var i=0; i<result.records.length; i++) {
     var record = result.records[i];
   }
   console.log("First Name: " + result.records[0].Name);
   return record;
  }
});
}

austin · Accepted Answer · 2017-05-04 09:34:19Z

1

function QueryAcc(callback){

    conn.query("SELECT Id, Name FROM Account limit 1", function(err, result) {
        if (err) {
            console.error(err);
        }
        else{
            var records = [];
            console.log("fetched : " + result.records);
            for (var i=0; i<result.records.length; i++) {
                var record = result.records[i];
                records.push(record);
            }
            console.log("First Name: " + result.records[0].Name);
            callback(records);
        }
    });
}


var intents = new builder.IntentDialog();
intents.matches(/^QueryAcc/i, [
    function (session) {
        Salesforce.QueryAcc(function(results){
            console.log('the response--'+results.response);
        });
    }
]);

answered May 4, 2017 at 9:34

austin

1,1711 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Microsoft Bot Framework - node Js integration with Salesforce

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related