Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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.