I am trying to find an automated way to add contacts & leads to existing campaigns by using simple salesforce to upsert records to the CampaignMembers object. I have a CSV file with CampaignId and ContactId. However, I am getting an error that says `"salesforce_bulk.sal
Make sure that you are
You can find
Marketing User checkbox on the User record that you are using to load data. Campaign objects security depends on this permission.
When enabled and the user has Read permission on contacts or the Import permission on Leads, and Edit permission on campaigns, the user can create, edit, and delete campaigns, configure advanced campaign setup, and add campaign members and update their statuses with the Data Import Wizard.
Double verify all the permissions listed here are taken care of.
After an examination, the problem seems to be in the library salesforce-bulk. The library has not been updated in a while and seems like it causes this issue due to invalid headers sent as discussed here.
You can avoid it and use simple-salesforce