Hi, How to insert multiple rows at a time into Oracle table within one transaction? Example: Reading 10 lines from CSV/Excel file. Insert 10 lines into Oracle using Oracle insert. When one of the lines throws an error, none of the lines shall be writ...
I’m working on a pipeline that requires delivering a password protected Excel file. How can i set a password to the excel file with Snaplogic?
when we use $.keys() below image which is showing list of columns for all the records which leads to performance issue (for example we have 1 lakh records, it will check for all 1 lakh records) ... Need only first row columns... Please help with expr...
Hi SMEs,Good day, any idea what is the root cause of this error? checked the stored procedure and all fields have alias. Thanks,EmEm
I am unable to set a CSV Formatter snap to use ISO-LATIN-1 character encoding. All other options from the "Character set" drop-down list work without problem, but choosing ISO-LATIN-1 makes the snap fail with the following error:Failure: ISO-LATIN-1,...
I have a data present in CSV file and I have user input parameter.I want to get the complete record that matching with one of the column value in CSV to the input parameter.Like in below screenshot, my input parameter is Role3 and it is matching with...
Hello everyone.How can we configure a pipeline which is called using a triggered task and returns and json payload to have paginated results?The API call to the pipeline currently passes in parameters of which some are used in the call to a database ...
I need to generate timestamps using Script snap for Python. I tried to use datetime and java.sql.Timestamp but Type Inspector recognizes them as java.util.LinkedHashMap and the operator instanceof returns false for DateTime and LocalDateTime. Is it p...
