Skip to main content

Create custom settings & access them in integrator.io forms

Comments

6 comments

  • Josh Saterdalen

    Is it possible to use Custom Settings in an Export's SQL query? When I reference a custom setting in a query, then preview the query, I receive the error: "Cannot read property 'xxx' of undefined", where 'xxx' is the name of the Custom Setting.

    1
  • Anthony Rosenkrantz

    Having the exact same issue!! trying to use setting as a schema override (dev/prod) not working

    1
  • Stephen Brandt Documentation Manager Community moderator
    Engaged
    Great Answer
    Top Contributor
    Celigo University Level 3: Master

    Sorry for the delay, Josh Saterdalen and Anthony Rosenkrantz. (I mistook the autonotification on your comments as Community forum requests.) Assuming you haven't done so already, I'm going to submit these questions to our support queue and track the answers as they try to reproduce and then find another solution or escalate to the product team. 

    0
  • Anthony Rosenkrantz

    i put a work around in my flows to get the settings and stash them in the payload. so when i run postgres connectors i have the settings. (not great solution)

    0
  • Shubham Kaila

    How would you go about updating the custom setting after each run? For example, if I set one up as a counter and I want the counter to increase after each successful flow run. How would I do that? Thanks! 

    0
  • Stephen Brandt Documentation Manager Community moderator
    Engaged
    Great Answer
    Top Contributor
    Celigo University Level 3: Master

    Hi, Shubham Kaila. That's a great question, which I'm surprised we haven't seen yet. 

    The official answer is that it's not supported right now. Custom settings are static (read-only). Keeping tally of successful runs is best done through your dashboards/consoles and logs.  

    If you wanted to automate it, perhaps you could increment a value in a custom record or upload a file in an import at the end of your flow. 

    0

Please sign in to leave a comment.