Recent Discussions
Google Sheets Subscribe questions
Hello all, I'm trying to use the Google Sheets Subscribe snap, and either I misconfigured something, or my expectations about the results are wrong. I can subscribe successfully to a Google Sheet, and my expectation is to get a call sent to my triggered task with the changes that were made by users in the Google Sheet document. After my test, I saw only empty messages sent to my triggered task, so it seems like I'm only receiving a "ping" when there is a change in the document. Is this expected, or am I supposed to get a summary of the change? Also I'm wondering why there is an expiration for the Google Sheet subscription? How am I supposed to do if I want to monitor the document permanently? Thanks! JFjfpelletier11 days agoContributor84Views0likes0CommentsBasic string transformations not working
Hi Team, I observed that basic string transformations are not working, few of the scenarios have been listed below: Trimming spaces from the text Changing the text from uppercase to lowercase and vice-versa I have used both the mapper and conditional snap however haven’t found any luck to it. Examples for the above-listed scenario: (1) Text is Darsh and if I put the transformation to change this to uppercase, it should return DARSH however the end result remains as is (2) Text is " Darsh", after using trim(), trimLeft(), trimRight(), the expected result should be “Darsh” however the end result doesn’t change. Any help on this would be highly appreciated. Regards, DarshSolveddarshthakkar27 days agoValued Contributor3.3KViews0likes4CommentsCan we generate XML file in pretty print format using native snapLogic snaps?
Hi Team, I was curious to know if anybody has worked on a use case where they are generating an XML file in pretty print format? We do have "pretty-print" option in JSON formatter however the same is not available in XML formatter snap. Any suggestions? Thanking in advance. Best Regards, DarshSolveddarshthakkar27 days agoValued Contributor652Views0likes2CommentsMultipart Reader failure - 'content-type' was not found
Hello all, I'm successfully using Postman to submit a file and payload to a SnapLogic triggered task using the Multipart Reader snap, however when I try the same using Python, I'm getting an error like this one: { "failure" : "Pipeline execution failed while waiting for output", "reason" : "Snap errors: {ruuid=653b762b58a6244b73fecf7a_1388887b-924e-4356-b1e6-b05868cf03bf, reason='content-type' was not found while evaluating the sub-expression '$['content-type']', label=Binary Router, resolution=Check the spelling of the property or, if the property is optional, use the get() method (e.g. $.get('content-type')), failure=$['content-type'] is undefined. Perhaps you meant: 'Content-Type', 'Content-Length', 'Connection', 'CONTENT_TYPE'}", "resolution" : "Fix the reported errors" } The Python sample was generated by Postman and didn't include any 'Content-Type' defined: import requests url = "https://MyURL.com?bearer_token=abc123" payload = {'fileName': 'fileName.jpg'} files=[ ('file',('file.png',open('file.png','rb'),'image/png')) ] headers = {} response = requests.request("POST", url, headers=headers, data=payload, files=files) print(response.text) I added the 'content-type' in the headers like below, but it doesn't change anything, I'm getting the same error. import requests url = "https://MyURL?bearer_token=abc123" payload = {'fileName': 'fileName.jpg'} files=[ ('file',('file.png',open('file.png','rb'),'image/png')) ] headers = { 'Content-Type' : 'image/png' } response = requests.request("POST", url, headers=headers, data=payload, files=files) print(response.text) I'm using the Multipart Reader snap the default values. Does anyone know how to resolve this issue? Thanks in advance for any help! Kind regards, JFSolvedjfpelletier28 days agoContributor657Views0likes5CommentsUnable to write sldb file to file system
Hi, We are currently having a use case where we are writing data into Kafka. We have observed intermittent failures with the error description -"Unable to write sldb file to file system". Upon inspecting our logs, we can see that there is a Stalled Snap Thread warning prior to the failure message. Has anyone encountered such scenarios in your integrations?pra_rama29 days agoNew Contributor531Views0likes3CommentsHow to Safely Append New Blackout Datetime to Pipeline Schedule Without Overwriting Existing Ones?
Hi community, I’d like to ask how I can set blackout dates for a specific pipeline. Recently, the blackout date format changed — now it’s possible to specify not only the date but also the time. According to the metadata, the blackout date fields are: jsonPath($, "$schedule.repeat.blackout_datetimes[*].startDate") and jsonPath($, "$schedule.repeat.blackout_datetimes[*].endDate") My questions are: How can I add a new blackout datetime if no blackout is currently defined (i.e. the fields don't exist yet, and concat fails)? When a blackout already exists, adding a new one overwrites the existing start and end date/time. I’m looking for a universal approach to append one new blackout datetime (start + end) to the list — without creating duplicates, and whether or not blackout dates already exist. Thank you very much in advance!SL123452 months agoNew Contributor III441Views0likes2CommentsHTTP Snap Query parameters issue
So, I have a strange issue with the HTTP snap that I have huge trouble solving. When validating the pipeline I get an error saying query param is not allowed for every query parameter provided in the query parameter fields. But when I copy the request string from HTTP Snap debug and paste it into Postman, the request works as expected. I've tested it both using query parameter fields and by manually mapping the URI with encoded values where appropriate. The request string from debug looks like this (Identifiers have been replaced with *****): /rest/organizationalEntityShareStatistics?q=organizationalEntity&organizationalEntity=urn%3Ali%3Aorganization%3A********&timeIntervals.timeGranularityType=DAY&timeIntervals.timeRange.start=1715844351774&timeIntervals.timeRange.end=1747380351774&ugcPosts[0]=urn%3Ali%3AugcPost%3A***************&ugcPosts[1]=urn%3Ali%3AugcPost%3A**************&ugcPosts[2]=urn%3Ali%3AugcPost%3A**************&ugcPosts[3]=urn%3Ali%3AugcPost%3A************** Does anyone have a clue what the issue may be or what I should do to troubleshoot it further? Thanks!267Views0likes1CommentIs there a way I can delete a folder and all files and subfolders from a windows server?
When an employee leaves, their personal folder and any subfolders and files they have created needs to be deleted. I know I can delete an empty directory, but how can i find/delete all the files and subfolders they've created?Solvedwpenfold2 months agoContributor3.6KViews0likes5CommentsJoin Snap Left Path reading from right input view.
I am facing a weird problem with the Join snap. It looks like the path I provide in the Left Path property is reading documents from the Right input view even though the right input view is correctly set to input1. Similarly, the path I use on the Right Path property first reads the documents from the right input view and then starts reading them from the left input view. Any help is much appreciated. Let me know if you need more details.vgautam642 months agoNew Contributor III3.3KViews1like7CommentsHow can I pop the last element from one array and append it to another?
Hello, I’m working with this JSON structure: [ { "field_a": "string", "entries": [{}, {}, {}], "shared": [] } ] I need to remove only the last object from the entries array and append it to the shared array, leaving the other entries intact. What’s the most straightforward way to accomplish this? Thank you for your help. Kind regards, AdamSolvedadam_gataev2 months agoNew Contributor II499Views0likes2Comments