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

[TRF]

You should place this discussion under Design and Development forum.
Anyway, in tMap field Unique_Reference__c is not populating (mapped with a source field). It should be if you want null value in salesforce.
Also, what's the expected operation in tSalesforceOutput component (insert or update)? You've said you can update Development__c field manually but are you able to create a new record without a value for this field?
Finaly, did you remove unused fields from tSalesforceOutput component schema or do you let it as is?