How to get json listing from SBM JSON Report in SBM 11.1 and above

Background:

 

SBM Aurora (11.1) had introduced authentication with both javascript and json.  The old method of using the embedded report reference link (tmtrack.dll?ReportPage&template=reports%2Fjsonlist.htm&ReportRef=TRM_DEPLOYMENT_PATHS.Deployment.Paths.By.ReleaseType.and.Applications&HasRuntimeParams=1&") does not work.

 

Solution:

 

The current documentation (json_api_guide.pdf) example is not clear on the usage.  Use the new json api

 

tmtrack.dll?JSONPage=&command=jsonapi&JSON_Func=GetitemsByListingReport&JSON_p1=Deployment%20Paths&JSON_P2=Deployment.Paths.By.ReleaseType.and.Applications&HasRuntimeParams=1&F_TS_RLM_APPLICATIONS=30&F_TS_RELEASE_TYPE=1";

 

JSON_P1 refers to the display name of the database table

JSON_P2 refers to the Reference Name of the Report (Not Reference Link)

Parameters such as F_TS_RLM_APPLICATIONS are located behind

Achieving a Continuous Delivery Pipeline
Dimensions Make (DM_MAKE)

Comments 1

 
Linna Landau on Wednesday, 22 March 2017 04:57

xx

Recent Tweets