[resolved] importing body of salesforce attachment
Hi, I am trying to import and export attachments between two different orgs. When I extract the attachments, the default schema sets Body as type of String, but when I do the insert with the same schema I get the 'Invalid Batch' error. I have verified and the body I get from the attachment is a base 64 string, so why is this happening? It works even if I enter the same string in the workbench form for insert. Any idea on how to import attachments? Thanks
OK, got it. I was using a tSalesforceOutputBulkExec, but a simple tSalesforceOutput solves the problem. The body String does not need to be converted to anything.
OK, got it. I was using a tSalesforceOutputBulkExec, but a simple tSalesforceOutput solves the problem. The body String does not need to be converted to anything.