ContributionsMost RecentMost LikesSolutionsSeclore encrypted file processing Hi, I have a file which is encrypted by ‘Seclore’ and now I wanted to read this file data using SnapLogic and write it to text format. To read the data in my local system I have installed ‘Seclore Desktop Client.exe’ software which is decrypting this file locally and I am able to view the data. But not sure how to decrypt this using SnapLogic. Can anyone help here to solve this issue. Thank you in advance! Thanks, Pankaj Unable to pass dynamic schema in parquet writer Hi, I am trying to copy data from oracle database to AWS S3 location in parquet format. And I want parquet schema to be dynamic while writing the data into S3 location. So as per SnapLogic documentation I have added one more input snap and using “DESCRIBE Table_Name” for schema. But it is giving an error. screenshot attached. While seeing this error, it looks like an issue with data but when I am using static schema it is working with the same data but not working with dynamic schema. Can someone help me in this this. Regards, Describe table_name is not working in oracle execute snap Hi, I am trying to execute the sql query “describe table_name” but it is not working in oracle execute snap. Getting an error like " Filed to execute query. Reason: ORA-00900: invalid SQL statement , Resolution: Please check sql query" Any suggestion…? Regards, Pankaj Re: Replace "@" and "#" while converting XML to JSON Replace function is not working, could you please share an example. Replace "@" and "#" while converting XML to JSON Hi All, I am converting XML file to JSON file using XML parser snap and JSON formatter. When I’m converting, prefix “@” is getting added to all the attributes. For example:- In XML → “ProviderPaxRef”: “String” In Converted JSON → “@ProviderPaxRef”: “String” Now I wanted to remove prefix “@” from every element dynamically. Can anyone help me on this. Regards, Pankaj Re: Select column based on column availability Thank you for providing solution…it’s worked for me Select column based on column availability Hi, I am reading multiple json files from source. where column names and column type are varying from file to file. For example: In one file, column name is coming as an array and in another file it is coming without array. But for my use case I don’t need to worry about the column type.I only want data to be stored. Now my question is: I have below two different columns coming from two different file: Col 1: jsonPath($, “$OT.Refs.TripRef[*][‘@BookingRef’]”) Col 2: OT.Refs.TripRef[‘@BookingRef’] I am reading one by one each file and I want to do following thigs: If Col 1 is not coming from file 1 then select Col 2 2- If Col 2 is not coming from file 1 then select Col 1 3- And both should come under one column name For Example: is not available in the file then select then Column name =SolvedRe: Issue on reading multi-level nested XML document christwr: processing Hi, Is it possible to share sample code which I can use while parsing. Thanks, Pankaj Read column name dynamically Hello, I am looking for a solution to read column dynamically from input. For Example: Step 1: I am using oracle execute snap to pass the schema.tableName to read the data. In this case lets assume my table name is ‘employee’. Step 2: Then I wanted to read the column dynamically from ‘oracle execute snap’ and pass it to next snap. Step 3: If I change my table name from ‘employee’ to ‘department’ then I don’t need to reconfigure any other snap. I need dynamic schema. I don’t want to use mapper because that will fix the schema. Could anyone help me here please. Thanks in advance…!! Issue on reading multi-level nested XML document Hello Everyone, I have a requirement to read very complex xml document and make it in structure format. And also xml files and information are keep changing. I have attached the file here. It would be good if I anyone would help me with a python code which can get executed in SnapLogic itself thankstext.txt (2.7 KB)