Skip to content

Typescript: SQL stored procedures  #4

@gee-whiz

Description

@gee-whiz

Hello, in typescript, how can I call a stored procedure to make a POST with parameters for example registering users

const sqlOutput = ouput.sql({
    commandText: 'RegisterUser',
    commandType: 'StoredProcedure',
    connectionStringSetting: 'SqlConnectionString',
});

export async function httpTrigger1(request: HttpRequest, context: InvocationContext): Promise<HttpResponseInit> {
    context.log('HTTP trigger and SQL input binding function processed a request.');

   
}

app.http('httpTrigger1, {
    methods: ['POST'],
    authLevel: 'anonymous',
    extraOutputs: [sqlOutput],
    handler: registerTrainer
});

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions