Java 1.8.0_181
Windows 10.0.17134 Build 17134 64bit
Salesforce Enterprise Edition Summer '18 release
Salesforce profile: system administrator


For a migration project I want to populate standard Account field NumberOfEmployees in Salesforce.

Reproducing using only data grid with a single row name='test',numbersofemployees=2 and Salesforce insert steps in Kettle, kettle returns consistent api error INVALID_TYPE_ON_FIELD_IN_RECORD. Datatypes Integer, Number and String for numberofemployees all result in this error.
When populating to a custom field with type Integer (in Salesforce + Kettle) there is no issue.

I kept the api version in the 'Salesforce Webservice URL' field of the Salesforce Insert step at v37, which seems non-relevant.
According to the documentation this field is of primitive type int. Looking at the api the XML type is xsd:int, while custom fields of type Integer have xsd:double.

Thank you in advance,

With kind regards,