This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In AZB Download macro, you can specify the container name & server folder path (optional).
You can also download your file in a subdirectory. You can download your file and read directly to Alteryx, or download your file into a local path. When you choose to read the file directly into Alteryx, you only read the csv/xlsx/txt file(s).
2. AZB Upload
In AZB Upload Tool, you also need to specify the container name & server folder path (optional). You can upload your file from the Alteryx workflow, from a file, or upload it from a local folder. When you uploading your file from Alteryx workflow, you can specify file type (csv, xlsx, or txt) and also specify your sheet name for excel type.
We had the same error pop up over here. We opened the macro, and in the Python tool, the first cell in the code had a typo. Make sure that both references to azure-blob-storage have dashes instead of periods:
Once we changed that, there was a second module error for "wcmatch". I copied the same syntax from cell one and added it to an additional cell, changing the package from 'azure-storage-blob' to "wcmatch" and that was resolved. My assumption is people with more Python experience (I'm a complete noob) probably have this module already installed.
Unfortunately for us, solving the two module installs left us with storage error exceptions we haven't yet overcome (attached the transcript). Any thoughts on how to handle this hot mess?
Would it be possible for you to share the Python code inside the Python tool in the macro? When I download it, it is blank and hence I'm unable to run this macro. I know sometimes Alteryx workflows don't save the code in the Python tool and I'm wondering if that's what happened.
Hi @avanibhatnagar Unfortunately I don't have the code anymore either. I 'poked around' with using that macro but without much success and abandoned the pursuit for other projects. Sorry I couldn't be more helpful!
Hello, thanks for the solution. It's work for me one time and after i got this error:
Error: Azure Blob Upload (2): Tool #12: --------------------------------------------------------------------------- ValueError Traceback (most recent call last) <ipython-input-3-81a1ac2f03a3> in <module> 15 local_folder_path = param.values 16 ---> 17 blob_service_client = BlobServiceClient.from_connection_string(connect_str) 18 19 if upload_from_alteryx == 'True': ~\AppData\Roaming\Python\Python38\site-packages\azure\storage\blob\_blob_service_client.py in from_connection_string(cls, conn_str, credential, **kwargs) 175 :caption: Creating the BlobServiceClient from a connection string. 176 """ --> 177 account_url, secondary, credential = parse_connection_str(conn_str, credential, 'blob') 178 if 'secondary_hostname' not in kwargs: 179 kwargs['secondary_hostname'] = secondary ~\AppData\Roaming\Python\Python38\site-packages\azure\storage\blob\_shared\base_client.py in parse_connection_str(conn_str, credential, service) 364 conn_settings = [s.split("=", 1) for s in conn_str.split(";")] 365 if any(len(tup) != 2 for tup in conn_settings): --> 366 raise ValueError("Connection string is either blank or malformed.") 367 conn_settings = dict((key.upper(), val) for key, val in conn_settings) 368 endpoints = _SERVICE_PARAMS[service] ValueError: Connection string is either blank or malformed.