rtc rest in EXCEL macro
<c-wiz class="rm1UF UnxENd dHeVVb" data-node-index="2;0" data-p="%.@."","",""]" jsaction="fgP5ge:reBGj,fO5Jj;SuwQzc:psubsc;ZJRbqd:R99J9b;PPMpVe:Ro8hud;iRXaId:vQ5fhd,QHu6Rd,g1rTCe,hHjFBe;WUl1Sc:Lt1lf;ETwhqd:ohO51;xlKgVc:sz93Ff;auJseb:IV7LWe;pNe98e:B1XqVb;xFfZGc:fO5Jj;OQcvYd:o9EnMb,lXvwxb;sT00Fe:Nrlepe;K1idad:ueU8Ab;MFfQNe:XTf7qb;n3ynxb:tQNmWe;k9TsOe:PCDOwc;RRMwLc:Fg8W1e;mG3QHf:OYLrVb;Qz4V0b:hQ7xdc;fBzasf:YoknPd;UgEtGb:hQ7xdc;h5CHLc:i5R1S; click:gx3W4c; touchend:Ui18c;h1Uxi:qx6Cqc;PF39hf:gx3W4c;HmXuze:peH7Nc;FvQNXc:T2uEDc,J6gWY;zOKmBc:rV2CEd,ZQTNrf;NC92Xd:t0GU7d,UbDGRc;XZiffb:MEUYed,ZcXqnb;" jscontroller="M2suMc" jsdata="deferred-c1153" jsmodel="hc6Ubd LP4cEc" jsrenderer="xuEY0" jsshadow="" style="-webkit-tap-highlight-color: transparent; background-color: rgb(255, 255, 255); color: rgba(0, 0, 0, 0.87); contain: style; display: flex; flex-direction: column; flex: 1 1 0%; font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: medium; position: relative;">
481 / 5000
<c-wiz class="reACy" data-node-index="1;0" data-p="%.@."",""]" jsaction="rcuQ6b:FkvwT;fgP5ge:vQ5fhd;pYfCx:Rayp9d;G5uTk:YW7Ut;nuAkFb:VbcIxe;PF39hf:WijZA,bakTsb,w0auy,uc7bub,OG0KKc,sMOlGe;h1Uxi:Hkadab;keAsDe:OdlKe,IBxxHd;we4cO:xCAWWb;" jscontroller="AKLKy" jsdata="deferred-i17" jsmodel="hc6Ubd VETAO" jsrenderer="rQ304" jsshadow="" style="-webkit-tap-highlight-color: transparent; contain: style;">
https://www.gstatic.com/inputtools/images/ita_sprite8.png" margin: 6px 0px 0px; opacity: 0.26; user-select: none; vertical-align: middle; width: 23px;">
Risultati della traduzione
I would like to query rtc via excel script to know what all the project areas are. I do not find a simple documentation that leads me to have an immediate result. I carry the code I wrote, but I have several problems: 1) how do i log in with my credentials? 2) why in the excel debug view I have a result in XML and not JSON? 3) where can I find the list of all the GET and POST commands that I can use? 4) is the strUrl right? here my code:
Sub Test_LateBinding()
Dim objRequest As Object Dim strUrl As String Dim blnAsync As Boolean Dim strResponse As String
Set objRequest = CreateObject("MSXML2.XMLHTTP") strUrl = "https://myserver/ccm/rpt/repository/ <wbr> foundation?fields=foundation/ <wbr> projectArea/" blnAsync = True
With objRequest .Open "GET", strUrl, blnAsync .SetRequestHeader "Content-Type", "application/json" .Send While objRequest.readyState <> 4 DoEvents Wend strResponse = .ResponseText End With
Debug.Print strResponse
End Sub |
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
The question is herd to read. Please remove the annotated text to improve the readability.