Parsing XML Data and formatting it
Hi Team, We have a requirement to parse the xml file (1.5GB) and transform/group the content based on the one of the field value and write write multiple files based on the each group. === Sample Input == <?xml version="1.0" encoding="UTF-8" ?> test test Test1 Test2 Test1 ===== output File 1=== <?xml version="1.0" encoding="UTF-8" ?> test test Test1 Test1 ===== output File 2=== <?xml version="1.0" encoding="UTF-8" ?> test test Test2 I have tried using the xml parser , split based on child and add headers back. Problem here is as it is huge data CPU and memory are going high and getting Connection lost error. Have also tried xslt but still got same issue. Can you please help me to design the solution with memory optimization. Thanks in advance.
How to convert XML data into PDF
Hi all. I have the use case that I need to convert an XML file into PDF, and move it to a DMS (Document Management Systems) for archieving. This means, I can read an electronic invoice (which is mandatory to have in Italy) as an XML from a SQL database and want to convert this to a pdf. I found already a post here, where it says that it is possible to convert an XML to HTML and than to PDF, but i was not able to achive this (See How to Convert JSON data into PDF - Designing Pipelines / Solutions - SnapLogic Community). Did somebody of you already have this use case? Here some infos about electronic invoice in Italy Electronic invoice exchange with FatturaPA in Italy | E-Invoicing (inposia.com)Downloading and Uploading XMLs
I’m working on an integration in which i download a XML from endpoint A then i need to post this xml file to endpoint B, passing it as a file that goes into form-data. How to create the XML file from the response i get from endpoint A? While using Postman, the response is the XML itself, but in Snaplogic the response is a JSON. Is it possible to send a file through Post Snap form-data without first saving it as an XML file?
XML Generator, Entity referenced, but not declared
I’m having trouble using the XML Generator with data that contains special symbols and characters. All the usual suspects (<, >, &, ", ', ) have been taken care of by using the HTML notations <, >, &, etc., but I’m having trouble with others that I feel should work. For instance, the symbol for the registered sign, ®, should be notated as ®, however, the XML generator gives me an error stating that “the entity, reg, is referenced but not delcared.” How do I go about declaring these. I have quite a number of symbols and accented/uumlat’ed letters that I need to use. Whether I use the rendered symbol or the HTML notation, the XML Generator fails. How can I successfully include these symbols in my XML messages so that the XML Generator doesn’t see them as errors? See pics below for examples of my issue.Spaces in URL
I have a URL that generates a bunch of XML when you hit it. At the end of the URL, there are a whole bunch of parameters with spaces in them. For example: ?inputXml=<Envelope version="01.00"> <Sender> When I copy and paste the URL into the REST Get Snap, it doesn’t work. But, if I put the URL in the browser, the browser encodes the spaces ?inputXml=<Envelope%20version="01.00">%20<Sender> And, if I copy and paste that into the REST Get Snap, it works. Is there an easier way to do that?
Need to cover few scenarios in pipeline
Hi, I have a multiple scenario to cover in a pipeline. 1)read an xml, validate the xml , send mail mentioning xml file name that it is not valid. 2)create lookup out of csv file which will have number, name, s1. 3)if xml is valid, check if <V_number> exists in lkp(number). if yes, then transform the xml and name the output file with <V_number>_lkp(name)_timestamp. 4)if <V_number> does not exists in lkp(number) stop the execution and send mail mentioning xml file name. I am able to transform the xml. My current pipeline looks like below:-Create xml segment only if condition is met
Hi, I am trying to convert xm1 into xml2. In order to that I have used XML Parser, Mapper,XML Formatter. There is one logic, I need to create a segment only if value of a particular repeatable segment is either jsonPath($, “$Z_RDGD102.IDOC.DKA1[].PAR") is equal to ‘AF’ or ‘AG’ or ‘PC’. And part of output segment is like below:- jsonPath($, "$Order.Data.Addresses[].Address[*]”) How do I achieve it, please let me know.
