getting github repository data file into alteryx

Question

i have created a repository in github and added a sample superstore data into the repository which is of xls format.Now, i want to use this dataset into alteryx . i have copied the address, then opened new workbook in alteryx and used input data tool and created 2 columns url and filename, then download tool i used the field as url and output to BLOB and then i used blob convert tool where in conversion mode i used convert from a blob field and in blob filed i selected download data,after that file name field is missing, i tried multiple ways to get that but cant able to get, so suggest me a way to solve

my ultimate aim is to get the data from my repository in git to loading in alteryx and taking output in desired format as per needs, suggest me a solution or workflow process to get the result

Screenshot (219).png

Gaurav_Dhama_ · Answer

Try downloading the file as "To file using filename. Don't forget to add the extension of the file you are downloading.", download tool will give you the path once it is downloaded, then use a dynamic input to read the file.

Honestly that will be the easiest approach to work with files. I use this when dealing with APIs and Files.

apathetichell · Answer

So ignoring that the architecture which doesn't make any sense to me -- -I'll try to solve your problem as is.

1) you are downloading files from a URL.

Do you want to input this data as a specific type into Alteryx after downloading --- if so you will use a batch macro. You can use Python --- but you'll use a batch macro because that's the way to do it.

you will send the filename/location which you set in your download tool to your batch macro -- -and into your input data. you'll need to control the filetype based upon the alteryx internal file type. Maybe this is an xlsx file? If it's an xls file --- I'm out done. XLS is a crazy bad format to be using in 2025 --- so your client has to be paying you enough to figure this out if you have to use it.

2) the blob tools you are using are for inputting blob files, or converting blob files to use as blobs for converting --- not really for inputting. So if it's a blob encoded csv --- sure you can figure out the conversion --- turn it into a single column/single cell- and then parse but if the blob is an xlsx ---  you cannot get the data from your binary blob into an Alteryx workflow without using an input data (or python tool).