Hi there 
I’m having an issue combining 2 APIs response together. I feel its something like a wrong format but cant resolve it so far.
Here is my first response JSON :
[
{
"metadata": {
"shipmentType": "CT",
"shipmentNumber": "FANU1172910",
"sealine": "HLCU",
"sealineName": "Hapag-Lloyd",
"shippingStatus": "IN_TRANSIT",
"updatedAt": "2024-01-28T19:14:10Z"
},
"locations": [
{
"name": "Antwerp",
"state": "Flanders",
"country": "Belgium",
"countryCode": "BE",
"locode": "BEANR",
"coordinates": {
"lat": 51.22047,
"lng": 4.40026
},
"timezone": "Europe/Brussels"
},
{
"name": "Woerth am Rhein",
"state": "Rheinland-Pfalz",
"country": "Germany",
"countryCode": "DE",
"locode": "DEWOE",
"coordinates": {
"lat": 49.04888,
"lng": 8.25959
},
"timezone": "Europe/Berlin"
},
{
"name": "Savannah",
"state": "Georgia",
"country": "United States",
"countryCode": "US",
"locode": "USSAV",
"coordinates": {
"lat": 32.08354,
"lng": -81.09983
},
"timezone": "America/New_York"
}
],
"route": {
"prepol": {
"location": null,
"date": null,
"actual": null,
"predictiveEta": null
},
"pol": {
"location": {
"name": "Savannah",
"state": "Georgia",
"country": "United States",
"countryCode": "US",
"locode": "USSAV",
"coordinates": {
"lat": 32.08354,
"lng": -81.09983
},
"timezone": "America/New_York"
},
"date": "2023-12-12T05:14:00Z",
"actual": true,
"predictiveEta": null
},
"pod": {
"location": {
"name": "Antwerp",
"state": "Flanders",
"country": "Belgium",
"countryCode": "BE",
"locode": "BEANR",
"coordinates": {
"lat": 51.22047,
"lng": 4.40026
},
"timezone": "Europe/Brussels"
},
"date": "2024-01-14T12:48:00Z",
"actual": true,
"predictiveEta": null
},
"postpod": {
"location": null,
"date": null,
"actual": null,
"predictiveEta": null
}
},
"vessels": [
{
"name": "COLORADO EXPRESS",
"imo": 9349502,
"callSign": "WDM2200",
"mmsi": 369215000,
"flag": "US"
}
],
"facilities": [],
"containers": [
{
"number": "FANU1172910",
"isoCode": "45G1",
"status": "IN_TRANSIT",
"events": [
{
"location": {
"name": "Savannah",
"state": "Georgia",
"country": "United States",
"countryCode": "US",
"locode": "USSAV",
"coordinates": {
"lat": 32.08354,
"lng": -81.09983
},
"timezone": "America/New_York"
},
"facility": null,
"description": "Arrival in",
"eventType": "TRANSPORT",
"eventCode": "ARRI",
"status": "CGI",
"date": "2023-12-12T05:14:00Z",
"isActual": true,
"isAdditionalEvent": false,
"routeType": "LAND",
"transportType": "TRUCK",
"vessel": null,
"voyage": null
},
{
"location": {
"name": "Savannah",
"state": "Georgia",
"country": "United States",
"countryCode": "US",
"locode": "USSAV",
"coordinates": {
"lat": 32.08354,
"lng": -81.09983
},
"timezone": "America/New_York"
},
"facility": null,
"description": "Loaded",
"eventType": "EQUIPMENT",
"eventCode": "LOAD",
"status": "CLL",
"date": "2023-12-30T05:39:00Z",
"isActual": true,
"isAdditionalEvent": false,
"routeType": "SEA",
"transportType": "VESSEL",
"vessel": {
"name": "COLORADO EXPRESS",
"imo": 9349502,
"callSign": "WDM2200",
"mmsi": 369215000,
"flag": "US"
},
"voyage": "040E"
},
{
"location": {
"name": "Savannah",
"state": "Georgia",
"country": "United States",
"countryCode": "US",
"locode": "USSAV",
"coordinates": {
"lat": 32.08354,
"lng": -81.09983
},
"timezone": "America/New_York"
},
"facility": null,
"description": "Vessel departed",
"eventType": "TRANSPORT",
"eventCode": "DEPA",
"status": "VDL",
"date": "2023-12-30T16:24:00Z",
"isActual": true,
"isAdditionalEvent": false,
"routeType": "SEA",
"transportType": "VESSEL",
"vessel": {
"name": "COLORADO EXPRESS",
"imo": 9349502,
"callSign": "WDM2200",
"mmsi": 369215000,
"flag": "US"
},
"voyage": "040E"
},
{
"location": {
"name": "Antwerp",
"state": "Flanders",
"country": "Belgium",
"countryCode": "BE",
"locode": "BEANR",
"coordinates": {
"lat": 51.22047,
"lng": 4.40026
},
"timezone": "Europe/Brussels"
},
"facility": null,
"description": "Vessel arrived",
"eventType": "TRANSPORT",
"eventCode": "ARRI",
"status": "VAD",
"date": "2024-01-14T12:48:00Z",
"isActual": true,
"isAdditionalEvent": false,
"routeType": "SEA",
"transportType": "VESSEL",
"vessel": {
"name": "COLORADO EXPRESS",
"imo": 9349502,
"callSign": "WDM2200",
"mmsi": 369215000,
"flag": "US"
},
"voyage": "040E"
},
{
"location": {
"name": "Antwerp",
"state": "Flanders",
"country": "Belgium",
"countryCode": "BE",
"locode": "BEANR",
"coordinates": {
"lat": 51.22047,
"lng": 4.40026
},
"timezone": "Europe/Brussels"
},
"facility": null,
"description": "Discharged",
"eventType": "EQUIPMENT",
"eventCode": "DISC",
"status": "CDD",
"date": "2024-01-15T03:02:00Z",
"isActual": true,
"isAdditionalEvent": false,
"routeType": "SEA",
"transportType": "VESSEL",
"vessel": {
"name": "COLORADO EXPRESS",
"imo": 9349502,
"callSign": "WDM2200",
"mmsi": 369215000,
"flag": "US"
},
"voyage": "040E"
},
{
"location": {
"name": "Antwerp",
"state": "Flanders",
"country": "Belgium",
"countryCode": "BE",
"locode": "BEANR",
"coordinates": {
"lat": 51.22047,
"lng": 4.40026
},
"timezone": "Europe/Brussels"
},
"facility": null,
"description": "Departure from",
"eventType": "TRANSPORT",
"eventCode": "DEPA",
"status": "CGO",
"date": "2024-01-15T00:00:00Z",
"isActual": false,
"isAdditionalEvent": false,
"routeType": "LAND",
"transportType": null,
"vessel": null,
"voyage": null
},
{
"location": {
"name": "Woerth am Rhein",
"state": "Rheinland-Pfalz",
"country": "Germany",
"countryCode": "DE",
"locode": "DEWOE",
"coordinates": {
"lat": 49.04888,
"lng": 8.25959
},
"timezone": "Europe/Berlin"
},
"facility": null,
"description": "Arrival in",
"eventType": "TRANSPORT",
"eventCode": "ARRI",
"status": "LTS",
"date": "2024-01-18T00:00:00Z",
"isActual": false,
"isAdditionalEvent": false,
"routeType": "LAND",
"transportType": null,
"vessel": null,
"voyage": null
}
]
}
],
"routeData": {
"routeSegments": [
{
"path": [
{
"lat": 32.0835,
"lng": -81.0998
},
{
"lat": 31.7521,
"lng": -80.7895
},
{
"lat": 31.7432,
"lng": -80.7767
},
{
"lat": 31.7429,
"lng": -80.7636
},
{
"lat": 31.7512,
"lng": -80.7503
},
{
"lat": 32.3254,
"lng": -80.1372
},
{
"lat": 32.3365,
"lng": -80.123
},
{
"lat": 32.3448,
"lng": -80.1072
},
{
"lat": 32.3503,
"lng": -80.0899
},
{
"lat": 49.9098,
"lng": -2.4893
},
{
"lat": 49.9131,
"lng": -2.4746
},
{
"lat": 49.9164,
"lng": -2.4599
},
{
"lat": 49.9197,
"lng": -2.4453
},
{
"lat": 50.5471,
"lng": 0.3557
},
{
"lat": 50.5507,
"lng": 0.3703
},
{
"lat": 50.5547,
"lng": 0.3847
},
{
"lat": 50.5591,
"lng": 0.3991
},
{
"lat": 50.677,
"lng": 0.7562
},
{
"lat": 50.6819,
"lng": 0.7706
},
{
"lat": 50.6872,
"lng": 0.7849
},
{
"lat": 50.6929,
"lng": 0.7991
},
{
"lat": 51.8025,
"lng": 3.4884
},
{
"lat": 51.8089,
"lng": 3.5021
},
{
"lat": 51.8167,
"lng": 3.515
},
{
"lat": 51.8257,
"lng": 3.5272
},
{
"lat": 51.9903,
"lng": 3.7275
},
{
"lat": 51.9985,
"lng": 3.7433
},
{
"lat": 51.9969,
"lng": 3.7581
},
{
"lat": 51.9855,
"lng": 3.772
},
{
"lat": 51.2205,
"lng": 4.4003
}
],
"routeType": "SEA"
},
{
"path": [
{
"lat": 51.2205,
"lng": 4.4003
},
{
"lat": 52.0008,
"lng": 4.0729
},
{
"lat": 52.0173,
"lng": 4.0687
},
{
"lat": 52.0336,
"lng": 4.0694
},
{
"lat": 52.0497,
"lng": 4.0753
},
{
"lat": 52.202,
"lng": 4.1551
},
{
"lat": 52.2183,
"lng": 4.1643
},
{
"lat": 52.2338,
"lng": 4.1746
},
{
"lat": 52.2486,
"lng": 4.186
},
{
"lat": 52.9455,
"lng": 4.7559
},
{
"lat": 52.9594,
"lng": 4.7694
},
{
"lat": 52.9705,
"lng": 4.7849
},
{
"lat": 52.979,
"lng": 4.8023
},
{
"lat": 53.3875,
"lng": 5.8557
},
{
"lat": 53.3929,
"lng": 5.8711
},
{
"lat": 53.3973,
"lng": 5.8867
},
{
"lat": 53.4008,
"lng": 5.9027
},
{
"lat": 53.6795,
"lng": 7.4116
},
{
"lat": 53.6821,
"lng": 7.4277
},
{
"lat": 53.6839,
"lng": 7.4439
},
{
"lat": 53.6849,
"lng": 7.4602
},
{
"lat": 53.6943,
"lng": 7.6956
},
{
"lat": 53.694,
"lng": 7.7149
},
{
"lat": 53.6913,
"lng": 7.7339
},
{
"lat": 53.6865,
"lng": 7.7527
},
{
"lat": 53.559,
"lng": 8.1529
},
{
"lat": 53.5543,
"lng": 8.1675
},
{
"lat": 53.5497,
"lng": 8.1821
},
{
"lat": 53.545,
"lng": 8.1967
},
{
"lat": 53.5026,
"lng": 8.3298
},
{
"lat": 53.4961,
"lng": 8.3418
},
{
"lat": 53.4861,
"lng": 8.3488
},
{
"lat": 53.4725,
"lng": 8.351
},
{
"lat": 49.04888,
"lng": 8.25959
},
{
"lat": 49.0489,
"lng": 8.2596
}
],
"routeType": "SEA"
}
],
"coordinates": {
"lat": 49.04888,
"lng": 8.25959
},
"ais": {
"status": "NOT_ON_BOARD",
"data": null
}
}
}
]
Then i transform some part to chain another API (co2), my response contains X items (depend on number of voyage steps)
Then i set some values :
[
{
"input": {
"vessel": {
"imo": 9706906,
"mmsi": null,
"speed": 13
},
"departure": {
"portCode": "USSAV",
"departureName": "Savannah"
},
"arrival": {
"portCode": "BEANR",
"arrivalName": "Antwerp"
},
"departureDate": "2023-12-12T05:14:00Z",
"arrivalDate": "2024-01-14T12:48:00Z"
},
"length": 3830.9322307157154,
"co2EmissionResult": {
"vesselMethodResult": {
"co2Wtt": 0.09756429604921284,
"co2Ttw": 1.1820289713654633,
"co2Wtw": 1.2795932674146762,
"WtwEmissionIntensity": 0.0001803542972796
},
"tradeLaneMethodResult": {
"co2Wtt": 0.049664205438998535,
"co2Ttw": 0.6385397842156955,
"co2Wtw": 0.688203989654694,
"WtwEmissionIntensity": 0.000097
}
},
"voyage": 0
},
{
"input": {
"vessel": {
"imo": 9706906,
"mmsi": null,
"speed": 13
},
"departure": {
"portCode": "BEANR",
"departureName": "Antwerp"
},
"arrival": {
"portCode": "DEWOE",
"arrivalName": "Woerth am Rhein"
},
"departureDate": "2024-01-14T12:48:00Z",
"arrivalDate": "2024-01-18T00:00:00Z"
},
"length": 353.12437622092904,
"co2EmissionResult": {
"vesselMethodResult": {
"co2Wtt": 0.00899319776726402,
"co2Ttw": 0.10895604987262175,
"co2Wtw": 0.11794924763988579,
"WtwEmissionIntensity": 0.0001803542972796
},
"tradeLaneMethodResult": {
"co2Wtt": 0.007847836137133926,
"co2Ttw": 0.0961359926798906,
"co2Wtw": 0.10398382881702453,
"WtwEmissionIntensity": 0.000159
}
},
"voyage": 1
}
]
Next below
