Iterative macro for API Call to Azure DevOps (Error transferring data message)

Question

I'm close to getting my interactive macro working for looping thru the Continuation Token that is passed back from an API call to Azure DevOps.  But I'm getting the below error that I can't resolve.

Error: Iterative Macro (Continuation Token) (79): Iteration #1: Tool #3: Error transferring data: URL using bad/illegal format or missing URL
Info: Iterative Macro (Continuation Token) (79): 0 iterations were run.

Here is the interactive macro.  Any assistance would be great.

Iterative Macro (Continuation Token).yxmc

SeanAdams · Answer

Hey @mtwilliamson

I find iterative macros a little tricky to debug - so what I do is build them as regular old Alteryx flows first - and instead of Macro Inputs, I use a regular input tool bringing in data from "Input.yxdb", and for the macro outputs I'll have the iterator leg overwriting "Input.yxdb", and the results leg going to a browse tool.

This way - you can simulate the behaviour of an iterative macro - every time you run it, it's as if you've done one additional iteration in the macro.

(Alteryx doesn't offer any way natively to debug iteration 2 onwards of an iterative macro - so this is the only real way to simulate it)

TrevorS · Answer

Hello @mtwilliamson 
Here are some posts which work with the same error message you have received.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SFTP-Upload-Error-Error-transferring-data-URL-using-bad-illegal/td-p/436219
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Tableau-Server-URL-using-bad-illegal-format-or/td-p/510294
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Tableau-Server-Error-Messages/td-p/628451

I hope these help you in the right direction!
Thanks,

TrevorS