https://community.qlik.com/t5/Qlik-Automate/Insert-Bulk-to-Snowflake-via-Raw-API-Request/m-p/2464672#M4187 <P>As the native Snowflake connector only supports Basic Authentication, I was attempting to re-create the functionality of the Insert Bulk block for the native connector with in the Oauth2 Raw API Request block.</P> <P><BR />Can anyone provide some insight on how that Insert Bulk block transforms a list of JSON objects into a SQL statement?</P> <P>&nbsp;</P> <P>Currently, I have something like this but I keep ending up with a syntax error.&nbsp;</P> <P data-pm-slice="0 0 []">INSERT INTO &lt;TABLE&gt; ({implode: { getkeys: {$.vList} }}) values {implode: {$.vList2}};</P> <P data-pm-slice="0 0 []">vList2 is a variable set by looping over the values in the original vList variable being imploded so I can group the values for each record.</P> <P data-pm-slice="0 0 []">&nbsp;</P> Fri, 21 Jun 2024 19:21:53 GMT Jareds 2024-06-21T19:21:53Z https://community.qlik.com/t5/Qlik-Automate/Insert-Bulk-to-Snowflake-via-Raw-API-Request/m-p/2464672#M4187 <P>As the native Snowflake connector only supports Basic Authentication, I was attempting to re-create the functionality of the Insert Bulk block for the native connector with in the Oauth2 Raw API Request block.</P> <P><BR />Can anyone provide some insight on how that Insert Bulk block transforms a list of JSON objects into a SQL statement?</P> <P>&nbsp;</P> <P>Currently, I have something like this but I keep ending up with a syntax error.&nbsp;</P> <P data-pm-slice="0 0 []">INSERT INTO &lt;TABLE&gt; ({implode: { getkeys: {$.vList} }}) values {implode: {$.vList2}};</P> <P data-pm-slice="0 0 []">vList2 is a variable set by looping over the values in the original vList variable being imploded so I can group the values for each record.</P> <P data-pm-slice="0 0 []">&nbsp;</P> Fri, 21 Jun 2024 19:21:53 GMT https://community.qlik.com/t5/Qlik-Automate/Insert-Bulk-to-Snowflake-via-Raw-API-Request/m-p/2464672#M4187 Jareds 2024-06-21T19:21:53Z