AnsweredAssumed Answered

Parsing SoapResponseBody

Question asked by Bassoalto on Dec 26, 2018
Latest reply on Jan 3, 2019 by Bassoalto

Hello, i need help parsing a SoapResponseBody on a Invoking SOAP method.

I have this result:

 

<ns:getTicketResponse xmlns:ns="http://wrappers.webservice.appservices.core.inteqnet.com">
<ns:return xmlns:ax267="http://beans.webservice.appservices.core.inteqnet.com/xsd" xmlns:ax269="http://beans.webservice.components.inteqnet.com/xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ax269:DefaultServiceResponse">
<ax269:errors/>
<ax269:notes/>
<ax269:resourceName/>
<ax269:responseBean xsi:type="ax269:Bean"/>
<ax269:responseFormat>JSON</ax269:responseFormat>
<ax269:responseStatus>OK</ax269:responseStatus>
<ax269:responseText>[{
"Action ID When Approved": "",
"Action ID When Rejected": "",
"Action When Approved": "",
"Action When Rejected": "",
"Affected Service": "",
"Affected Service ID": "",
"Approval Phase": "",
"Approval Status": "",
"Assigned Group": "Administration",
"Assigned Group ID": "1",
"Assigned Individual": "Basoalto, Fabian",
"Assigned Individual ID": "7",
"CCTI ID": "76",
"Case ID": "100",
"Case#": "100-119",
"Category": "Reparaciones",
"Cause": "",
"Class": "Servicios Generales",
"Client Viewable": "----",
"Closed By": "",
"Closed On": "",
"Created By": "Perez, Javier",
"Created On": "12/19/2018 09:39:48 AM",
"Description": "Reporte de fallas relacionadas los componentes de luminaria, tales como ampolletas y tubos fluorescentes.",
"Details": "Este es el detalle de ISM \"Description_Long\"",
"Email": "agustin.avila@tech.com",
"First Closed On": "",
"Impact": "Medium",
"Impact Code": "2",
"Item": "1121104220",
"KB Article ID": "",
"Last Modified": "12/19/2018 09:46:02 AM",
"Location": "",
"Modified By": "Morales, Andres",
"Organization": "",
"Parent Ticket ID": "",
"Parent Ticket Identifier": "",
"Phase": "Submitted",
"Phone": "123675",
"Prioritiy": "Medium",
"Prioritiy Code": "3",
"Reason Code": "None",
"Received In Mailbox": "",
"Requested For": "Avila ., Mario Agustin",
"Requester Name": "Avila ., Mario Agustin",
"Requester Phone": "123675",
"Resolution": "",
"Resolved Using Case#": "",
"Resolved Using Item ID": "",
"Row ID": "215",
"SLA Start Date": "12/19/2018 09:39:48 AM",
"Site": "",
"Source": "Agent",
"Source Code": "5",
"Status": "New",
"Ticket Type": "Service Request",
"Total Time Spent (HH:MM)": "00:00",
"Type": "Luminaria",
"Urgency": "Medium",
"Urgency Code": "2",
"anexo o extensión teléfono": "1235",
"appr_voting_type": "",
"auto_route_tickets": "",
"ca_sdm_ticket": "519702",
"ca_sdm_uuid_user": "",
"ccti_search": "",
"closed_by_name": "",
"closed_date": "",
"default_template_id": "",
"defser_message": "",
"defser_replaced_query": "",
"edificio": "",
"esd_com012_var_field_name": "",
"esd_org018_var_new_contact_name": "",
"esd_org023_var_field_name": "",
"esd_srq001_rdb_priority_new": "",
"filt_case_id": "",
"filt_compliance_status": "",
"filt_target_name": "",
"filt_ticket_type": "",
"filt_type": "",
"filt_user": "",
"hold_ccti_id": "",
"is_table_refresh_required": "",
"islogoutaction": "",
"isworklogadded": "",
"last_used_action_id": "",
"last_used_template_id": "",
"last_worklog": "",
"last_worklog_date": "",
"listapprovalphase": "",
"listapprovertype": "",
"nombre del usuario": "FCAMIROAGAV",
"person1_address_id": "",
"person1_contact_id": "6",
"person1_hierarchical_path": "TEST",
"person1_org_id": "1",
"person1_org_name": "TEST",
"person1_root_org_name": "",
"person2_address_id": "",
"person2_contact_id": "6",
"person2_hierarchical_path": "TEST",
"person2_org_id": "1",
"person2_org_name": "TEST",
"person2_root_org_name": "",
"pflow_guid": "",
"pflow_id": "43",
"qcktkt_description": "",
"recent_activity": "",
"recheckifcontactisvip": "",
"rel_column_name": "",
"rel_table": "",
"related_ci": "",
"resolved_by_name": "",
"resolved_date": "",
"sector": "",
"send_worklog_email": "",
"show_related_tkt_activity": "",
"show_violation_threshold": "",
"sla_due_by": "",
"sla_holiday_name": "",
"sla_tz_name": "",
"temp_appr_phase": "",
"temp_appr_status": "",
"temp_appr_voting_type": "",
"template_id": "",
"ticket_againg_range": "",
"ticket_pending_approval": "0",
"translated_act_description": "",
"translated_act_name": "",
"translated_act_special_function_name": "",
"translated_attr_default_value": "",
"translated_attr_list_of_values": "",
"translated_attr_name": "",
"translated_categorization": "",
"translated_form_name": "",
"translated_sla_compliance_status": "",
"translated_template_name": "",
"translated_ticket_type": "",
"ubicación piso": "8",
"vip_flag": "",
"vip_flag_person1": "false",
"vip_flag_person2": "false",
"wall_ticket_type": ""
}]</ax269:responseText>
<ax269:statusCode>000</ax269:statusCode>
<ax269:statusMessage>Success: The request was successfully fulfilled by the server; the service returned results of the operation.</ax269:statusMessage>
<ax269:warnings/>
</ns:return>
</ns:getTicketResponse>

And I need to parse this value into a variable:

 

"Details": "Este es el detalle de ISM \"Description_Long\"",

 

Can anybody help me with this ??

 

Best regards,

Fabian

Outcomes