Excel columns to xml using paticular xsd
Hi All,
I had parsed the excel sheets which is required and got the columns and rows need to convert to xml with xsd as shown below
B & C are columns of one excel sheet after parsin...
Forum Discussion
Hi @alchemiz ,
Thank you very much for the response. I still couldn’t understand how I could download the CSV file. Could you please let me know the snap that I could use to download the CSV file once I make the REST API call “/bulk/v1/leads/export/{exportID}/file.json”?
“file.json” REST API call returns a CSV file as per Marketo documentation.
In the REST GET snap, set the response entity type to BINARY
This will output the entity as byte array, before you can write/download the file you need to map the $entity to $content… I use a mapper where output is set to binary the connected to a file writer snap
PIMData.txt (1.8 KB)
hi @bojanvelevski i was trying to frame that structure will share the sample input and xsd pls could u help pls
samplerecords.json (262 Bytes)
Please convert PIMData.txt to PIMData.xsd as the template is in that format
Please also find output expected xml in txt format
outputxml.txt (3.2 KB)Hi rashmi,
Good day, instead of using an xml generator snap have you tried the xml formatter? I don’t know if this is your required output but xml formatter accepts an outgoing format as XSD
XML output using PIMData.xsd
Updates:
,
I’m not that familliar with XSD so I manipulate the sample input using a mapper snap, attached poc pipeline
canvas 15_2022_12_03.slp (16.8 KB)
Thanks,
EmEm
