CSV to Salesforce custom object

[Anonymous]

Hi there

I'm new to TOS and the world of ETL and data integration, I've worked with python directly but I'm having a few issues using TOS to try and populate a custom Salesforce object with some CSV data, here's my pipeline.

The error 

I don't understand why it's asking for Development__c it is not a required field as I can update the record manually in SF without an issue.

My mapping is setup as below

Mortgage_Provider contains the same unique reference number as appears in Unique_Reference_C in Salesforce, so I've made these both the key field as this is what joins the .CSV data and the Salesforce data together.

The data in the field 'Property_Type' from the .CSV file should then populate the 'PH_Lets_Status_c' field in Salesforce but I just get the above error.

The Salesforce output is configured for the correct object too, so I'm a little lost.

Thanks for you help

[manodwhb · Accepted solution]

@arronvoce, as per your error you need to pass some value for Development__c in that custom object and it is a mandatory field in that object.