Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Salesforce Standard Integer Fields

  1. #1
    Join Date
    Jul 2016

    Exclamation Salesforce Standard Integer Fields

    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,


  2. #2


    You might try using the latest 8.1 release as a quick test, as I believe there were significant changes made in the Salesforce steps in 7.1, and there were a couple of bugs that cropped up which were fixed in the EE service packs for 7.1.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.