AnsweredAssumed Answered

Adding new columns to Existing dataset using Salesforce analytics connector with upsert mode

Question asked by arqk865338 on Aug 2, 2018

Hi,

 

   We have requirement like need to update the existing dataset with new columns. I have added new columns in JSON meta data and uploaded the CSV data with JSON meta data in upsert mode. I was getting below data integrity error while upserting into dataset

 

"[FIELD_INTEGRITY_EXCEPTION] SALESFORCE_INITIALIZE_ERROR: Failure uploading metadata: Field [Phase] in the input data is not available in the existing dataset [Marketo_0108].: Metadata JSONField [LubricantsUsageType] in the input data is not available in the existing dataset [Marketo_0108].: Metadata JSONField [CurrentBrand] in the input data is not available in the existing dataset [Marketo_0108].: Metadata JSONField [ContactMe] in the input data is not available in the existing dataset [Marketo_0108].: Metadata JSONField [EventType] in the input data is not available in the existing dataset [Marketo_0108]"

 

At  the same time the same process was working fine in Overwrite mode. Is it possible to do the same in upsert mode since Dataset was already in production and we need to add columns with out affecting the existing data

 

Thanks,

Amir.

Outcomes