Update SQL with value from SharePoint

[djl304]

I'm attempting to integrate a SharePoint list with Alteryx to generate reports.  The goal is for our end users to be able to "schedule" reports via SharePoint.  I have a few standard fields in SharePoint, and these fields will be used as variables for the SQL that is running in Alteryx.  I'm struggling with how to use the input from Alteryx to update the where clause.  Here is an example:

Query

Select *

From Table1

Where ClientID = '12345'

The SharePoint list might have 10 different records with different Client IDs.  I don't have a problem getting the program to loop through everything, but I'm not sure where to start with regards to updating the Where clause with the different Client IDs.

[danilang]

Hi @djl304 

Use a Dynamic Input for your SQL input and configure it to "Update Where Clause" replacing the 12345 with the value from the Client ID field.

Dan 

[djl304 · Accepted solution]

Dan,

Thanks for the follow up.  I figured out the Dynamic Input tool this morning - yesterday I was a little confused regarding the input that goes into the Dynamic Input.  

For anyone else who might run into a similar issue, the Dynamic Input tool input is the value that your Where clause will be updating to.  In this case, the template for the Dynamic Input is the actual SQL that you are starting with, and the Input is the where the updated value for the Where clause is coming from.

[danilang · Accepted solution]

Hi @djl304 

Glad you found it. 

Since you found the answer, you can mark your follow up as an accepted solution.  The Community search engine prioritizes solved posts so marking your answer as solved will make it easier for others to find

Dan.

[danilang]

Hi @djl304 

I meant for you to mark your answer as the solution, not mine.   As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members which I've done for your solution, giving you your first solution badge.  Feel free to un-accept my answer if you desire.

 
Dan