12/29/2023 0 Comments Basecamp 3 api login$cmd = New-Object .BasecampCommand("UPDATE Projects SET Drafts='True' WHERE Id = $conn)Īdd-Basecamp -Connection $Basecamp -Table Projects -Columns "DocumentsCount") -Values "MyDocumentsCount") Update-Basecamp -Connection $Basecamp -Columns -Values 'MyDocumentsCount') -Table Projects -Id "MyId" $da= New-Object .BasecampDataAdapter($sql, $conn) $sql="SELECT Name, DocumentsCount from Projects" $conn= New-Object the BasecampDataAdapter, execute an SQL query, and output the results: ::LoadFile("C:\Program Files\CData\CData ADO.NET Provider for Basecamp\lib\.dll") $projects = Invoke-Basecamp -Connection $basecamp -Query 'SELECT * FROM Projects WHERE Drafts = -Params the provider's assembly: You can also use the Invoke-Basecamp cmdlet to execute SQL commands: $projects = Select-Basecamp -Connection $basecamp -Table "Projects" -Where "Drafts = `'$Drafts`'" $basecamp = Connect-Basecamp -User "$User" -Password "$Password" This can be copied from the URL after you log in. See the Getting Started section in the help documentation for a connection guide.Īdditionally, you will need to specify the AccountId connection property. To authenticate to Basecamp via OAuth 2.0, you will need to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties by registering an app with Basecamp. To use basic authentication you will need the user and password that you use for logging in to Basecamp. Once you have acquired the necessary connection properties, accessing Basecamp data in PowerShell can be enabled in three steps.īasecamp uses basic or OAuth 2.0 authentication. NET applications, like LINQPad, use the CData ADO.NET Provider for Basecamp. We also show examples of the ADO.NET equivalent, which is possible with the CData ADO.NET Provider for Basecamp. The Cmdlets are not only a PowerShell interface to Basecamp, but also an SQL interface this tutorial shows how to use both to create, retrieve, update, and delete Basecamp data. The CData Cmdlets for Basecamp are standard PowerShell cmdlets that make it easy to accomplish data cleansing, normalization, backup, and other integration tasks by enabling real-time and bidirectional access to Basecamp.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |