how to get sharepoint list data into node.js

Question

I have created bot&nbsp; using below linkhttps://docs.microsoft.com/en-in/microsoftteams/platform/get-started/get-started-nodejs-app-studio&nbsp;I want sharepoint list data into bot ,how do i get sharepoint list data into bot using&nbsp; node.js

abhijit_msft · Answer

tejaswini1010&nbsp;You need to use&nbsp;Sharepoint Api's&nbsp;to access the Sharepoint data in your Nodejs app.
- Call sharepoint authentication api
- Once token is obtained in authentication response, call api to get the sharepoint list
- Create model to handle the response of the previous api
- You need to write the logic to find the answer from the sharepoint list that you received in previous response.
&nbsp;
After getting data from sharepoint in case if your bot is not responding - please cross verify the&nbsp;Bot settings&nbsp;
&nbsp;
&nbsp;

abhijit_msft · Answer

tejaswini1010&nbsp;you can use the SharePoint API's to get the required data into your bot. Check below API documents. Please let me know if you are looking for something else.
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/sharepoint-net-server-csom-jsom-and-rest-api-index

tejaswini1010 · Answer

Abhijit_MSFT&nbsp;hii ,&nbsp;Thanks for reply, i have implemented that code&nbsp; in node .js&nbsp; &nbsp;for bot , i have made&nbsp; changes&nbsp; in bot.js file but still i get no reply from bot, my requirement is that , I have sharepoint list , in which&nbsp; i have saved questions and answer , i have made bot using following linkhttps://docs.microsoft.com/en-in/microsoftteams/platform/get-started/get-started-nodejs-app-studio&nbsp;I want when user ask question , if it matches with sharepoint column of list that answer&nbsp; should displays in bot,&nbsp;&nbsp;

tejaswini1010 · Answer

Please provide me steps how to do that ,
I have sharepoint list with question and answer column ,
I have made bot as mention earlier
I did not get replay which is saved in sharepoint list if question asked in bot matches with question which present in sharepoint list, if it matches thats answer should get displays in bot,
Please provide me steps as soon as possible.

Thanks,

abhijit_msft · Answer

tejaswini1010&nbsp;For the scenario that you mentioned, looks like the QnA bot is the best suit. try this&nbsp;QnA&nbsp;bot sample code.

Forum Discussion

how to get sharepoint list data into node.js

Share

Resources