SnapLogic - Integration Nation

shane · 10-09-2019

I need to pull data from an API that needs a timestamp as a parameter. This API retrieves data from a system (not in my control) that is based in the America/Las_Angeles timezone. I have tried for hours to find a way to generate a non-UTC Date obje...

shane · 09-16-2019

Using a Generic JDBC - Execute snap at the beginning of my pipeline with a hard-coded SQL query that has no issues running from any other place (workbench, phpstorm, etc) returns 800 results and an error instead of the full result-set. The error is “...

shane · 09-09-2019

I have 2 single field documents containing string representations of time (Ex: “12:03:43”) that when I use a Join snap with any join type, or when I use a Union, I see that there are items that don’t make it in the join. I have tried various thin...

shane · 08-15-2019

I have multiple data-stores and need to hydrate data pulled from one with data from another. The issue is that if I have two independent staring snaps perform the queries, I would have to pull every item in the table (hundreds of thousands) just to j...

shane · 08-07-2019

I cannot find anything anywhere about how to query a database efficiently. By that I mean if I have a json object with a bunch of id fields, all query snaps (JDBC in my case) seem to query for each item in the object and I cannot find anything on ho...

shane · 10-21-2019

as was gone over above, this doesn’t work

shane · 10-14-2019

So that is the first thing I tried, but it gives me a UTC DateTime object at 00:00:00 for the Date, and calls getTime() on it. You cannot call getTime() without the Date.parse() which turns it into a UTC timezone because toLocalDateString() and toLo...

shane · 10-14-2019

That will get you a date-time string not a timestamp. How do you turn that into a timestamp?

shane · 10-11-2019

Unfortunately that isn’t how timezones work though. I would have to calculate the offset based on the America/Las_Angeles timezone at the given DateTime. Specific example, I need to generate the timestamp for the following date to pass into an API: ...

shane · 10-11-2019

That will give you a date-time string but not a timestamp. Try to create a timestamp from that and that is my issue.

SnapLogic - Integration Nation

User Statistics

Re: Can't create a non-UTC Date object to call .ge...

Re: Can't create a non-UTC Date object to call .ge...

Re: Can't create a non-UTC Date object to call .ge...

Re: Can't create a non-UTC Date object to call .ge...

Re: Can't create a non-UTC Date object to call .ge...

User Activity

Can't create a non-UTC Date object to call .getTime() on

Query Issue - Generic JDBC - Execute

Join/Union missing data

How do I avoid multiple select requests

Query Bloat

Re: Can't create a non-UTC Date object to call .getTime() on

Re: Can't create a non-UTC Date object to call .getTime() on

Re: Can't create a non-UTC Date object to call .getTime() on

Re: Can't create a non-UTC Date object to call .getTime() on

Re: Can't create a non-UTC Date object to call .getTime() on