Removing leading characters
I’m receiving data with 18 characters, which includes 7 leading 0s. Would I use the Mapper to TRIM off the leading 0s? If so how would I go about this? Thank you
I’m receiving data with 18 characters, which includes 7 leading 0s. Would I use the Mapper to TRIM off the leading 0s? If so how would I go about this? Thank you
Hello, I am trying to load transaction data from a REST API end point. The API has pagination as required Input parameter. I am using the REST GET to fetch the data and the Https URL should be as below. https://xxxxxx–xxx/transactions?datestart=2018-...
Can we use azure sql as database type in ELT snappacks I am not getting option to select AZURE sql in account setup getting different options like AZure synapse,snowflake etc. Anyone please if knew the answer
Hi, I’m having a hard time trying to figure out a way to compare a DateTime property (which is stored in UTC) to a point in time i.e. Today midnight (in the current local time zone which is US/Eastern -05:00)… The closest thing came to find is Date.p...
I have a pipeline with a oracle insert snap and a error pipeline. Everything works. When something in the pipeline fails I am passing variables to the error pipeline and storing in a table. I want to pass the current JSON document that failed? W...
If data doesn’t meet a certain criteria (e.g. evaluated through a router snap), we want SnapLogic to do nothing i.e. avoid routing to an error pipeline/no further action required
Hi, I get as JSON input { "amount" : 1000 } I would like to convert 1000 to 1000.00 { "amount" : 1000.00 } How? I do not want to convert to “1000.00” which toFixed(2) does. thank you.
We have an API that’s expecting raw text as the body of the call and I’m not clear on how to get SnapLogic to pass the data as raw unformatted text. If I map my text into $content and then pass that to the API The problem is that when I look at how...
User | Count |
---|---|
321 | |
223 | |
178 | |
153 | |
116 |