I am new to azure functions and trying to schedule a python script through Azure Functions. The script is returing following response:
2021-10-08T12:15:00Z [Information] Executing 'Functions.quandldb_update' (Reason='Timer fired at 2021-10-08T12:15:00.0108672+00:00', Id=bf5b53e4-25ed-4d34-aa9e-ffeb91078470) 2021-10-08T12:15:00Z [Verbose] Sending invocation id:bf5b53e4-25ed-4d34-aa9e-ffeb91078470 2021-10-08T12:15:00Z [Verbose] Posting invocation id:bf5b53e4-25ed-4d34-aa9e-ffeb91078470 on workerId:835d8896-9373-4d72-bd44-dca2bc44a708 2021-10-08T12:15:00Z [Error] Executed 'Functions.quandldb_update' (Failed, Id=bf5b53e4-25ed-4d34-aa9e-ffeb91078470, Duration=24ms) My Http Response Code is : 202 Accepted And response body is empty
I am running the below code:
## Libraries needed ## import quandl import pandas as pd import numpy as np from sqlalchemy import create_engine import azure.functions as func def main(req: func.HttpRequest): pd.DataFrame(columns={"ABCD","EFGH"}).to_sql('mry_balance_sheet_test', con=engine, if_exists='append', chunksize=1000) I have added pandas and other imports in requirements.txt
Please find below function.json:
{ "scriptFile": "rawvalues_push.py", "bindings": [ { "name": "mytimer", "type": "timerTrigger", "direction": "in", "schedule": "0 */5 * * * *" } ] } I want to create/update table in my database by calling quandl api. The script is running fine locally on my system, please help me in creating azure function for the same
