Showing results for 
Search instead for 
Did you mean: 

Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!


Alteryx Certified Partner
Alteryx Certified Partner



I'm looking to create an In-DB macro with the HTML GUI SDK.


I used this post to create the relevant structure and the template macro.


I then opened the macro and converted the macro inputs to In-DB macro inputs. I also went into the macronameCONFIG.xml file and amended the property... <ToolInDB value="False"/> to <ToolInDB value="True"/>.


But when I bring the macro onto the canvas in Alteryx designer it still has green input/output anchors, even though if I right click and hit 'open' I get the in-db macro inputs/outputs as I edited.


I've attached the file which you can unzip and drop into the following folder (C:\Users\BenMoss\AppData\Roaming\Alteryx\Tools) so you can see the problem yourselves.


Any advice here? Or is it just not possible?









Hi @BenMoss,


Yep perfickly possible I believe.


In the config file use Type="LockIn" and that makes them Blue...


      <Connection Name="Input" AllowMultiple="True" Optional="True" Type="LockIn" Label=""/>
      <Connection Name="Output1" AllowMultiple="False" Optional="False" Type="LockIn" Label="1"/>


Hope it helps




Alteryx Certified Partner
Alteryx Certified Partner

Thanks James, I ammended the file accordingly but no luck still, new version of the config file attached, and code snipit for this specific part...


      <Connection Name="I" AllowMultiple="False" Optional="False" Type="LockIn" Label="I"/>
      <Connection Name="O" AllowMultiple="False" Optional="False" Type="LockIn" Label="O"/>

Am I missing anything?

Try the attached - got blue anchors on mine (2018.3)


Alteryx Certified Partner
Alteryx Certified Partner

You are a star @jdunkerley79, thank you!


I'll share the finished result once it's complete!