ppankaj88
New Contributor II
Joined 6 years ago
User Profile
User Widgets
Contributions
Seclore 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, Pankaj2.8KViews0likes1CommentUnable 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,3.6KViews0likes2CommentsDescribe 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, Pankaj2.7KViews0likes1CommentReplace "@" 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, Pankaj3.9KViews0likes3CommentsSelect 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 =Solved3.1KViews0likes2CommentsRead 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…!!1.3KViews1like0CommentsIssue 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)4.2KViews0likes3Comments