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!