Hi experts,
I am facing an issue related to custom settings. I have an MS SQL export where I am pulling the data based on the query. I am using handlebars for using the values stored in custom settings in exports and supplying them in the query. However, the handlebars logic seems to be working fine in the query preview mode but during the export preview and integration run it throws an error saying.
error: cannot read property ... of undefined.
I am not sure if there something is required to enable the result in export preview and integration run.
Any help would be highly appreciated!
I don't have access to a MS SQL database, but I tested the ability to use custom settings for Snowflake and PostgreSQL, and they both work fine.
It looks like you are trying to execute multiple query statements in the same export. This is not supported currently. Can you try removing the '{{#each' handlebars, and run just a single query to see if just the very basic ability to inject a custom setting value into a MS SQL query is working? If this does not work, then we will get a bug logged on your behalf.
The work around for running multiple queries is to use multiple bubbles, and then in your case, each bubble can run a different 'time'. I know this is annoying having to duplicate things, and hopefully we will deliver the enhancement to execute multiple query statements in a single bubble soon-ish.
