ContributionsMost RecentMost LikesSolutionsRe: Microsoft Office 365 Snaps? eric.sou: Does anyone know if Snap Logic is providing some Office 365 snap packs We do not have a native Snap Pack for Office 365. Currently, the way to integrate with the said application is to use the Generic REST Snap Pack as long as Microsoft have exposed the REST APIs for the endpoints you are looking for (as an example, here’s a link to the what is documented as available: Office 365 Management APIs overview | Microsoft Docs) Re: Unable to execute stored procedure (Redshift) using Redshift Execute Redshift stored procedure is not something that is supported today as part of the Redshift Snap Pack. We have an enhancement request filed for this, for future consideration. It will be great if you could share additional information around your use case. Re: Notifications on Upcoming Limit Thresholds for API Usage Sombit: Is there a provision to set up a warning notification about a possible reaching threshold limits on daily API Usage You can setup alerts for tracking Daily API Usage and Concurrent API usage. Please refer to this documentation page for details: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/118652941/Alerts+Activity+Log+Notifications Re: How to call Python script having pandas library in snaplogic sys.path.append() can be used to import external jars (Java / Jython) to a script that you may have in place. Steps: Place a copy of the package / .jar file that you intend to use as part of the script in a directory on the Groundplex node (say under: /opt/snaplogic/<DIR_FOR_EXT_JARS>/…) If you have multiple node(s) dedicated to run the SnapLogic service, repeat Step (1) for all nodes Update your script in the “Script” snap to import the external library as follows: import sys . . sys.path.append(’/opt/snaplogic/<DIR_FOR_EXT_JARS>/sample.jar’) . . Note: The above method would work only for a “Script” snap based pipeline execution(s) done on Groundplex node(s). Re: Support for gson The JAR files can be loaded into a location that can be accessed by the SnapLogic (JCC) process. As an example, assets kept under /opt/snaplogic/… can be accessed/read by the JCC process by default. Jira Snap Pack: Important changes to Jira Cloud APIs We are reaching out proactively to notify customers to make the changes noted below by June 3, 2019 to avoid any interruptions to their Jira integrations powered by SnapLogic. Atlassian has introduced support for API tokens on all Atlassian Cloud sites, replacing Atlassian account passwords for all Jira APIs. If you are using a REST endpoint in Jira with basic authentication, you will need to update your SnapLogic Jira integrations to use an API token by June 3, 2019. This would be a two-part change for SnapLogic organization administrators to make: Part I: API token creation Navigate to your Atlassian Cloud application to create an API token Detailed documentation for API token creation can be found here: Manage API tokens for your Atlassian account | Atlassian Support Part II: SnapLogic Jira Account Update Once the API token has been created, navigate to the Jira basic authentication account used in your SnapLogic integrations Populate the API token generated in the previous step as the Password property on the account Please contact us directly if you have questions about this note at: support@snaplogic.com Thank you! SnapLogic Product Team Re: Support for gson Running a script, that leverages Java / Jython libraries is only an option if your organization runs a Groundplex and is not an option on a Cloudplex. Re: Support for gson jaspal.singh: Is there an option, so that we can refer the jar from sldb rather than keeping it on the groundplex ? To work with Java (or) Jython based libraries, it is a mandatory requirement for the jar files to be loaded to every Groundplex node (JCC) before referencing them from the Script Snap. SnapLogic May 2019 (4.17) Release The first deployment to UAT of SnapLogic Intelligent Integration Platform: May 2019 (4.17) release is now complete. The release is currently scheduled for deployment to production on Saturday, May 11th, 2019 at 9:00 PM PT/Sunday, May 12th at 4:00 AM GMT. Join our product team for a live UAT webinar on Thursday, April 25th at 9:00 AM PT/4:00 PM GMT as we walk through new features and enhancements. Please register here. May 2019 (4.17) Release Details: SnapLogic API Management The API Management layer has been enhanced to handle at-scale management of APIs (Triggered tasks) configured to run on a Groundplex Support for OAuth2 authentication flow for APIs being managed through the API Management layer Platform Enhancements Snap Disable functionality provides a way to disable a Snap and downstream segments to that Snap for additional flexibility in building and troubleshooting pipelines User alerts and notifications have now been enhanced to support CPU and memory alerting Performance Updates have been made to improve local ground triggered executions. Updates also provide improved distribution of executions across nodes for better performance Snap Enhancements Enhanced Snaps Binary Snap Pack enhancement The Binary Snap Pack now supports connectivity to SMB servers that may be running versions: v1.0, v2.0 and v3.0 Workday Prism Analytics Snap Pack enhancement The Workday Prism Bulk Load Snap now supports append operation while loading data to an existing dataset Confluent Kafka Snap Pack enhancement The Confluent Kafka Snap Pack now supports connectivity to Confluent platform v5.x Hadoop Snap Pack enhancement The Hadoop Snap Pack has been enhanced to support connectivity to Microsoft ADLS Gen2 datastore The Hadoop Snap Pack has been certified to support: Cloudera CDH 5.16 Cloudera CDH 6.1 SnapLogic Data Science Enhancements Profile Output Visualization: View profile output in graphical format ML Core Snap Pack - Clustering Snap: Perform exploratory data analysis to find hidden patterns or groupings in data ML Data Preparation Snap Pack - Match Snap: Identify matched records across datasets that do not have a common key field ML Data Preparation Snap Pack - Feature Synthesis: Automatically create features out of multiple datasets that share a one-to-one or one-to-many relationship with each other Auto-ML Improvements: HTML based leaderboard reporting, ability to feed best-so-far model for continuous learning More info can be found in release notes: here The release schedule is planned as follows: Friday, April 19, 11:00 AM PT Release to UAT Thursday, April 25, 9:00 AM PT Register for UAT Webinar (ask for access to the recorded versions) Friday, April 26, 11:00 AM PT UAT Update #1 Friday, May 3, 11:00 AM PT UAT Update #2 Saturday, May 11, 9:00 PM PT 4.17 release to production (Up to 2-hour planned downtime) Wednesday, May 15, 5:00 PM PT Register for Customer Webinar - I (ask for access to the recorded versions) Thursday, May 16, 9:00 AM PT Register for Customer Webinar - II (ask for access to the recorded versions) Saturday, June 15, 9:00 PM PT Update of remaining Snaplexes to 4.17 How do I learn more? Register for any of the webcasts scheduled on: April 25th and May 15th / May 16th. Be sure to join in the conversation in the SnapLogic Community. Lastly, contact us directly if you have questions about the release at support@snaplogic.com. Thank you! SnapLogic Product Team Re: Do we have Pagination and items per page feature Snap As a way of designing your pipelines, this should be possible. You can define pipeline parameters and as an example, one of the parameters could be number of pages to retrieve data from. Value for this parameter can be passed at time of invoking the pipeline (through the task URL) which can then be used as part of the Rest Get Snap.