Formatear una estructura luego de una respuesta HTTP Request

Built with n8n
1

Hola

Tengo una duda acerca de como mapear los campos del resultado de una consulta HTTP Request:

[
  {
    "body": {
      "d": {
        "results": [
          {
            "__metadata": {
              "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')",
              "type": "SFOData.WorkOrder"
            },
            "effectiveStartDate": "/Date(1782864000000)/",
            "userSysId": "50002413",
            "effectiveEndDate": "/Date(253402128000000)/",
            "workerType": null,
            "workOrderOwnerId": null,
            "cust_SLV_MONTO_FACTURADO": null,
            "lastModifiedDateTime": "/Date(1783250527000+0000)/",
            "billingRate": null,
            "endDate": "/Date(253402128000000)/",
            "cust_COL_ARP": null,
            "createdDateTime": "/Date(1782920512000+0000)/",
            "cust_COL_EPS": null,
            "changeSource": null,
            "cust_COL_USUARIODERED": "LEAP09945",
            "skipWorkOrderProcessor": null,
            "vendor": "017",
            "currency": null,
            "cust_COL_ACC_DEDICACIONEXCLUSIVA": null,
            "cust_COL_ACC_TARJETAACCESO": null,
            "billingAmount": null,
            "cust_CRP_RELACIONLABORAL": null,
            "lastModifiedBy": "TEST",
            "cust_HORA_REPLICA": "20221103004153",
            "mdfSystemRecordStatus": "N",
            "cust_COL_ACC_USUARIORED": null,
            "cust_SLV_TIPO_FACTURA": null,
            "effectiveStatus": "A",
            "createdBy": "92001174",
            "workOrderName": null,
            "workOrderId": "50002413",
            "startDate": "/Date(1782864000000)/",
            "workOrderOwnerIdNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/workOrderOwnerIdNav"
              }
            },
            "userSysIdNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/userSysIdNav"
              }
            },
            "createdByNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/createdByNav"
              }
            },
            "lastModifiedByNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/lastModifiedByNav"
              }
            },
            "cust_CRP_RELACIONLABORALNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/cust_CRP_RELACIONLABORALNav"
              }
            },
            "mdfSystemRecordStatusNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/mdfSystemRecordStatusNav"
              }
            },
            "billingRateNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/billingRateNav"
              }
            },
            "currencyNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/currencyNav"
              }
            },
            "workerTypeNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/workerTypeNav"
              }
            },
            "effectiveStatusNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/effectiveStatusNav"
              }
            },
            "cust_SLV_TIPO_FACTURANav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/cust_SLV_TIPO_FACTURANav"
              }
            },
            "wfRequestNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/wfRequestNav"
              }
            },
            "vendorNav": {
              "__deferred": {
                "uri": "https://api8preview.sapsf.com/odata/v2/WorkOrder(effectiveStartDate=datetime'2026-07-01T00:00:00',userSysId='50002413')/vendorNav"
              }
            }
          }
        ]
      }
    },
    "headers": {
      "date": "Sun, 05 Jul 2026 11:28:44 GMT",
      "content-type": "application/json;charset=utf-8",
      "transfer-encoding": "chunked",
      "connection": "close",
      "set-cookie": [
        "route=1783250925.085.22.791668|713b58070d0ea8c9b0a5b3946cee0fc4; Path=/; Secure; HttpOnly; SameSite=None",
        "JSESSIONID=F69CB0B38AFD3B728CD203DD582C6216.sc70bsfapi-75b8f4f8fc-8nqcq#T1##1783250925.085.22.791668|713b58070d0ea8c9b0a5b3946cee0fc4; Path=/odata; Secure"
      ],
      "x-unique-id": "b0862797-ceba-49b7-969b-b58ad8cad210",
      "x-event-id": "EVENT-UNKNOWN-UNKNOWN-rb61arebohF64a7e3e7ebF7mpbp-20260705112844-2435542",
      "x-correlation-id": "b0862797-ceba-49b7-969b-b58ad8cad210",
      "correlationid": "ae6f11d1-0d66-46dc-8322-b902f4c20ba4",
      "requestno": "[2312344]",
      "sap-server": "true",
      "x-csrf-token": "xtOJzd4p0GYJStOipno",
      "company-id": "T1",
      "successfactors-immutable-companyid": "a14c9886_4e3f_4750_ae1b_0c56f1b78312",
      "dataserviceversion": "2.0",
      "record-count": "1",
      "x-sf-record-count-recursive": "1",
      "vary": "Accept-Encoding",
      "successfactors-message": "successfactors-sourcetype is missing in request headers",
      "sfodataservertimezone": "UTC",
      "apiqueryexecutiontimestamp": "2026-07-05T11:28:44.412Z",
      "api-elapsed-time": "191",
      "cache-control": "no-store",
      "pragma": "no-cache",
      "x-request-stats": "1U1FMVD0xNDkmQ0NPTj0wJkZXUj0wJk5SRT0wJkNFWFQ9MCZTVD0xNzgzMjUwOTI0MDg2JkVJRD1FVkVOVC1VTktOT1dOLVVOS05PV04tcmI2MWFyZWJvaEY2NGE3ZTNlN2ViRjdtcGJwLTIwMjYwNzA1MTEyODQ0LTI0MzU1NDImQ0xPQz0wJkNSRU09MCZOV1I9MCZDUFU9ODcmU1ZUPTM0MCZTUUxDPTUwJlNDUFU9MCZDU1VQPTUyJk1FTT0xOTU5NiZVQ1BVPTg3JkZSRT0w",
      "server": "Bizx",
      "referrer-policy": "strict-origin-when-cross-origin",
      "x-content-type-options": "nosniff",
      "strict-transport-security": "max-age=31536000; IncludeSubDomains"
    },
    "statusCode": 200,
    "statusMessage": ""
  }
]

Yo quiero usar un nodo que me permita dejar la información de la siguientes forma:


[
  
{
  
  
"UserID": 
"50002413",
  
  
"Hoy": 
"2026-07-05",
  
  
"FechaInicio": 
"2026-07-01T00:00:00",
  
  
"effectiveStartDate": 
"/Date(1782864000000)/",
  
  
"terminationDate": 
"/Date(1783123200000)/",
  
  
"x-csrf-token": 
"xtOJzd4p0GYJStOipnoJ4WMr0hnfPef5q%2bZOyJhxSuw%3d",
  
  
"set-cookie": 
[
  
  
  
"route=1783250925.085.22.791668|713b58070d0ea8c9b0a5b3946cee0fc4; Path=/; Secure; HttpOnly; SameSite=None",
  
  
  
"JSESSIONID=F69CB0B38AFD3B728CD203DD582C6216.; Path=/odata; Secure"
  
  
]
  
}
]

Entiendo que con Javascript puedo hacerlo , pero quisiera saber como hacerlo usando un nodo donde no tenga que escribir codigo.

Gracias!