craig_williams
New Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
How to convert local date time to UTC
Hi there I’m pulling a date time value from SQL Server which is brought into Snaplogic as an local date time object like so {_snaptype_localdatetime:2019-11-13T06:04:41.424} this happens to be New York eastern time zone I want to now convert this to a UTC date time. {_snaptype_datetime:2019-11-13T11:04:41.424 UTC} Time has been adjusted by 5 hours, but during day light savings period would need to adjust by 4 hours. I’m struggling how to do this in a Snaplogic expression. All the functions seem to require that the date be an UTC date object. I could do this with a toString and then Date.parse, but this will be an exact UTC variation of the local date time. {_snaptype_datetime:2019-11-13T06:04:41.424 UTC} Not the {_snaptype_datetime:2019-11-13T11:04:41.424 UTC} that I want to see. I can’t just add 5 hours as it isn’t always 5 hours difference during daylight savings. I feel like this should be simple and I’m sorry in advance if I’m missing something obvious. Thanks!5.1KViews0likes1CommentREST POST a file to box.com
Hi, I’m trying to do a multi-part form REST Post to box.com upload API which requires a file and an attributes part. We’re getting an error indicating that the parent parameter can’t be found. Parent is essentially the folder id in Box. The box API says the call would be sent like so: curl https://upload.box.com/api/2.0/files/content -H “Authorization: Bearer ACCESS_TOKEN” -X POST -F attributes=‘{“name”:“tigers.jpeg”, “parent”:{“id”:“11446498”}}’ -F file=@myfile.jpg Here’s the sample pipeline Box REST POST_2018_08_29.slp (8.6 KB) In this iteration I’m creating the attributes as an expression and passing it into the HTTP entity element in the REST POST Snap. I’m not sure how else to pass these attributes data elements to the REST POST call. I feel like I’ve tried everything but box.com doesn’t seem to see the parent attribute which is necessary for the call to succeed. Admittedly, I’m a bit new to using the REST snaps, but hoping someone could throw out some ideas to try. Thank you! Craig5.4KViews2likes5Comments