Body
< !!! INTERNAL USE ONLY !!! >
Not for distribution directly to end user
Overview
This article demonstrates how to connect to TDX APIs using PowerShell and Power BI
Audience
Advanced technical staff that need to run reports using the advanced features by using APIs.
Process
Note: Warning, If not used correctly these methods can overwrite material in TDX
If you need access to the BEID number and the web services key, contact the Senior Director of Technology Support.
PowerShell
Use the following script to get access to information from TDX APIs.
$Headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$postParams = @{BEID='********-****-****-****-************';WebServicesKey='********-****-****-****-************'}
$token = Invoke-WebRequest -Uri "https://ccbcmd.teamdynamix.com/TDWebApi/api/auth/loginadmin" -Method Post -Body $postParams
$Headers.Add("Authorization", ("Bearer " + $token.ToString()))
$Params =@{See https://ccbcmd.teamdynamix.com/TDWebApi for parameter information specific to the API call you're making}
$output = Invoke-WebRequest -Uri "See https://ccbcmd.teamdynamix.com/TDWebApi for URL information specific to the API call you're making" -Headers $Headers -Method Post -Body $Params
$outputlist = $output | ConvertFrom-Json
$outputlist
PowerBI
let
authbody = [ BEID= "********-****-****-****-************",
WebServicesKey= "********-****-****-****-************"
],
authheader = [#"Content-Type"= "application/json"],
authresponse = Web.Contents("https://ccbcmd.teamdynamix.com/TDWebApi/api/auth/loginadmin",[Content=Json.FromValue(authbody),Headers=authheader]),
authtext = Text.FromBinary(authresponse),
header = [ #"Authorization"="Bearer "&authtext,
#"Content-Type"= "application/x-www-form-urlencoded"],
body = "{ ""Parameter"": ""value""}", See https://ccbcmd.teamdynamix.com/TDWebApi for parameter information specific to the API call you're making
encodedbody = Text.ToBinary(Uri.BuildQueryString(Json.Document(body))),
url = "See https://ccbcmd.teamdynamix.com/TDWebApi for URL information specific to the API call you're making",
response = Web.Contents(url,[Content=encodedbody,Headers=header]),
Source = Json.Document(response)
in
Source