Skip to main content
Saulo Bravim 님이 #Integration에 질문했습니다
I'm using the salesforce upsert component, but the field lookup field is getting empty. The field in the related object is an external ID, since I am using a product code and not the salesforce id.

The csv is apparently correct.

Who do you have any idea?

Process

pentaho data integration Salesforce upsert- lookup field is empty

Conf. Upsert

User-added image

Conf csv

User-added image

Related object

User-added image

Account

User-added image
답변 1개
  1. 2017년 2월 13일 오후 8:37
    It looks like your setup is correct. I believe this is broken in the newest version of PDI, 7.0. You can see the bug filed here: http://jira.pentaho.com/browse/PDI-15903

    If you haven't yet you can look at using 6.1 instead. It doesn't support the newer versions of the SFDC API but it doesn't perform this task reliably, assuming your objects and fields are available at API v21.
0/9000