PowerShell™ for SharePoint® 2013 How-To

Get a Specific Trusted Data Connection Library

Scenario/Problem: You need to obtain a specific trusted data connection library reference.

Solution: Use the Get-SPExcelDataConnectionLibrary cmdlet to assign a variable the results using the -Identity and -ExcelServiceApplication parameters.

Providing the identity of the trusted data connection library to the Get-SPExcelDataConnectionLibrary cmdlet retrieves a specific data connection library instance. Use this to assign the results to a variable for use in other cmdlets, as shown in Listing 21.7.

Listing 21.7. Assigning a Variable to a Specific Data Connection Library

$trustedLibrary = Get-SPExcelDataConnectionLibrary-Identity "http://sp2010/Data Connections"-ExcelServiceApplication "Excel ...