Skip to main content
Nintex Community Menu Bar
Solved

Is it possible to connect NWC Data Lookup control to SQL Server

A
Forum|alt.badge.img+5

Hi,

In my projects I need to auto-populate my Start Event form with data.  The only two ways that I know so far it is possible is: first by using getQueryStringParameter function, and second by using a Data Lookup control.  With the second method I can load my drop down list from a SharePoint, and also filter the response with a local variable.  I was hoping that there was a way of doing similarly from SQL Server.

Is it possible to achieve?

Regards.

Best answer by Jake

Hi @artmov 


 


If your SQL server is API enabled such as Azure SQL, you can create a Nintex Xtension for your service, using this then you will be able to add that service as a data source.


 


https://help.nintex.com/en-US/xtensions/Home.htm


 


Hope this helps


Jake

View original
Translate
    Did this topic help you find an answer to your question?

    3 replies

    Jake
    Forum|alt.badge.img+13
    • Jake
    • Scholar
    • 319 replies
    • Answer
    • June 7, 2021

    Hi @artmov 


     


    If your SQL server is API enabled such as Azure SQL, you can create a Nintex Xtension for your service, using this then you will be able to add that service as a data source.


     


    https://help.nintex.com/en-US/xtensions/Home.htm


     


    Hope this helps


    Jake

    Translate
    Jake
    A
    1 person likes this
    • A
      artmov
    A
    Forum|alt.badge.img+5
    • artmov
    • Author
    • Rookie
    • 28 replies
    • June 7, 2021
    Hi @Jake,

    Xtention is a good tip. Thank you. I experimented with Xtentions in connection with Data Lookup control. It works, but the problem is that you cannot filter the results. When you a SharePoint Data Source in Data Lookup control, then the Editor gives you an option to set a filter dynamically, which makes the results set customizable for any specific case on the form. On the other hand, when I use Xtention Data Source, then there is no filter and there is no way to set an input parameter. Thus the Data Lookup is always populated with the same data, which makes it static and not very useful.
    Do you have any suggestions in that regard?
    Thank you.
    Translate
    A
    Forum|alt.badge.img+5
    • artmov
    • Author
    • Rookie
    • 28 replies
    • June 7, 2021
    Hi @Jake,

    I need to tell you that my previous comment is probably outdated. Since you gave me this direction, I went to my old solutions, which stopped working 🙂, and tried to rebuild them. It turns out that now I can pass a parameter to an Extension connecting to API and pass parameters. My form drop-down is updated dynamically. Pretty nice.
    Now, I will need to create an API connecting to SQL.

    Thank you again for a nice tip.
    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings