Category: SAP Integration Suite (CPI)

SAP Integration Suite
SAP Cloud Platform Integration (CPI)

Get From/To Unix/JSON Date Format

JavaScript
//Clear console
console.clear()

//Get Unix/json date format from date
console.log(new Date("2020-11-20T16:00:00Z").getTime())
1605888000000

//Get date from Unix/json date format
console.log(new Date(1605888000000).toUTCString())
Fri, 20 Nov 2020 16:00:00 GMT

Issue converting XML to CSV

Columns order are changed and do not follow order of xml properties. This issue usually is not noticed until final tests take place, and this technically this is not an error. What happens is that if xml fields are not required, first line will set column order for the following lines. When subsequent nodes carry those additional properties, that’s when issue start happening.

Solution: if you have a context mapping that builds xml prior to csv conversion, make sure to use map default function, to force creation of property, even if empty.

SAP CPI Integration: Certificates for Hybrid Integration

From SAP ERP, export server certificate from tcode STRUST/STRUSTSSO2 -> SSL server Standard and import it in SAP CPI

Import certificate generated from SAP CPI into tcode STRUST/STRUSTSSO2 -> SSL client SSL Client (Standard) and SSL client SSL Client(Anonymous)