Celigo Custom Settings working in query preview and not working at the integration run time and export preview

Answered

Chirag2006

• May 05, 2022 19:56

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!

0

• 

  Scott Henderson CTO

  • May 05, 2022 21:53

  

  

  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.

   

  0

Please sign in to leave a comment.