0 Replies Latest reply on Apr 13, 2016 7:08 PM by Vinh Nguyen

    Passing parameter to Stored Procedure using Tableau Server API

    Vinh Nguyen

      With Tableau Desktop, I can pass a parameter to stored procedure. How could I do the same thing with Tableau Server API. When looking into workbook file. I saw the "actual parameter" was configured in tableau workbook as below. How could I change this parameter using Tableau Server API.

       

      <connection authentication='sqlserver' class='sqlserver' dbname='Test' odbc-native-protocol='yes' server='10.16.48.95' username='devadmin'>

              <relation name='SP_Account_Get' stored-proc='[dbo].[SP_Account_Get]' type='stored-proc'>

                <actual-parameters>

                  <column name='@AccountId' ordinal='1' value='1' />

                </actual-parameters>

              </relation>

              <metadata-records>

       

      How could I change @AccountId ?