Forum Discussion

lydarose's avatar
lydarose
New Contributor
8 years ago

Connect to https using file poller

How do I use File poller, or a different snap, to connect to https site? I’ve created the account, then added the path to file poller, however the validation never completes, nor do any errors displa...
davidm's avatar
davidm
New Contributor
6 years ago
Copy LinkReport

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.

Please note: I did try adding JSON Formatter and JSON Parser before loading it to Snowflake. It only worked for Snowflake Insert but instead of VARIANT (JSON) it was looking at JIRA as text.

janph's avatar
janph
New Contributor
6 years ago
Copy LinkReport

have you tried to enable the “Load empty strings” setting in the Snowflake Bulk Load

    • KTsnap's avatar
      KTsnap
      New Contributor III
      4 years ago
      Copy LinkReport

      You mean to give the quotes the way you have given in first comment
      ?