Likely a basic javascript question but trying to understand how to handle in a single mapper. I receive a date from a vendor file in UTC time but not UTC format. Expression below works fine except during daylight saving time where you will receive Na...
hi we have a requirement to receive a file in snaplogic where we have to provide API URL to an external team. that team will do REST post along with file attached in POST request. we are supposed receive the file and store it. we tried a number of wa...
Hi, Pipe Line Summary :- I have a Parent pipeline which will browse the sftp location and pass the file information to the child pipe line. The child pipeline will read these files and generate the XML and then using the rest call these XML’s will be...
Hey,How can I adjust the following Service URL so that it extracts all available records? By default, Coupa API only allows 50 records, this is why I need to implement pagination. "https://XYZ.coupahost.com/api/invoices?offset=100&created-at[gt_or_eq...
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
