In this article we will learn how to execute SQL in SharePoint 2013 and Office 365 using Nintex WorkFlows
Welcome to an article on how to execute SQL in SharePoint 2013 and Office 365 using Nintex Workflows. This article will display the action “Execute SQL” so that all my developer friends don’t have to spend much time and effort while using this function in their projects. Let’s see the implementation of this functionality.
Figure 1: Workflow
Figure 2: New Workflow
Figure 3: ToolBox
Figure 4: Screen Figure 5: Screen2 Connection String: Here specify the SQL connection string to connect to a remote SQL database. Query: Specify the SQL Query for 200 records as a result. Column to retrieve: Specify a column name which you want to retrieve from SQL 'SELECT' query result. Results count: Specify a variable (Number type) to store the total number of results executed from the query Retrieved column values: Use a collection or dictionary type variable to store the values of the columns to retrieve from the query. Results in XML: Use a collection or dictionary type variable to store the query results in XML format.
Figure 6: Save You will see the following screen: Figure 7: Publish
This action will help us to get values directly from a SQL DB through our query which we can use for various purposes as in updating a value or getting a value and other functions. Hence it will be very important for us sometimes to have this function through Nintex rather than writing code to get values from SQL. So in this article we saw how to execute SQL in SharePoint 2013 and Office 365 using Nintex Workflows, we will see more new articles on the actions of Nintex Workflows in the other parts of the article. Till then, keep learning.
Getting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JSGetting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JSGetting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JSGetting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JSGetting Started with SharePoint Framework Development using TypeScript, PnP JS, and React JSGetting Started with SharePoint Framewor