Hi,
when i run my macro it returns data.. but in my actual workflow it is not reading it in.. where am I going wrong?
Hey @wonka1234,
This is basically impossible to troubleshoot without having the actual macro :D
Your Input in your Macro is most likely different to the input in the main-workflow.
I'd recommend that you use the debug mode (Interface Designer, second option) here you can paste the input from your main-datastream in and see how it behaves within the macro.
Running the macro alone will use the values in the Macro Input that are specified - the values you are passing through in your workflow aren't going through your macro properly.
To debug this, I would go into your macro and open Interface Designer. Then go to the test view, insert test values (if you have other Interface tools) and click "Open Debug". This will open up a workflow to test on - you can affect the Text Input that it'll put at the beginning with the value you are trying to pass in on the workflow and see how it passes through the debug workflow.
Of note, make any needed changes in the original macro and not the debug workflow!