Standard Macro not return Macro results

[gesh2112]

I am trying to create my first macro.  It seemed really easy.  The macro returns the correct results in the macro.  When I tried to use the macro in a workflow it returns 1 row 1 column.  It seems to be returning what tool was the previous one before it exits the macro.  Can someone give me an idea what I did wrong?

Inside Macro.

In workflow.

[BrandonB]

Are you supposed to be passing in a website URL into your macro from a text input beforehand?

[gesh2112]

Yes.  The macro needs a web page input to retrieve the data from Seismic.  The connection to seismic is a two step process and the first website is static and the second one is inputted into the macro from the workflow.  I need to create 20 workflows to pull data out of Seismic.  I am creating a macro so the first part returns the data into a table so if for some reason passwords change I only have to change it in one spot instead of 20.

[BrandonB]

In the screenshot of the workflow it looks like you don't have anything connected to the macro on the left hand side. Are you using a Macro Input tool within your macro? If it is expecting data and nothing is being fed in it would make sense that nothing is coming out. 

Could you share the interface tools that you are using in your macro? It would be helpful to understand if you are using a Macro Input vs Control parameters. 

[gesh2112]

Here is a screen shot of my macro.  Yes, I am using an input tool to bring in the different website for the second website.  The first website is in the Macro Input.  

[gesh2112]

I started up Fiddler and I don't think it is even running my macro.  There is nothing getting sent or receive from Seismic.  I placed another macro output after the running the first page and it comes back with.  Is there a way to figure out what is causing the macro not to run?

[gesh2112]

So I have been moving the second macro output to figure out what maybe causing the macro not to work.  I now have it located right after the Macro Input.

You see running it inside the macro brings back the first web site in record 1.  But if I run it in the workflow I get this.

[gesh2112 · Accepted solution]

Brandon you where right.  Even though I have a static web page in the macro on the first step.  It still needed me to pass in the static web page again.  I am now getting data.

Thanks for your help.

[BrandonB]

I figured that may be the case. You may also consider taking an alternate approach and leveraging a control parameter to feed in a list of URLs rather than a macro input tool. This will run your workflow one time for every URL row that is passed in as an input. This would be using a batch macro rather than a standard macro. Your decision will ultimately depend on how dynamic the inputs are in nature and what configuration is required. 

Training on a batch macro if you are interested: https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

[BrandonB]

When you use a Macro Input in a standard macro, it is really more of a placeholder than anything. The real data gets passed in upstream and flows into it.