I need to convert my JSON into a DataTable. While working on a legacy process, I used the “JSON to DataTable” activities, but I can’t find similar activities in Windows. Could you please help me identify any equivalent activities available in Windows?
Activity functionality can be replaced by code options
just share with us your JSON sample. Based on this we can check the solution approaches
Thanks,
this is the json output .
{"result": [{"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/ca4e978b1b617850bc50eb11604bcb9e", "value": "ca4e978b1b617850bc50eb11604bcb9e"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Performer\n Machine: RPAPRD02 \nTransaction Reference#: 64e52bcc4d02a85d5ddb9b80\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "2", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0661095", "opened_at": "2023-08-23 23:16:27", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/ca4e978b1b617850bc50eb11604bcb9e", "value": "ca4e978b1b617850bc50eb11604bcb9e"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "2", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpaprd02", "sys_created_on": "2023-08-23 23:16:27", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "63e3359a1b7c3d10a495997a234bcb93", "sys_mod_count": "46", "sys_tags": "", "sys_updated_by": "rpatst03", "sys_updated_on": "2024-07-15 06:49:26", "task_effective_number": "INC0661095", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "26", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758427", "opened_at": "2024-07-01 16:05:12", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-01 16:05:12", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "c6da8ccb874382104844848e8bbb353d", "sys_mod_count": "9", "sys_tags": "", "sys_updated_by": "rpatst03", "sys_updated_on": "2024-07-03 06:44:14", "task_effective_number": "INC0758427", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "26", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758428", "opened_at": "2024-07-01 16:07:05", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-01 16:07:05", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "714b440f874382104844848e8bbb35e3", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-01 16:07:06", "task_effective_number": "INC0758428", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758510", "opened_at": "2024-07-02 13:08:05", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 13:08:05", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "ddebe8138747c2104844848e8bbb354b", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 13:08:06", "task_effective_number": "INC0758510", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758511", "opened_at": "2024-07-02 13:23:45", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 13:23:45", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "fa7f6c5f874bc210dde784c4dabb3521", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 13:23:48", "task_effective_number": "INC0758511", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758512", "opened_at": "2024-07-02 13:35:50", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 13:35:50", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "f332bc13878bc210dde784c4dabb3598", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 13:35:52", "task_effective_number": "INC0758512", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758513", "opened_at": "2024-07-02 14:09:45", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 14:09:45", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "600abcdf8747c2104844848e8bbb3515", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 14:09:47", "task_effective_number": "INC0758513", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758514", "opened_at": "2024-07-02 14:29:32", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 14:29:32", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "6e8e389f878bc210dde784c4dabb352a", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 14:29:34", "task_effective_number": "INC0758514", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758515", "opened_at": "2024-07-02 14:37:28", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-02 14:37:28", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "2250c91387cbc210dde784c4dabb3570", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-02 14:37:29", "task_effective_number": "INC0758515", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/4851db941b0919908a52ebd7b04bcb7f", "value": "4851db941b0919908a52ebd7b04bcb7f"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.\n Process name: OPM_Dispatcher\n Machine: AVDRPADEV09 \nTransaction Reference#: No Transaction refference as it is a dispatcher\n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manually refund the customer and close the gift card.", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0758519", "opened_at": "2024-07-03 06:43:42", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/8e4e978b1b617850bc50eb11604bcbb3", "value": "8e4e978b1b617850bc50eb11604bcbb3"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev02", "sys_created_on": "2024-07-03 06:43:42", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "2c8d90a387cb0610dde784c4dabb3530", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev02", "sys_updated_on": "2024-07-03 06:43:45", "task_effective_number": "INC0758519", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/e7ffbed91bd405908a52ebd7b04bcb6c", "value": "e7ffbed91bd405908a52ebd7b04bcb6c"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua\n Process name: Store Level Assortments New Edit - Dispatcher\n Machine: AVDRPADEV07 \nTransaction Reference#: \n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0759084", "opened_at": "2024-07-09 11:30:41", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/e7ffbed91bd405908a52ebd7b04bcb6c", "value": "e7ffbed91bd405908a52ebd7b04bcb6c"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev07", "sys_created_on": "2024-07-09 11:30:41", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "7ab818258793c2104844848e8bbb35a7", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev07", "sys_updated_on": "2024-07-09 11:30:44", "task_effective_number": "INC0759084", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}, {"actions_taken": "", "active": "true", "activity_due": "", "additional_assignee_list": "", "approval": "not requested", "approval_history": "", "approval_set": "", "assigned_to": "", "assignment_group": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/a0ec0030db6aac10459706e2ca9619c8", "value": "a0ec0030db6aac10459706e2ca9619c8"}, "business_duration": "", "business_impact": "", "business_service": "", "business_stc": "", "calendar_duration": "", "calendar_stc": "", "caller_id": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/e7ffbed91bd405908a52ebd7b04bcb6c", "value": "e7ffbed91bd405908a52ebd7b04bcb6c"}, "category": "", "cause": "", "caused_by": "", "child_incidents": "0", "close_code": "", "close_notes": "", "closed_at": "", "closed_by": "", "cmdb_ci": "", "comments": "", "comments_and_work_notes": "", "company": "", "contact_type": "email", "contract": "", "correlation_display": "", "correlation_id": "", "description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua\n Process name: Store Level Assortments New Edit - Dispatcher\n Machine: AVDRPADEV07 \nTransaction Reference#: \n Exception Message: The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "due_date": "", "escalation": "0", "expected_start": "", "follow_up": "", "group_list": "", "hold_reason": "", "impact": "3", "incident_state": "1", "knowledge": "false", "lessons_learned": "", "location": "", "made_sla": "true", "major_incident_state": "", "notify": "1", "number": "INC0759086", "opened_at": "2024-07-09 11:32:45", "opened_by": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user/e7ffbed91bd405908a52ebd7b04bcb6c", "value": "e7ffbed91bd405908a52ebd7b04bcb6c"}, "order": "", "origin_id": "", "origin_table": "", "overview": "", "parent": "", "parent_incident": "", "priority": "4", "problem_id": "", "promoted_by": "", "promoted_on": "", "proposed_by": "", "proposed_on": "", "reassignment_count": "1", "reopen_count": "0", "reopened_by": "", "reopened_time": "", "resolved_at": "", "resolved_by": "", "rfc": "", "route_reason": "", "service_offering": "", "severity": "3", "short_description": "The Gift Card 6309478339400990 balance in the amount of 39.68 details are matching in PBC, but unable to refund in PXP after 2 attempts. Please attempt to manua", "skills": "", "sla_due": "", "state": "1", "subcategory": "", "sys_class_name": "incident", "sys_created_by": "rpadev07", "sys_created_on": "2024-07-09 11:32:45", "sys_domain": {"link": "https://abercrombietest.service-now.com/api/now/table/sys_user_group/global", "value": "global"}, "sys_id": "8d3910658793c2104844848e8bbb3574", "sys_mod_count": "3", "sys_tags": "", "sys_updated_by": "rpadev07", "sys_updated_on": "2024-07-09 11:32:47", "task_effective_number": "INC0759086", "time_worked": "", "timeline": "", "u_call_back": "", "u_defective_item_model": "", "u_defective_item_serial_number": "", "u_desk_location": "", "u_direct_cause": "", "u_duplicate_incident_counter": "0", "u_fix_action": "", "u_impact_statement": "", "u_inc_category": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_categories/dc440474dbdfbb0013d8ea42ca9619bb", "value": "dc440474dbdfbb0013d8ea42ca9619bb"}, "u_inc_component": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_component/61b5e45e1bc399d0bc50eb11604bcb6f", "value": "61b5e45e1bc399d0bc50eb11604bcb6f"}, "u_inc_condition": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_condition/b1f5649e1bc399d0bc50eb11604bcb48", "value": "b1f5649e1bc399d0bc50eb11604bcb48"}, "u_inc_subcomponent": {"link": "https://abercrombietest.service-now.com/api/now/table/u_af_inc_subcomponent/5be5e09e1bc399d0bc50eb11604bcba0", "value": "5be5e09e1bc399d0bc50eb11604bcba0"}, "u_incident_technical_description": "", "u_lexmark_case_number": "", "u_major_incident": "false", "u_next_steps": "", "u_non_code_issue": "false", "u_non_code_issue_explanation": "", "u_properties": "", "u_reason_for_canceling": "", "u_reason_for_escalation": "", "u_redirected_from_customer_service": "false", "u_reported_by": "", "u_resolution": "", "u_root_cause_component": "", "u_search_categories": "", "u_seat_location": "", "u_sev": "", "u_sev_end_date_time": "", "u_sev_start_date_time": "", "u_store_not_listed": "", "u_tertiary_category": "", "u_vendor_ticket": "", "u_walkup": "false", "universal_request": "", "upon_approval": "proceed", "upon_reject": "cancel", "urgency": "2", "user_input": "", "watch_list": "", "work_end": "", "work_notes": "", "work_notes_list": "", "work_start": "", "x_splu2_victorops_servicenow_initiated": "false", "x_splu2_victorops_victorops_entity_id": "", "x_splu2_victorops_victorops_incident": "", "x_splu2_victorops_victorops_initiated": "false"}]}
i need to extract sys_id,sys_updated_on . and have them in datatable
Parse the Json into a JObject
out: myJObject
Assign Activity
dtData =
JArray.FromObject(myJObject("result").Values(Of Jobject).Select(Function(x) new JObject({"sys_id","sys_updated_on"}.Select(function (n) x.Property(n))))).ToObject(Of DataTable)
And can also adapt, compact or combine with a collection to data table activity
it is always recommended to have a specific check of the JSON structure, before using any out-of-the-box activities as nested structures can create sided effects
1 Like
Thank you! If I want to extract values as columns, do I need to specify each column name separately (e.g., “sys_id”, “sys_updated_on”), or is it possible to convert the entire JSON into a DataTable at once?
As mentioned:
and there are nested structures present
so it depends on your needs, definitions on how to handle it.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
sharu_priya
Yoichi
Anil_G
jast1631
jitendra.saroj
Allan_Marcello
naveen.s
Kancharla_Mahija
Jon_Smith