Is it possible to access invocationid in sql input

[DVGY]

Is it possible to access invocationid in sql input ?

[ejizba]

Hi @DVGY you can access the invocationId on the context object, which is the second argument to your function

[DVGY]

@ejizba thanks for reply. Sorry I did not provide full info. I was going through the below code. Is it possible to somehow access the invocationid inside the parameters. Something like this

input.sql({
parameters:@id={context.invocationid} 
//..rest of the parameters
})

Reference code in this repo

import { app, HttpRequest, HttpResponseInit, input, InvocationContext } from '@azure/functions';

const sqlInput = input.sql({
    connectionStringSetting: 'e2eTest_sql',
    commandText: 'select * from dbo.e2eSqlNonTriggerTable where id = @id',
    commandType: 'Text',
    parameters: '@id={Query.id}',
});

export async function httpTriggerSqlInput(request: HttpRequest, context: InvocationContext): Promise<HttpResponseInit> {
    context.log(`httpTriggerSqlInput was triggered`);
    const items = context.extraInputs.get(sqlInput);
    return { jsonBody: items };
}

app.http('httpTriggerSqlInput', {
    methods: ['GET', 'POST'],
    authLevel: 'anonymous',
    extraInputs: [sqlInput],
    handler: httpTriggerSqlInput,
});import { app, HttpRequest, HttpResponseInit, input, InvocationContext } from '@azure/functions';

const sqlInput = input.sql({
    connectionStringSetting: 'e2eTest_sql',
    commandText: 'select * from dbo.e2eSqlNonTriggerTable where id = @id',
    commandType: 'Text',
    parameters: '@id={Query.id}',
});

export async function httpTriggerSqlInput(request: HttpRequest, context: InvocationContext): Promise<HttpResponseInit> {
    context.log(`httpTriggerSqlInput was triggered`);
    const items = context.extraInputs.get(sqlInput);
    return { jsonBody: items };
}

app.http('httpTriggerSqlInput', {
    methods: ['GET', 'POST'],
    authLevel: 'anonymous',
    extraInputs: [sqlInput],
    handler: httpTriggerSqlInput,
});

[ejizba]

Ah that makes more sense. These are relevant docs: https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-expressions-patterns

Unfortunately I'm not aware of a way to use the invocation id directly and I don't see it in the docs. If that's something you need, the following repo would be a better place to file an issue to add support: https://github.com/Azure/azure-functions-host/issues

[DVGY]

Thanks alot will look at it.