Enter Input to a Custom Connector to Download Data in a loop

Hello,

I am trying to create a macro which inputs text in a Custom Connector. I have an excel file which has 10 Binder ID's which needs to be inserted in below text box marked in red to download the tables one by one . Macro should get Binder ID from excel file and Input into Binder ID field -> Run the workflow -> Download the table data -> Again input the 2nd Binder ID -> Run Workflow -> Download table data and process goes on until all binder ids are inserted and all tables are downloaded to excel file. I would appreciate it if you if you can send me a sample workflow.

Pic1 Binder.png

Binder ID Excel file:

pic 2 bin.JPG

Macros

Accepted answers

danilang

Hi @AniK

You do this the same way as you would for any other type of tool. It's difficult to give you a specific example, since you building a custom connector, but here's the basics of how you'd build a batch macro using the Azure Data Lake File Input connector

Attach a Control Parameter or other input tool to your connector. In the config of the Action tool, specify the Attribute that you want to update

You put the macro in a calling workflow and pass the Bin Numbers to the control parameter. Each iteration of the macro, the Bin number gets updated in the connection tool. Here's an Alteryx tutorial on build a batch macro

Dan

All comments

danilang

Hi @AniK

Attach a Control Parameter or other input tool to your connector. In the config of the Action tool, specify the Attribute that you want to update

Dan

AniK

Thanks @danilang. Can you let me know why we are using control parameter?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335