community
cancel
Showing results for 
Search instead for 
Did you mean: 

Dev Space

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

In-DB Macro - HTML GUI SDK

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi!

 

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.

 

https://community.alteryx.com/t5/Engine-Works-Blog/Building-an-HTML-Macro/ba-p/158691

 

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?

 

Ben

 

 

 

 

 

 

Hi @BenMoss,

 

Yep perfickly possible I believe.

 

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

 

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

 

Hope it helps

 

J

 

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...

 

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

Am I missing anything?

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

2018-11-09_13-23-01.png

Alteryx Certified Partner
Alteryx Certified Partner

You are a star @jdunkerley79, thank you!

 

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