Azure function blob trigger blob paratemer error

Question

I am using a blob trigger to read the blob contents, process as a pandas DF and append the blob to the Azure SQL server I am using.

The blob trigger didn't work as expected so I defined all code in the main function as such:

def main(myblob: func.InputStream):
    logging.info(f"Python blob trigger function processed blob \n"
                 f"Name: {myblob.name}\n"
                 f"Blob Size: {myblob.length} bytes")
    file = re.sub(r'^(.*?)\/','',myblob.name)
    if file not in processedfiles:
        stream = BytesIO((myblob.read()))
        stream.seek(0)

However I get the following error:

Exception: FunctionLoadError: cannot load the BlobFileTrigger function: 
binding myblob has invalid non-type annotation <sqlalchemy.sql.functions._FunctionGenerator object at 0x7faa340f6a00>

Can someone help me find the cause of this issue?

The function.json is configured as follows:

{
  "scriptFile": "__init__.py",
  "disabled": false,
  "bindings": [
      {
          "name": "myblob",
          "type": "blobTrigger",
          "direction": "in",
          "path": "input/{name}",
          "connection":"StorageConnection"
      }
  ]
}

RajkumarPalnati · Accepted Answer · 2022-05-25 12:25:03Z

1

The configured function.json file is fine.
If you are getting an empty byte string, so use the seek(0) method first then Read() from stream.
Make sure that if condition is proper on the processedfiles, because if it's not found any files in processedfiles then only your case will execute.

i.e.:- stream = BytesIO((myblob.read()))

Reference: read() and getvalue() methods of Python io.BytesIO

Azure Functions with Blobtrigger in Python

edited May 25, 2022 at 12:25

answered May 25, 2022 at 12:20

RajkumarPalnati

7094 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Stijn Over a year ago

It seems importing azure.functions as func collides with func from sqlalchemy, i'll rename and try again. learn.microsoft.com/en-us/answers/questions/568041/…

RajkumarPalnati Over a year ago

@Stijn, try with that name like az_func like that and check.

Stijn Over a year ago

yes, thanks again! After renaming to az_func the script worked as intended!

Collectives™ on Stack Overflow

Azure function blob trigger blob paratemer error

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related