Is it possible to export XML files from a Salesforce object using Skyvia?
Export XML files from Salesforce
- Last Post 25 February 2020
Thank you for submitting a ticket with us.
Skyvia exports data in CSV format only.
Another variant is PDF, however this can be done in Skyvia Query. Please check this article.
We are looking forward to hearing from you, should you have any further questions.
Thank you for getting back to us.
If you mean to export attachments from Salesforce, Skyvia can do this by exporting ContentVersion object.
All attachments are exported together with a CSV file that contains a list of records in a ZIP archive.
Data export in XML format is not supported, since the same functionality is implemented through CSV.
We are looking forward to hearing from you, should you have any questions.
I got the export of attachments via ContentVersion to work. I still need to unzip the file but I'm sure we'll find a solution.
Is it possible to schedule an export package so that only new attachments, that have not been exported by Skyvia before, are included?
Thank you for your reply.
You need to set up an export package with the filter by CreatedDate field:
The package should be set up to run, for example, on Friday at the end of the business day, if new attachments appear within a business week.
If new attachments appear at the weekend too, we would recommend configuring schedule at the end of the day on Sunday.
More details about schedule can be found here.
Should you have any questions, do not hesitate to contact us back.
You might be able to do this using query if you construct the output as a single field that concatenates the output using strngs to build the tags. I have done this in other software that uses SQL for the basic output. The problem is this is very time consuming and would require a lot of manual building of the output strings.