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.
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.
Mapper, create xml with both attribute and node value, or multiple attributes
I’m using a mapper to create values for an XML Formatter snap, but I can’t figure out how to handle when the XML requires both an attribute and a node value, or multiple attributes, like: <address_type desc=“Work”>work</address_type> How can I get the format I need?
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:-Posting xml to webservice via rest post snap
Hi All, There is a requirement to post xml to a webservice , the input for the pipeline is xml and need to pass this xml as it is to webservice. I am using xml formatter and binary to document and trying to post via rest post snap to webservice but somehow am receiving 400 error everytime. The same xml when we are trying to post via postman , it is getting posted successfully to webservice. Below are the screenshots of pipeline: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.
XML Parsing To Get Values
Hello I am receiving some XML in the following structure/format and want SnapLogic to convert each row to a document with the attributes as the value. So here is the sample of the XML coming in from a DB query where it is stored: When I tag on the XML Formatter and Parser it doesn’t seem to break it down for me with the retrievable values: