CSV to Salesforce Custom Object

Anonymous — Thu, 08 May 2025 17:40:29 GMT

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

Re: CSV to Salesforce Custom Object

TRF — Sat, 20 Jun 2020 05:43:51 GMT

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?

topic CSV to Salesforce Custom Object in Archived Discussions

CSV to Salesforce Custom Object

Re: CSV to Salesforce Custom Object