UCSD - HTTP(s) Get VM Details / JSON parsing 2 examples

Orf Gelbrich · ‎03-27-2017

Task Name	HTTPs Get VM details / JSON parsing 2 different ways
Description
Prerequisites	Tested on UCSD 6.0.1.1
Category	Workflow
Components	vSphere 5.x
User Inputs

Instructions for Regular Workflow Use:

Download the attached .ZIP file below to your computer. *Remember the location of the saved file on your computer.
Unzip the file on your computer. Should end up with a .WFD file.
Log in to UCS Director as a user that has "system-admin" privileges.
Navigate to "Policies-->Orchestration" and click on "Import".
Click "Browse" and navigate to the location on your computer where the .WFD file resides. Choose the .WFD file and click "Open".
Click "Upload" and then "OK" once the file upload is completed. Then click "Next".
Click the "Select" button next to "Import Workflows". Click the "Check All" button to check all checkboxes and then the "Select" button.
Click "Submit".
A new folder should appear in "Policies-->Orchestration" that contains the imported workflow. You will now need to update the included tasks with information about the specific environment.

The workflow:

The API call from REST API browser:

HTTPS task input:

vm_id is global variable in workflow

JSON Parser input:

The custom tasks in the workflow:

The JSON2 module (GSON is built in)

The HTTPS code:

importPackage(com.cloupia.model.cIM);

importPackage(java.util);

importPackage(java.lang);

importPackage(java.io);

importPackage(com.cloupia.lib.util);

importPackage(com.cloupia.model.cIM);

importPackage(com.cloupia.service.cIM.inframgr);

importPackage(org.apache.commons.httpclient);

importPackage(org.apache.commons.httpclient.cookie);

importPackage(org.apache.commons.httpclient.methods);

importPackage(org.apache.commons.httpclient.auth);

importPackage(com.cloupia.model.cEvent.notify);

importPackage(com.cloupia.lib.util.mail);

importPackage(com.cloupia.fw.objstore);

importPackage(com.cloupia.lib.util.managedreports);

//

// GENERIC HTTP Function

//

function GenericHTTPFunction(P1, P2){

var ucsdIP = input.UCSDip;

var ucsdUser = input.UCSDuser;

var ucsdPassword = input.UCSDpassword;

var ucsdPort = input.UCSDport;

var Https = input.UCSDhttps;

var key = input.UCSDkey;

//var apiUri = "/cloupia/api-v2/vdc";

//var apiUri = "/cloupia/api-v2/hyperVDeploymentPolicy";

var apiUri = P1;

var xmlBody = P2;

//xmlBody = "1";

var url = apiUri + "/" + xmlBody;

logger.addInfo(" URL : " + url);

var httpClient = new HttpClient();

//httpClient.getHostConfiguration().setHost(ucsdIP, input.UCSDport, input.https);

httpClient.getHostConfiguration().setHost(ucsdIP, ucsdPort, Https);

httpClient.getParams().setCookiePolicy("default");

httpClient.getParams().setAuthenticationPreemptive(true);

var defaultcreds = new UsernamePasswordCredentials(ucsdUser, ucsdPassword);

httpClient.getState().setCredentials(new AuthScope(ucsdIP, -1, null), defaultcreds);

var httpMethod = new PostMethod(apiUri);

//var httpMethod = new GetMethod (apiUri);

//var httpMethod = new GetMethod (url);

httpMethod.setRequestEntity(new StringRequestEntity(xmlBody));

httpMethod.addRequestHeader("Content-Type", "application/xml");

httpMethod.addRequestHeader("X-Cloupia-Request-Key", key);

httpClient.executeMethod(httpMethod);

var statuscode = httpMethod.getStatusCode();

if (statuscode != 201 && statuscode != 200)

{

logger.addError("Request failed. HTTP response code: "+statuscode);

logger.addError("Response = "+httpMethod.getResponseBodyAsString());

httpMethod.releaseConnection();

// Set this task as failed.

ctxt.setFailed("Request failed.");

} else {

logger.addInfo("Request was Succcessful.");

logger.addInfo("Response = "+httpMethod.getResponseBodyAsString());

var x2 = httpMethod.getResponseBodyAsString();

// All done. Release HTTP connection anyway.

httpMethod.releaseConnection();

return x2;

}

//

// generic http call end

//

output.APIResult = GenericHTTPFunction(input.APIuri, input.APIuriItem);

The code for the JSON parser:

The input for the parser is below. The important item to note here is "serviceResult" and "rows" is very important for the variable names with in the code!

{ 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

loadLibrary("JSON-JS-Module/JSON-JS-ModuleLibrary");

var i1 = input.input1;

//var opName = "userAPIGetVMSummary";

function showObject(obj) {

var result = "";

for (var p in obj) {

if( obj.hasOwnProperty(p) ) {

logger.addInfo("Objact name: " + p + " Object value: " + obj[p] );

}

return result;

}

logger.addInfo("The input: " + i1);

var resultObj = JSON2.parse(i1);

//

// The data that is being parsed in this example looks like this:

//{ 'serviceResult':{'rows':[{'Overview_VM_ID':1...

//

// If something different is parsed then the following items need

// to be changed in the code below

//

// serviceResult

// rows

// ****

//

// ****

if(resultObj.serviceResult == null){

logger.addError(responseObj.serviceError);

ctxt.setFailed();

ctxt.exit();

}

var jsonInString = JSON2.stringify(resultObj);

logger.addInfo(jsonInString);

logger.addInfo("Show all object(s)");

// ****

showObject(resultObj.serviceResult.rows[0]);

// other ways of getting information

// ****

logger.addInfo(resultObj.serviceResult.rows[0].Overview_VM_ID);

logger.addInfo(resultObj.serviceResult.rows[0].Overview_Instance_Name);

logger.addInfo(resultObj.serviceResult.rows[0].Overview_Status);

logger.addInfo(resultObj.serviceResult.rows[0].Overview_IP_Address);

logger.addInfo(resultObj.serviceResult.rows[0].Overview_Hostname);

logger.addInfo(resultObj.serviceResult.rows[0].Overview_Image_ID);

//

// Sample output

//

output.JSONout = resultObj.serviceResult.rows[0].Storage_Data_Store_Names

//

//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

//

importPackage(java.util);

importPackage(java.lang);

importPackage(com.cloupia.lib.util);

importPackage(com.cloupia.service.cIM.inframgr);

importPackage(com.google.gson);

//var msg = ctxt.getAPI().userAPIGetTabularValues('ucsServerIdentity');

//{ 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:02 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

var msg = i1;

var gson = new Gson();

var json = gson.toJson(msg);

logger.addInfo('orig msg = '+i1);

logger.addInfo("typeof i1: " + typeof i1 );

logger.addInfo("char code at 2: " + i1.charCodeAt(0) );

logger.addInfo("char code at 2: " + i1.charCodeAt(1) );

logger.addInfo("char code at 2: " + i1.charCodeAt(2) );

logger.addInfo("char code at 2: " + i1.charCodeAt(3) );

logger.addInfo("char code at 2: " + i1.charCodeAt(4) );

logger.addInfo("char code at 2: " + i1.charCodeAt(5) );

logger.addInfo('orig msg = '+i1);

logger.addInfo('msg = ' + msg );

//logger.addInfo('msg = '+json);

var parser = new JsonParser();

var jsonTree = parser.parse(msg).getAsJsonObject();

var serviceResult = jsonTree.get("serviceResult").getAsJsonObject();

logger.addInfo("serviceResult - JSON Object: " + serviceResult.isJsonObject());

var rows = serviceResult.get("rows");

logger.addInfo("rows - JSON Array: " + rows.isJsonArray());

var rowsArray = rows.getAsJsonArray();

logger.addInfo("rowsArray.size: " + rowsArray.size());

logger.addInfo("=========================Row Data ==========================");

for( var i=0; i < rowsArray.size(); i++ ) {

var rowEntry = rowsArray.get(i).getAsJsonObject();

var overview_VM_ID = rowEntry.get("Overview_VM_ID");

logger.addInfo("Overview_VM_ID: " + overview_VM_ID);

var overview_Instance_Name = rowEntry.get("Overview_Instance_Name");

logger.addInfo("Overview_Instance_Name: " + overview_Instance_Name);

var overview_Hostname = rowEntry.get("Overview_Hostname");

logger.addInfo("Overview_Hostname: " + overview_Hostname + "\n");

var network_vNic_IPAddress = rowEntry.get("Network_vNic_IPAddress");

logger.addInfo("Network_vNic_IPAddress: " + network_vNic_IPAddress + "\n");

}

//showObject(resultObj.serviceResult.rows[0]);

logger.addInfo("Before second call the show object");

showObject(rowEntry);

logger.addInfo("After second call the show object");

The run log:

Service Request ID: 524

-------------------------------------

Workflow Inputs:

--Admin Inputs--

--User Inputs--

vm_id : 1

Mar 27, 2017 17:04:16 UTC Request submitted

Mar 27, 2017 17:04:17 UTC Executing workflow item number 1

Mar 27, 2017 17:04:17 UTC Completed workflow item number 1, with status Completed

Mar 27, 2017 17:04:23 UTC Executing workflow item number 2

Mar 27, 2017 17:04:23 UTC Trigger context executeWorkFlowStep called

Mar 27, 2017 17:04:23 UTC Executing custom action HTTPS_get_VM_Details_userAPIGetVMSummary (custom_Post_HTTPS_API_v1)

Mar 27, 2017 17:04:23 UTC Executing custom script for Post_HTTPS_API_v1

Mar 27, 2017 17:04:23 UTC URL : /app/api/rest?formatType=json&opName=userAPIGetVMSummary&opData={param0:1}/

Mar 27, 2017 17:04:24 UTC Request was Succcessful.

Mar 27, 2017 17:04:24 UTC Response = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

Mar 27, 2017 17:04:24 UTC Processing output: APIResult

Mar 27, 2017 17:04:24 UTC Task #2 (HTTPS_get_VM_Details_userAPIGetVMSummary (custom_Post_HTTPS_API_v1)) completed successfully in 0 seconds

Mar 27, 2017 17:04:24 UTC Input/Output values for Task #2 (HTTPS_get_VM_Details_userAPIGetVMSummary (custom_Post_HTTPS_API_v1)):

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDip = 172.17.32.80]

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDport = 8443]

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDkey = D644E837A3984730B33E5641AB1436C2]

Mar 27, 2017 17:04:24 UTC [Template Input:APIuri = /app/api/rest?formatType=json&opName=userAPIGetVMSummary&opData={param0:${vm_id}}]

Mar 27, 2017 17:04:24 UTC [Resolved Template Input: APIuri = /app/api/rest?formatType=json&opName=userAPIGetVMSummary&opData={param0:1}]

Mar 27, 2017 17:04:24 UTC [Local Input: APIuri = /app/api/rest?formatType=json&opName=userAPIGetVMSummary&opData={param0:1}]

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDuser = admin]

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDpassword = **masked-value**]

Mar 27, 2017 17:04:24 UTC [Local Input: UCSDhttps = https]

Mar 27, 2017 17:04:24 UTC [Local Input: APIuriItem = ]

Mar 27, 2017 17:04:24 UTC [Output: APIResult = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }]

Mar 27, 2017 17:04:24 UTC Completed workflow item number 2, with status Completed

Mar 27, 2017 17:04:29 UTC Executing workflow item number 3

Mar 27, 2017 17:04:29 UTC Trigger context executeWorkFlowStep called

Mar 27, 2017 17:04:29 UTC Executing custom action HTTPS_get_VM_Details_userAPIGetVMSummary (custom_JSON_Parse_v1)

Mar 27, 2017 17:04:29 UTC Executing custom script for JSON_Parse_v1

Mar 27, 2017 17:04:29 UTC The input: { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

Mar 27, 2017 17:04:29 UTC {'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0,'Resources_CPU_Limit_MHz':-1,'Resources_CPU_Overhead_Limit_MHz':0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0,'Resources_Memory_Limit_MB':0,'Resources_Memory_Overhead_Limit_MB':221,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}},'serviceError':null,'serviceName':'InfraMgr','opName':'userAPIGetVMSummary'}

Mar 27, 2017 17:04:29 UTC Show all object(s)

Mar 27, 2017 17:04:29 UTC Objact name: Overview_VM_ID Object value: 1

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Instance_Name Object value: CUCSD-6.0.0.0-FishingBay_.79

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Status Object value: ON (poweredOn)

Mar 27, 2017 17:04:29 UTC Objact name: Overview_IP_Address Object value: 172.17.32.79

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Hostname Object value: localhost.localdom

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Image_ID Object value: CUCSD-6.0.0.0-FishingBay_.79

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Cloud_Name Object value: Dallas110

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Cloud_Type Object value: VMWare

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Group Object value: Default Group

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_vDC Object value: Default vDC

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Category Object value: Discovered VM

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Service_Request_ID Object value:

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Label Object value:

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Provisioned_Time Object value:

Mar 27, 2017 17:04:29 UTC Objact name: Ownership_Scheduled_Termination_Time Object value:

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Chargeback_Frequency Object value: Hourly

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Host_Node Object value: 172.17.32.111

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Folder Object value:

Mar 27, 2017 17:04:29 UTC Objact name: Network_Port_Group Object value: VM Network

Mar 27, 2017 17:04:29 UTC Objact name: Network_VLAN_ID Object value: 0

Mar 27, 2017 17:04:29 UTC Objact name: Network_No_of_vNics Object value: 1

Mar 27, 2017 17:04:29 UTC Objact name: Network_vNic_Mac_Address Object value: 00:50:56:94:11:3e

Mar 27, 2017 17:04:29 UTC Objact name: Network_vNic_IPAddress Object value: 172.17.32.79,fe80::250:56ff:fe94:113e

Mar 27, 2017 17:04:29 UTC Objact name: Network_vNic_Device_Config_Id Object value: 4000

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Boot_Time Object value: Mar 14, 2017 13:08:23 UTC

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Config_Name Object value: CUCSD-6.0.0.0-FishingBay_.79

Mar 27, 2017 17:04:29 UTC Objact name: Overview_VM_Version Object value: 7

Mar 27, 2017 17:04:29 UTC Objact name: Overview_VM_Annotation Object value: Cisco UCS Director 6.0.0.0 (Fishing Bay) Note: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.

Mar 27, 2017 17:04:29 UTC Objact name: Overview_Custom_Attributes Object value: User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP:

Mar 27, 2017 17:04:29 UTC Objact name: Overview_vCenter_VM_ID Object value: vm-1844

Mar 27, 2017 17:04:29 UTC Objact name: Resources_Resource_Pool Object value: Resources

Mar 27, 2017 17:04:29 UTC Objact name: Resources_Num_Virtual_CPUs Object value: 4

Mar 27, 2017 17:04:30 UTC Objact name: Resources_CPU_Reserved_MHz Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Resources_CPU_Limit_MHz Object value: -1

Mar 27, 2017 17:04:30 UTC Objact name: Resources_CPU_Overhead_Limit_MHz Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Resources_CPU_Shares Object value: 4000

Mar 27, 2017 17:04:30 UTC Objact name: Resources_Memory_MB Object value: 12288

Mar 27, 2017 17:04:30 UTC Objact name: Resources_Memory_Reserved_MB Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Resources_Memory_Limit_MB Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Resources_Memory_Overhead_Limit_MB Object value: 221

Mar 27, 2017 17:04:30 UTC Objact name: Resources_Memory_Shares Object value: 122880

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Total_Provisioned_GB Object value: 112.03

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Committed_GB Object value: 112.03

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Uncommitted_GB Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Non_shared_GB Object value: 112.03

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Snapshot_Size_MB Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Data_Store_Names Object value: SAN2

Mar 27, 2017 17:04:30 UTC Objact name: Storage_VM_Path Object value: [SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx

Mar 27, 2017 17:04:30 UTC Objact name: Guest_Information_Guest_OS Object value: CentOS 4/5/6 (64-bit)

Mar 27, 2017 17:04:30 UTC Objact name: Guest_Information_Guest_State Object value: running

Mar 27, 2017 17:04:30 UTC Objact name: Guest_Information_Tools_Status Object value: guestToolsRunning

Mar 27, 2017 17:04:30 UTC Objact name: Guest_Information_Tools_Version Object value: 8384

Mar 27, 2017 17:04:30 UTC Objact name: Options_Default_PowerOff_Type Object value: soft

Mar 27, 2017 17:04:30 UTC Objact name: Storage_No_of_Disks Object value: 1

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Name Object value: Hard disk 1

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Datastore_Name Object value: SAN2

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Datacenter_Name Object value: Dallas Lab1

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_UUID Object value: 6000C292-2181-a988-6002-9f455b4a0269

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Unit_Number Object value: 0

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Disk_Mode Object value: persistent

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Provision_Type Object value: Thick

Mar 27, 2017 17:04:30 UTC Objact name: Hard_Disk_1_Details_Provisioned_Size_GB Object value: 99.99

Mar 27, 2017 17:04:30 UTC Objact name: Storage_Datastore_Cluster Object value:

Mar 27, 2017 17:04:30 UTC 1

Mar 27, 2017 17:04:30 UTC CUCSD-6.0.0.0-FishingBay_.79

Mar 27, 2017 17:04:30 UTC ON (poweredOn)

Mar 27, 2017 17:04:30 UTC 172.17.32.79

Mar 27, 2017 17:04:30 UTC localhost.localdom

Mar 27, 2017 17:04:30 UTC CUCSD-6.0.0.0-FishingBay_.79

Mar 27, 2017 17:04:30 UTC orig msg = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

Mar 27, 2017 17:04:30 UTC typeof i1: string

Mar 27, 2017 17:04:30 UTC char code at 2: 123

Mar 27, 2017 17:04:30 UTC char code at 2: 32

Mar 27, 2017 17:04:30 UTC char code at 2: 34

Mar 27, 2017 17:04:30 UTC char code at 2: 115

Mar 27, 2017 17:04:30 UTC char code at 2: 101

Mar 27, 2017 17:04:30 UTC char code at 2: 114

Mar 27, 2017 17:04:30 UTC orig msg = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

Mar 27, 2017 17:04:30 UTC msg = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }

Mar 27, 2017 17:04:30 UTC serviceResult - JSON Object: true

Mar 27, 2017 17:04:30 UTC rows - JSON Array: true

Mar 27, 2017 17:04:30 UTC rowsArray.size: 1

Mar 27, 2017 17:04:30 UTC =========================Row Data ==========================

Mar 27, 2017 17:04:30 UTC Overview_VM_ID: 1

Mar 27, 2017 17:04:30 UTC Overview_Instance_Name: 'CUCSD-6.0.0.0-FishingBay_.79'

Mar 27, 2017 17:04:30 UTC Overview_Hostname: 'localhost.localdom'

Mar 27, 2017 17:04:30 UTC Network_vNic_IPAddress: '172.17.32.79,fe80::250:56ff:fe94:113e'

Mar 27, 2017 17:04:30 UTC Before second call the show object

Mar 27, 2017 17:04:30 UTC After second call the show object

Mar 27, 2017 17:04:30 UTC Processing output: JSONout

Mar 27, 2017 17:04:30 UTC Task #3 (HTTPS_get_VM_Details_userAPIGetVMSummary (custom_JSON_Parse_v1)) completed successfully in 0 seconds

Mar 27, 2017 17:04:30 UTC Input/Output values for Task #3 (HTTPS_get_VM_Details_userAPIGetVMSummary (custom_JSON_Parse_v1)):

Mar 27, 2017 17:04:30 UTC [Mapped Input: input1 = { 'serviceResult':{'rows':[{'Overview_VM_ID':1,'Overview_Instance_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Status':'ON (poweredOn)','Overview_IP_Address':'172.17.32.79','Overview_Hostname':'localhost.localdom','Overview_Image_ID':'CUCSD-6.0.0.0-FishingBay_.79','Overview_Cloud_Name':'Dallas110','Overview_Cloud_Type':'VMWare','Ownership_Group':'Default Group','Ownership_vDC':'Default vDC','Ownership_Category':'Discovered VM','Ownership_Service_Request_ID':'','Ownership_Label':'','Ownership_Provisioned_Time':'','Ownership_Scheduled_Termination_Time':'','Overview_Chargeback_Frequency':'Hourly','Overview_Host_Node':'172.17.32.111','Overview_Folder':'','Network_Port_Group':'VM Network','Network_VLAN_ID':'0','Network_No_of_vNics':1,'Network_vNic_Mac_Address':'00:50:56:94:11:3e','Network_vNic_IPAddress':'172.17.32.79,fe80::250:56ff:fe94:113e','Network_vNic_Device_Config_Id':'4000','Overview_Boot_Time':'Mar 14, 2017 13:08:23 UTC','Overview_Config_Name':'CUCSD-6.0.0.0-FishingBay_.79','Overview_VM_Version':'7','Overview_VM_Annotation':'Cisco UCS Director 6.0.0.0 (Fishing Bay)\n\nNote: It is mandatory to reserve vCPU and Memory as recommended by Installation and Deployment guide.','Overview_Custom_Attributes':'User1: ;USER2: ;SAP CODE: ;blub: ;SAP3: ;bleep: ;associatedTags: ;Name: ;Notes: ;WORKGROUP: ','Overview_vCenter_VM_ID':'vm-1844','Resources_Resource_Pool':'Resources','Resources_Num_Virtual_CPUs':4,'Resources_CPU_Reserved_MHz':0.0,'Resources_CPU_Limit_MHz':-1.0,'Resources_CPU_Overhead_Limit_MHz':0.0,'Resources_CPU_Shares':'4000','Resources_Memory_MB':12288,'Resources_Memory_Reserved_MB':0.0,'Resources_Memory_Limit_MB':0.0,'Resources_Memory_Overhead_Limit_MB':221.0,'Resources_Memory_Shares':'122880','Storage_Total_Provisioned_GB':112.03,'Storage_Committed_GB':112.03,'Storage_Uncommitted_GB':0.0,'Storage_Non_shared_GB':112.03,'Storage_Snapshot_Size_MB':0.0,'Storage_Data_Store_Names':'SAN2','Storage_VM_Path':'[SAN2] CUCSD-6.0.0.0-FishingBay/CUCSD-6.0.0.0-FishingBay.vmx','Guest_Information_Guest_OS':'CentOS 4/5/6 (64-bit)','Guest_Information_Guest_State':'running','Guest_Information_Tools_Status':'guestToolsRunning','Guest_Information_Tools_Version':'8384','Options_Default_PowerOff_Type':'soft','Storage_No_of_Disks':'1','Hard_Disk_1_Details_Name':'Hard disk 1','Hard_Disk_1_Details_Datastore_Name':'SAN2','Hard_Disk_1_Details_Datacenter_Name':'Dallas Lab1','Hard_Disk_1_Details_UUID':'6000C292-2181-a988-6002-9f455b4a0269','Hard_Disk_1_Details_Unit_Number':'0','Hard_Disk_1_Details_Disk_Mode':'persistent','Hard_Disk_1_Details_Provision_Type':'Thick','Hard_Disk_1_Details_Provisioned_Size_GB':'99.99','Storage_Datastore_Cluster':''}],'columnMetaData':null,'reportParams':{}}, 'serviceError':null, 'serviceName':'InfraMgr', 'opName':'userAPIGetVMSummary' }]

Mar 27, 2017 17:04:30 UTC [Output: JSONout = SAN2]

Mar 27, 2017 17:04:30 UTC Completed workflow item number 3, with status Completed

Mar 27, 2017 17:04:32 UTC Executing workflow item number 4

Mar 27, 2017 17:04:32 UTC Completed workflow item number 4, with status Completed