Generate XML file

[Lucas.]

Hi!
I’m looking for the best way to create XML files in Pabbly.
The goal is to create an UBL File (XML) with invoice data that comes from an SQL import (Prestashop). I need them to be saved on Dropbox.

I have the data from Prestashop in Pabbly trough SQL but I don’t see how I can create an XML file and save it on dropbox.
Any suggestions or workarounds?

I have a basic xml template and variabels of the data input will change/map data.
Thanks for helping.

 

[Pabblymember11]

Hey @Lucas.

We looked over your concern and it seems like it is not possible to create XML file on the platform.

 

[Lucas.]

Hey @Lucas.

We looked over your concern and it seems like it is not possible to create XML file on the platform.

Hi!
Thanks for your fast reply!
I made a feature request, hope you guys can add the feature.

In the meanwhile, I think I found a solution with the onedrive app, I make a txt file and rename it to xml. Then I’ll make a new automation to transfeer from onedrive to Dropbox. I’ll post the results here for other interested people.

 

[Lucas.]

Hi, anyone interested in exporting to XML, please upvote https://pabbly.hellonext.co/p/create-xml-file-to-later-on-send-to-dropbox-or-onedrive
I tried many things but it does seem impossible for now to generate XML files.
Hope the Pabbly team can implement soon. Many ERP, Invoices etc are compatible with XML.. Could save me lot's of time
Lucas

 

[Lucas.]

UPDATE: I did manage with Google Drive.

1. create xml file in Google Drive
2. Connect pabbly with GD
3. action event: copy a file
4. rename file
5. new step: GD Update content in a File
6. Done!

It's a workaround, I'll have to move the files from Google Drive to Onedrive what gives me a extra task but it does work.