Recent Discussions
sequence month of dates
Hi Team, I have a requirement where We will pass a input value as date and we need the output with the sequence of month of year till date.now() For example: we will pass start_date like 2021-01-01 , So the output I just need is And the last row will be start_date = 2024-03-01 and end_date = 2024-03-27(it means today's date) and it should cover feb month date also Can anyone help me in this to create a parent and child pipeline Thanks in advance its very urgent requirement. koryknick SpiroTaleski tstackSolvedmohit_jain2 years agoNew Contributor III2.7KViews0likes2CommentsFlatten JSON files into CSV files
Created by @schelluri The pipeline pattern flattens a JSON file, which has multiple objects, and turns it into a CSV file. Configuration Sources: JSON Generator Targets: CSV file Snaps used: JSON Generator, JSON Formatter, JSON Parser, Script, CSV Formatter, File Writer Downloads MS_Flatten_Script.slp (31.4 KB)7.4KViews1like2CommentsSnapLogic Patterns Catalog Terms of Use
The SnapLogic Patterns Catalog is a library to find and share SnapLogic sample pipeline patterns with other members of the SnapLogic Community. Participation in the SnapLogic Patterns Catalog is free for subscribers to the SnapLogic Services. The SnapLogic Patterns Catalog is most valuable when community members follow certain basic guidelines and rules of conduct. The SnapLogic Patterns Catalog Terms of Use, SnapLogic Community Terms of Service, SnapLogic’s Privacy Policy, and the terms listed below (collectively the “Terms of Service”) govern your use of the SnapLogic Patterns Catalog and detail what is expected of you and what you can expect from other participants when using the SnapLogic Patterns Catalog. These terms are not exhaustive and SnapLogic reserves the right to modify them at any time, effective upon posting. By registering as a user or using SnapLogic Patterns Catalog, you agree to abide by these terms. Content on the SnapLogic Patterns Catalog are NOT official SnapLogic products as described at http://www.snaplogic.com/. SnapLogic is not responsible for any transmission, collection, disclosure, modification, use or deletion of your data by or through third-party applications or processes or their providers. 1. SnapLogic Patterns Catalog Consumers If you use or consume any content from the SnapLogic Patterns Catalog, your license to use the content is made subject to the “Responsibility of Contributors” section contained in the SnapLogic Community Terms of Service. Your license to use the content on the SnapLogic Patterns Catalog is non-sublicensable and does not include the right to redistribute content. Nothing herein shall give a user of the SnapLogic Patterns Catalog the right to redistribute applications or processes received through the SnapLogic Patterns Catalog. Your license to consume content is also made subject to the “Responsibility of Contributors” section contained in the SnapLogic Community Terms of Service. 2. Content Provider License Grant If you provide or submit content to the SnapLogic Patterns Catalog, you grant to SnapLogic and everyone who downloads or receives such content from this SnapLogic Patterns Catalog a worldwide, perpetual, irrevocable, non-exclusive fully-paid up and royalty free license to use any ideas, expression of ideas or other materials you submit to SnapLogic Patterns Catalog without restrictions of any kind and without any payment or other consideration of any kind, or permission or notification, to you or any third party. The license shall include, without limitation, the irrevocable right for SnapLogic to reproduce, prepare derivative works, combine with other works, alter, translate, distribute copies, display, perform, license the content, and all rights therein, in the name of SnapLogic, or its designees, in perpetuity in any and all media now or hereafter known. The license shall also permit SnapLogic and its designees to provide the content to third parties; to make, have made, offer to sell, sell, lease, or otherwise distribute any content or media; to practice any method embodying such content (including the right to sublicense any of the foregoing; and use portions of the content you submit, rewrite any content you submit, and/or incorporate other content, either created by SnapLogic and its designees or licensed from third parties, with the content you submit. Any such works shall be deemed materials owned by SnapLogic and shall not be subject to your approval or payment by SnapLogic of any compensation to you. You represent and warrant that the content you submit: (i) are original with you and accurate, and (ii) do not violate and will not violate the rights of any third party or any local, state, national or foreign law, including export controls, any right of publicity, right of privacy or any other proprietary right. You acknowledge and agree that the relationship between you and SnapLogic is not a confidential, fiduciary, or other special relationship. We shall have the right, but not the obligation, to use your name, likeness, biography and other information about you in connection with any use of the content you submit. By making a submission, you acknowledge and agree that SnapLogic and its designees may create on their own or obtain many submissions that may be similar or identical to the content you submit through SnapLogic Patterns Catalog or other channels and means. You hereby waive any and all claims you may have had, may have, and/or may have in the future, that the content accepted, reviewed and/or used by SnapLogic Patterns Catalog and its designees may be similar to your content. Your license to contribute content is also made subject to the “Responsibility of Contributors” section contained in the SnapLogic Community Terms of Service. 3. Content on the SnapLogic Patterns Catalog By participating in SnapLogic Patterns Catalog, including the posting of content and commentary, you represent and warrant that you will not upload, post, or otherwise transmit any content (including text, links, communications, software, images, sounds, data, or other information) that violates the SnapLogic Community Terms of Service. Use of SnapLogic Patterns Catalog is limited to participants age 18 and of majority in the state of primary residence. It is not consistent with the permissible uses outlined by the Terms of Service to (i) provide any non-public information about SnapLogic or any other company or person without the proper authorization to do so, including providing the names, addresses and extension numbers of SnapLogic employees and SnapLogic Patterns Catalog participants; (ii) impersonate any person or entity, including a SnapLogic employee, or forge any TCP-IP packet header, e-mail header or any part of a message header, provided this prohibition does not include the use of aliases or anonymous remailers; (iii) attack or insult another SnapLogic Patterns Catalog user or site manager; (iv) suggest or encourage illegal activity. SnapLogic does not want to receive confidential information from you through or in connection with the SnapLogic Patterns Catalog. Notwithstanding anything that you may note or state in connection with your use of the SnapLogic Patterns Catalog, information and content you provide to the SnapLogic Patterns Catalog shall be not considered confidential information and shall be received and treated by SnapLogic on a non-confidential and unrestricted basis and SnapLogic shall not take and shall not be required to take any steps to safeguard the confidentiality of any information that you share, other than as specified in SnapLogic’s Privacy Policy. The SnapLogic Patterns Catalog may allow users to post hypertext links to content hosted and maintained by third parties. Links are subject to treatment like any other type of content posted to SnapLogic Patterns Catalog. You may not include a link that directs users to any content or information that, if posted in SnapLogic Patterns Community, would constitute a violation of these Terms of Service or that links to a SnapLogic competitor’s website. The linked sites and content are not moderated by SnapLogic, are not under SnapLogic’s control, responsibility or endorsement and your access to any linked site is at your own risk. When leaving SnapLogic Patterns Catalog using any link provided by a user, you should be aware that SnapLogic’s terms and policies no longer govern, and you should review the terms and policies, including privacy and data gathering practices, of that particular site. 4. Disclaimer of Warranties The Website is provided “as is”. SnapLogic and its suppliers and licensors hereby disclaim all warranties of any kind, express or implied, including, without limitation, the warranties of merchantability, fitness for a particular purpose and non-infringement. Neither SnapLogic nor its suppliers and licensors, makes any warranty that the Website will be error free or that access thereto will be continuous or uninterrupted. You understand that you download from, or otherwise obtain content or services through, the Website at your own discretion and risk. 5. Indemnity You agree to indemnify, defend and hold SnapLogic and its subsidiaries, affiliates, and each of their directors, officers, agents, and employees harmless from any claims by third parties, and any related damages, losses or costs (including reasonable attorney fees and costs), arising out of content you submit to or publish on the SnapLogic Patterns Catalog, your use of the SnapLogic Patterns Catalog, your violation of the Terms of Service, or your violation of any rights of a third party. 6. Termination of Use SnapLogic may, in its sole discretion, at any time discontinue providing or limit access to the SnapLogic Patterns Catalog or content provided on or through the SnapLogic Patterns Catalog. You agree that SnapLogic may, in its sole discretion, at any time, terminate or limit your access to, or use of, the SnapLogic Patterns Catalog or any content on the SnapLogic Patterns Catalog. SnapLogic may terminate or limit your access to or use of the SnapLogic Patterns Catalog if SnapLogic determines, in its sole discretion, that you have infringed the copyrights of a third party. You agree that SnapLogic shall not be liable to you or any third-party for any termination or limitation of your access to, or use of, the SnapLogic Patterns Catalog or any content provided on SnapLogic Patterns Catalog, including content that you may have provided. 7. Site Management SnapLogic will monitor and review content contributed to SnapLogic Patterns Catalog by members and reserves the right to choose submitted content to make or not make available in the SnapLogic Patterns Catalog. However, SnapLogic has no obligation nor is responsible for any personal data, intellectual property, trade secrets that are included in the content contributed to the SnapLogic Patterns Catalog by members. SnapLogic may remove content that is confidential or proprietary to a third party without that third party’s permission. SnapLogic Patterns Catalog is not intended as a way for members to get answers from SnapLogic on any issue; it is intended as a means for various SnapLogic users to exchange ideas and propose solutions. Unless the person is authorized to speak on behalf of SnapLogic, the views and statements of SnapLogic employees are theirs alone and do not represent an official company position. The SnapLogic Patterns Catalog is not a substitute for contacting SnapLogic support, for example, for resolution of personal customer services issues. SnapLogic Patterns Catalog consumers and contributors must also follow the SnapLogic Community Terms of Service. 8. Waiver and Severability The failure of SnapLogic to exercise or enforce any rights or provisions in these Terms of Use shall not constitute a waiver of such right or provision. If any part or provision of these Terms of Use is found to be unenforceable, such part or provision may be modified to make the Terms of Use as modified legal and enforceable. The balance of the Terms of Use shall not be affected. 9. Miscellaneous This terms of use constitutes the entire agreement between SnapLogic and you concerning the subject matter hereof, and they may only be modified by a written amendment signed by an authorized executive of SnapLogic, or by the posting by SnapLogic of a revised version. Except to the extent applicable law, if any, provides otherwise, this terms of use, any access to or use of the Website will be governed by the laws of the state of California, U.S.A., excluding its conflict of law provisions, and the proper venue for any disputes arising out of or relating to any of the same will be the state and federal courts located in San Francisco County, California. Except for claims for injunctive or equitable relief or claims regarding intellectual property rights (which may be brought in any competent court without the posting of a bond), any dispute arising under this Agreement shall be finally settled in accordance with the Comprehensive Arbitration Rules of the Judicial Arbitration and Mediation Service, Inc. (“JAMS”) by three arbitrators appointed in accordance with such Rules. The arbitration shall take place in San Francisco, California, in the English language and the arbitral decision may be enforced in any court. The prevailing party in any action or proceeding to enforce this Agreement shall be entitled to costs and attorneys’ fees. If any part of this Agreement is held invalid or unenforceable, that part will be construed to reflect the parties’ original intent, and the remaining portions will remain in full force and effect. A waiver by either party of any term or condition of this Agreement or any breach thereof, in any one instance, will not waive such term or condition or any subsequent breach thereof. You may assign your rights under this Agreement to any party that consents to, and agrees to be bound by, its terms and conditions; SnapLogic may assign its rights under this Agreement without condition. This Agreement will be binding upon and will inure to the benefit of the parties, their successors and permitted assigns.dmiller2 years agoFormer Employee3.6KViews0likes0CommentsAPI Pagination entirely within the entity body json
I have an API I need to call where the pagination is housed entirely within the request entity and not in the URL/parameters. E.g. Page 1 would look like: {"recordsPerPage": 100, "currentPage": 1, "deltaTimestamp": <yesterday>, "startTimestamp": ""} and Page 2 would look like: {"recordsPerPage": 100, "currentPage": 2, "deltaTimestamp": <yesterday>, "startTimestamp": <value returned in page 1 response.metatada.startTimestamp>} The responses include the following metadata: { "metadata": { "currentPage": 1, "lastPage": false, "pageCount": 2, "recordCount": 894, "recordsPerPage": 500 } } Since recursion is supposed to be avoided, I would like to know how to make the subsequent calls using the pagination features if possible.jongrif2 years agoNew Contributor2.2KViews0likes1CommentCSV to Workday Tenant
Submitted by @stodoroska from Interworks This pipeline reads a CSV file, parses the content, then the Workday Write Snap is used to call the web service operation Put_Applicant to write the data into a Workday tenant. Configuration If there is no lookup match in the SQL Server lookup table, we are using MKD as a default code for country code. Sources: CSV file on the File share system Targets: Workday tenant Snaps used: File Reader, CSV Parser, SQL Server - Lookup, Mapper, Union, Workday Write Downloads CSV2Workday.slp (17.3 KB)dmiller3 years agoFormer Employee4.7KViews4likes1CommentAbout the Pipeline Patterns Catalog for IIP category
This section contains a library of sample pipeline patterns created by the SnapLogic team, customers, and partners and available for you within the product. Learn more about using Pipeline Patterns on snaplogic.com. Are there patterns you would like to see? Let us know. We encourage SnapLogic users to submit their pipeline patterns. Submitted pipeline patterns will be reviewed and certified by the SnapLogic team, and will be added to this library for users to download and use. To submit patterns, please fill out the form under the Pattern Submission box. Accessing Patterns There are several ways in which you can access these patterns. In the Community In this section of the Community, you can search for a pattern. When you find one you want, you can download it from the Community and upload it to the SnapLogic Intelligent Integration platform by importing a pipeline. in Designer Within the product, you can find the same set of patterns in Designer under the Patterns tab in the Cloud Pattern Catalog. In Studio (in progress) As part of the new UI known as Studio, we are implementing a new pattern catalog with in product documentation. Let us know what you think!dmiller3 years agoFormer Employee7.7KViews0likes5CommentsMonitor the Health and Performance of Your Integrations
Created by @rsramkoski The following pipeline comes from the Using SnapLogic’s Pipeline Monitoring API video from the blog post 3 tips for working remotely with SnapLogic | SnapLogic Downloads SL_PipelineMonitorAPI.slp (26.4 KB)3.7KViews0likes1CommentDynamic Data Pivot
Created by @dwhite An example of how to perform a dynamic pivot on data that needs to be pivoted. The traditional Pivot Snap is static and has to be configured per set of data (Ex. in pipeline). This pipeline shows how one can perform a pivot operation on data with variable fields that could be sent in at runtime instead, so pivot configuration could be done on the fly during the run. Configuration Configure dynamic pivot via parameter values. Enter the number of fields to split to in “nSplitFields” parameter. Enter the field names that are being split in the “splitFields” Parameter in a comma separated list. Enter new fields to generate in the “genFields” parameter in a comma separated list. For actual use, remove the sample data and traditional Pivot, those are only for demonstration and comparison. Sources: Any flat datasource that needs pivoting Targets: Any Snaps used: CSV Generator, Copy, Pivot, Mapper, Sequence, Join, JSON Splitter, Group by n Downloads Dynamic Data Pivot.slp (15.7 KB)3.3KViews2likes1Comment