Export XML files from Salesforce

  • 132Views
  • Last Post 25 February 2020
0
votes
Jens Leweling posted this 06 December 2019

Is it possible to export XML files from a Salesforce object using Skyvia? 

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 06 December 2019

Hello Jens,

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.

0
votes
Jens Leweling posted this 11 February 2020

Hello Dmitriy,

I'm still looking for a solution to automatically export XML files from Salesforce. Is that a feature Skyvia would be interested in supporting?

 

 

0
votes
Dmitriy Muzurov posted this 12 February 2020

Dear Jens,

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.

0
votes
Jens Leweling posted this 17 February 2020

Hello Dmitriy,

 

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?

 

Thanks

Jens

 

 

 

0
votes
Dmitriy Muzurov posted this 18 February 2020

Hi Jens,

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.

0
votes
Ken Banks posted this 25 February 2020

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. 

Close