ContributionsMost RecentMost LikesSolutionsLogging from custom java jar in script snap Hi, I have a Java Jar file which has a method inside a class that returns a string value, and I also have a log4j logger inside the method. I placed these 2 jars mycustom.jar and log4j.jar in node path. In script snap (python) I mentioned the path of the jar and importing the class and able to call the method and get the output string successfully. The problem is mycustom.jar is not able to create a log file in the path that I mentioned in the log4j.properties file and append logs to it. Does anybody have idea on this or suggest the cause of the issue? How to import custom class? Importing Third Party Libraries https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439321/Script Thanks, Kiran Re: Global or Public variable Thank you @dimitri.hristovski Yes I had solved this using copy and join snaps. Thanks for you reply. Re: How to Fetch all records while validating snap : In user settings (gear icon) you can change preview doc count field, it is from 50 to 2000 (max) Global or Public variable Hello, I have a requirement of sharing a value in captured in one Snap to the other Snap but not to an immediate following Snap. Ex: Rest GET Snap (getting token)–> Mapper → …other SQL snaps … —> REST PUT snap (I need token here to call PUT) How to share/pass a token variable that I get in first GET Snap to the last PUT snap? Thanks, Kiran Re: Storing each document into database table.. [xmlformatter --> generic jdbc insert] Hi Vish, Basically I would need the XML go into the database. At XML Formatter snap I can see the output of 3 xml data elements. when I use file writer snap next to XMLformatter, I can create an xml file with complete xml data. 3 elements → should go as 3 rows in a table eg: id=1, data=doc1 id=2, data=doc2 id=3, data=doc3 how would i connect xmlformatter to jdbcinsert for each data in xml? Thanks, Kiran Re: Storing each document into database table.. [xmlformatter --> generic jdbc insert] Storing each document into database table.. [xmlformatter --> generic jdbc insert] Hi, i’m getting following error when executing “Generic Jdbc insert” snap. i have 2 data values that need to be inserted in 2 column table. mapper gives me col1, col2 each having list of 3 values. col1 = [a,b,c] and col2 = [{…},{…},{…}] Error: Unable to construct CREATE TABLE statement Resolution: Please provide valid input data. Reason: No column value or value of supported column type in the input view Hide Details… Generic JDBC - Insert[8b34190d-aaef-4b59-9743-ae23ea997132 – 8b07adcd-0232-4ca0-ac49-6041bbf26870] com.snaplogic.snap.api.SnapDataException: Unable to construct CREATE TABLE statement Thanks, Kiran Re: XML Generator snap without XSD Thanks @cstewart @robin I’m able to do it. I have tried XMLFormatter before using Generator but I have not seen the preview of the XMLFormatter. Now when I added FileWriter snap to store the xml file, I see the valid XML file. Thank you, Kiran Re: XML Generator snap without XSD Thank you. As you suggested I replaced the snap XML Generator with XML Formatter in the pipeline as shown below, but I’m not getting any XML output at XMLFormatter except some meta data like content-type etc… but I see JSON data at JSONParser. REST GET → JSON Formatter → JSON Parser → XML Formatter XML Generator snap without XSD Hi, I want to convert JSON to XML and i’m using XML Generator with valid XSD. I got the output XML after running the pipeline for a fixed known JSON format with fixed XSD. If the JSON data is dynamic, Now I don’t know the JSON data format because it is a third party data getting from some REST GET snap request. I cannot define exact XSD in XML Generator snap. Is there a way where the XML Generator generates XML from the dynamic JSON without depending on XSD? Thanks, Kiran