Get data from SQL and save in SharePoint list.

Question

Get data from SQL and save in SharePoint list.

As i don't have knowledge of Server side code as i am working in client side coding like java script , rest api, jquery, jsom.

So give me proper code for the same so that i can achieve my task.

Answer 1

Hi ShivSharma-7793,

If you want to connect SQL data with SP list, you can build an external list:

• https://www.c-sharpcorner.com/UploadFile/b8e86c/bcs-using-sql-server-in-sharepoint-2013/
• https://learn.microsoft.com/en-us/sharepoint/administration/configure-a-business-data-connectivity-service-application

And if you want to connect to sql using js, you may check:

• https://www.codeproject.com/Questions/294959/How-to-connect-to-SQL-server-database-from-javascr

Below blog shows how to add item to list:

• https://www.codesharepoint.com/jsom/create-list-item-in-sharepoint-using-jsom

Best Regards,
Baker Kong