SnapLogic - Integration Nation

davidm · 03-17-2021

Hi, I have issue converting an object with array to a format that could be inserted into a table. I have a following dynamic JSON document: “testcode”: { “1203”: [1,2,5,6,8,10,11,12,13,14,16,17], “1205”: [9], “1206”: [7,3,4,15] } Above, testcode is s...

davidm · 01-13-2021

Hi, We are trying to consolidate a list of our pipelines and tasks. Is there a way to download this from Snaplogic? Like from a repository or database? Has anyone done this in the past? Thanks, David

davidm · 04-28-2020

Hi, Been trying to load json data into VARIANT data field in Snowflake. I want to avoid writing externally like an S3 bucket and then doing a bulk upload. I prefer to do it straight load to Snowflake. I’ve tried the following snaps and it keeps faili...

davidm · 03-16-2021

Sure. It is actually the same date in my reply. It only fails because it returns NaN. The weird about it is that I have a similar job running the same way and it does not fail. Date.parse(“2021-03-14 02:40:18.000”,“yyyy-MM-dd HH:mm:ss”+“.000”) - the ...

davidm · 03-15-2021

Date.parse(“2021-03-14 02:40:18.000”,“yyyy-MM-dd HH:mm:ss.SSS”) Use this on my mapper and it worked. However, when I use same approach on my existing snaplogic job coming from a field and it fails. I will just do date manipulation inside SQL as stand...

davidm · 03-15-2021

I have a similar issue. When I use literal string, it works. But using a field, it does not. Additionally, it only happened yesterday 2021-03-14. This fails. This works.

davidm · 12-16-2020

Figure this out. The important thing in using Variant is that you want to store JSON as JSON and not as string. To do this, I basically need to convert Document to Binary and Binary to Document. Strange, but it works.

davidm · 04-30-2020

Please note, I’m going to JIRA Search snap. Using JQL, I am able to return json documents and bulk uploading them to Snowflake using Snowflake Bulk Upload. Format Type: JSON. The table we are loading contains only 1 column that is data type VARIANT....

SnapLogic - Integration Nation

User Statistics

Converting Objects with arrays into row format for...

Re: Problems with Date.parse() function

Re: Problems with Date.parse() function

Re: Problems with Date.parse() function

Download Snaplogic Pipelines and Tasks List

User Activity

Converting Objects with arrays into row format for DB storage

Download Snaplogic Pipelines and Tasks List

Loading JSON to Snowflake

Re: Problems with Date.parse() function

Re: Problems with Date.parse() function

Re: Problems with Date.parse() function

Re: Loading JSON to Snowflake

Re: Loading JSON to Snowflake