api网关将请求Map到输入事件对象

{
    "resource": "Resource path",
    "path": "Path parameter",
    "httpMethod": "Incoming request's method name"
    "headers": {Incoming request headers}
    "queryStringParameters": {query string parameters }
    "pathParameters":  {path parameters}
    "stageVariables": {Applicable stage variables}
    "requestContext": {Request context, including authorizer-returned key-value pairs}
    "body": "A JSON string of the request payload."
    "isBase64Encoded": "A boolean flag to indicate if the applicable request payload is Base64-encode"
}

在您的示例中，根据您使用的segement的别名，您可以通过对适当的事件对象进行分解或通过直接引用来访问id event.pathParameters.id ```
const mysql = require('mysql');

module.exports.handler = (event, context, callback) => {
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: ''
});

//Destructing id from event.pathParameters object
var {id} = event.pathParameters

// Use the connection
connection.query('DELETE FROM sqllambdadb.contacts WHERE id=?', id, function (err, res) {
if (err) throw err;
else if (res.affectedRows>0) callback(err, 'EMail with ID: '+ id + ' deleted!');
else callback(err, 'No row with ID: '+ id + ' found!');
});

connection.end();
};

因此，我设置了yaml，以便在我的url中添加一个参数值：

delete:
  handler: src/delete.handler
  package:
    include:
      - node_modules/**
      - src/delete.js
      - serverlessAPI.iml
  events:
    - http:
        path: contact-management/contacts/{id}
        method: delete
        cors: true
        integration: LAMBDA
        request:
          parameters:
            paths:
              id: true

通过此配置，id将直接保存在event.id下的event对象中，因此您可以像这样简单地访问它：

module.exports.handler = (event, context, callback) =>{
const mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'testt123'
});
var id = event.id;
// Use the connection
connection.query('DELETE FROM sqllambdadb.Contacts WHERE id=?', id, function (err, res) {
    if (err) throw err;
    else if (res.affectedRows>0) callback(err, 'EMail with ID: '+ id + ' deleted!');
    else callback(err, 'No row with ID: '+ id + ' found!');
});
connection.end();
};

您可以通过使用以下输入创建testcase来测试它：

{
  "id": "$input.params('id')"
}