How to add Data Table based on a Parameterized Information Link in Spotfire® Using IronPython Scripting

Introduction

This article provides a sample IronPython script on how to add a data table which is based on a Parameterized Information link.

Code Sample

# Copyright © 2019. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

from System import Array,Guid,String,Object, DateTime
from Spotfire.Dxp.Data.Import import InformationLinkDataSource, InformationLinkParameter
from Spotfire.Dxp.Data import *


#The GUID of the information link to be executed (Right-click, Copy ID from the information designer)
ilGuid = "c6e14694-2713-4a5e-9c46-fcb78766cbcd"

ilDataSource=InformationLinkDataSource(Guid(ilGuid))

#define parameter values
param1Value = 'Floyd Rayford'

#list to save information link parameters
ilParameters = []

#create parameter
ilParameter = InformationLinkParameter.CreateNamedParameter("param1", Array[Object]([param1Value]))
ilParameters.append(ilParameter)
# For multiple parameters repeat this and append to the list

#Assign the parameters
ilDataSource.Parameters = ilParameters


Document.Data.Tables.Add("Parameterized-IL",ilDataSource)

References

• API Reference: InformationLinkDataSource
• API Reference: InformationLinkParameter
• API Reference: TableCollection.Add

License:  TIBCO BSD-Style License