There are two special operators related to data types in SnapLogic. These operators are typeof and instanceof. The names look like the operators in JavaScript but they don't work like in Javascript. const a = new String("Hello world"); const b = Stri...
Hi Experts,Use-case: Extract AWS SQS Queues on real-time basis and transfer it to SAP system using API. In order to minimize data-loss, the "Auto-acknowledge" should be disabled in Consumer Snap and AWS Acknowledge is to be used after transferring th...
Hey Folks, Can some one help me to write .jpeg,.png,.docx.xlsx extensions
Hello everyone.I'm using the Exchange Online Read Email snap to parse the content of the message, and process the attached files according to rules defined in the message.The Read Email has 2 output views, one for the attachments and the other for th...
In a mapper, we need to convert all keys of a JSON file at every level to lowercase. Example:{"Id":"600b31dadece310027cdf492","User":{"Id":"5cbf7330263cd09f9445bd90","displayName":"coyote","impersonatedBy":"ldap:123456"}}In this case, we would want t...
Greetings.I'm attempting to perform some operations against a MySQL 8.0.33 server. I created a SnapLogic MySQL database account, and uploaded mysql-connector-j-8.0.33.jar to the JDBC driver property of the account configuration popup. Pressing the v...
How can I trim the date on the left hand side and convert this into a date value?Input Example: 18 May 2016 - 17 Mar 2017Output example: 2016-05-18(using the yyyy-MM-dd format)I've tried using trimLeft() function but the Mapper Snap doesn't recognis...
Hello,I have designed this pipeline that:Generate a month range as $date_1 and $date_2These variables are inserted into a SQL statement in the "Snowflake - Execute" pipeThen this is inserted into SSMSI want the filled SQL statement with the variables...
| User | Count |
|---|---|
| 320 | |
| 216 | |
| 177 | |
| 152 | |
| 115 |
